Overview
This course is designed for participants who have already attended Power BI Introduction training and who wish to develop their skills in analysing and querying data.
Pre-requisites
You should have attended our Microsoft Power Bi Desktop Introduction course or have equivalent knowledge.
Objectives
By attending this workshop, you will learn how to use Power BI power tools for slicing, querying, shaping and drilling down in to data. You will get hands-on experience learning these skills and concepts using example data.
Content
Working with Query Editor
- Transformation tools
- Create & Use Parameters
- Writing or Editing M language
- Custom Functions
Other Power BI Tools
- Report Drillthrough
- Row Level Security
- Bookmarks & Buttons
- Insert AI Visuals
- Using Page Tooltips
- Using bookmarks
Power BI Service
- Creating workspaces
- Datasets
- Reports
- Creating dashboards
- Managing permissions
- Scheduling auto refresh
DAX
- SWITCH
- Using multiple conditions
- The FIND DAX function
- The IF DAX function
- Logical functions IF, AND, OR
- Dynamic Labels
- CALCULATE Function
- Time Intelligence Functions
- Expression based formatting
- Using the ALL Function
- Iterator Functions
Editing DAX Measures
- Making DAX easier to read
- Add comments to a measure
- Using variables and RETURNS
- Comments
Visualisations In-Depth
- Dynamic Titles
- Expression based formatting
- Building effective visualisations
Have a question?
Let’s get this conversation started. Tell us a bit about your requirements and we’ll be in touch.
What you need to bring for these courses when delivered as a virtual classroom.
For virtual classroom courses, you will need:
- Computer with Internet Access
- Microphone and Headset
- Webcam
- Microsoft Teams
- A dual monitor setup is recommended for IT training