sss

Microsoft Power BI Training Courses

Use Microsoft’s range of BI (Business Intelligence) tools to analyse data sets quickly, provide visual insights via reports and dashboards and to share that data with colleagues.

Choose from Power BI or Power Query to learn how to get the most from your data using Microsoft BI.

Power BI Desktop Intermediate course

1 Day

This Power BI Desktop Intermediate course is aimed at more experienced Power BI users.  The course delves into more complex data relationships, the use of some advanced DAX formulas and queries, working from different data sources, time intelligence, and charts.  Delegates will learn how to customise the data model through visualisations and dashboard tiles.

Download PDF

What will you learn?

At the end of this Introduction to Power BI Desktop Data Modelling course, delegates will be able to:
  • Use different data sources
  • Use Visualisations and Charts to convey data efficiently
  • Use more advanced DAX and Time intelligence functions
  • Use query parameters
  • Design and deploy Dashboards

Audience?

Business/Data analysts or anyone who needs to interpret and communicate large quantities of information clearly.

Course Contents


Data Sources

  • Using Excel, CSV/Text files, Folders and SQL server as data sources

Filtering Visualisations

  • Creating and using Hierarchies
  • Using Drill Down and Drill Through
  • Custom Tooltips

Time Intelligence

  • Time Intelligence Functions
  • Comparison with Previous periods
  • Aggregations over time

Advanced DAX Functions

  • ALL
  • FILTER
  • X Functions
  • HASONEVALUE
  • Other functions

Using Queries

  • Creating and using Query Parameters
  • Dealing with errors

Charts

  • Dual- Axis
  • Gauge and Ribbon charts
  • Custom visuals

Preparing for Publishing

  • Adding bookmarks
  • Creating action buttons
  • Setting up User Roles

Publishing to the Power BI Service

  • Publish your Report to PowerBI.com
  • Creating Dashboards
  • Using Quick Insights
  • Using Q&A for interactive data searching

Course Materials

Enliten IT will provide each delegate with a workbook, in Adobe pdf format, and other useful reference materials where applicable. Enliten IT reserves the right to modify course content and materials as required in the interests of continuous course improvement, at any time, without notification.
“Excel 2016 Intermediate course review "Marko was very helpful, patient and most importantly passionate" - Kristina PVH (Tommy Hilfiger) - Feb 2019  ”Excel 2016 Intermediate course review

Additional Information

NOTE:   We only offer this Power BI Desktop Intermediate course on a private in-house basis. The suggested course duration is a guideline.  Course topics and duration may be modified by the instructor based upon the knowledge and skill level of the course participants.

Contact us to discuss your training needs...

0845 108 5481 0845 108 5481
info@enliten-it.com info@enliten-it.com