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.
What will you learn?
At the end of this Power BI training Intermediate 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.
“"Really great training session. Alan was a great trainer, really engaging and made the session easy to follow and understand. The fact it was remote based training as well made the fact that he was able to keep up all following along and engaged throughout even more impressive!"”
Ben, Software One, Power BI Introduction
Prerequisites
Delegates must have good Power BI and basic DAX knowledge or have attended our Power BI Introduction course.
Additional Information
NOTE: We only offer this Microsoft Power BI training 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.