Microsoft Power BI Desktop Advanced
![Image of laptop displaying an image containing the words Microsoft Power BI](https://cdn.prod.website-files.com/64e5d9235951ea488bbccb40/65fd49770d4349a9efcc7319_Microsoft%20Power%20BI.webp)
Course Schedule
Course Aims:
This Microsoft Power BI Desktop Advanced training course is for anyone looking to create formulas using the advanced DAX functions. You will create calculations using calculated columns, measures, quick measures, and tables. You will use the Power Query Editor to clean up your data tables and generate structured reports.
Course Pre-requisites:
Delegates should have attended the Intermediate course or have previously used Power BI and can create visuals and basic calculations using calculated Columns & Measures.
Course Objectives:
On completion of this course, delegates will be able to:
- Work in the Power Query Editor to transform data
- Create calculations using Advanced DAX Functions
- Add tooltips, conditional formatting and sparklines to visuals
- Create Custom column calculations
- Append and Merge Queries
Course Content:
Data Sources
- Copying and entering data into a table
- Importing a Folder
Power BI Query Editor (PQE)
- Column Quality / Profile and Distribution
- Detect Data types
- Split Columns
- Use Custom Column to create calculation
- Adding Conditional Column
- Column From Example
- Index Column
- Transpose
- Group By (Basic / Advanced)
- Editing data in an existing table
- Append and Merge queries
Advanced Visualisation Features
- Applying Conditional formatting to dynamic titles
- Using a Slicer to return different results
- Adding Tool Tips Page
- Adding Sparklines (column / lines) to visuals
- Managing Visualisation relationships e.g. properties
Advanced DAX Functions (Calculated columns, Measures, Quick Measures and New Table)
- Relationship Functions (e.g. RELATED, RELATEDTABLE)
- Aggregation and Iteration Functions (e.g. SUMX, AVERAGEX)
- Text Functions (e.g. MID, FIND, FORMAT)
- Logical Functions (e.g. IF, AND, SWITCH)
- Date Functions (e.g. DATEDIFF, DATEADD)
- Filter Functions (e.g. ALL, CALCULATE, FILTER)
- Information Functions (e.g. CONTAINSSTRING, ISBLANK)
- Table Manipulation Functions (e.g. SUMMARIZE, VALUES)
- Time Intelligence Functions (e.g. DATESYTD, DATESMTD)
- Math and Trig Functions (e.g. DIVIDE, ROUNDUP)
Hints and Tips
- Calculations
- Power BI Reports in PowerPoint
- Edit Interactions with Slicers
- Image URL
Public Schedule
Virtual Private Training
Contact us for pricing
Onsite Training
Contact us for pricing
Note
All prices exclude VAT at 20%.
VAT registration number: 450 4347 14
You may also like...
This course is aimed at attendees who want to expand their knowledge into some of the more complex functions, build reports using form controls, work with Power Pivots and use built-in automation offered by Microsoft Excel.
1 Day
Enhance your skills with our Microsoft Visio Intermediate course. Learn advanced diagramming techniques and streamline your workflow efficiently.
1 Day
If you are interested in learning how to use Microsoft Visio to help you create visually engaging diagrams, then this course is perfect for you.
1 Day