Intermediate Microsoft Power BI Training
| Start Date | End Date | Venue | Fees (US $) | ||
|---|---|---|---|---|---|
| Intermediate Microsoft Power BI Training | 16 Nov 2026 | 18 Nov 2026 | Dubai, UAE | $ 2,500 | Register |
| Intermediate Microsoft Power BI Training | 30 Nov 2026 | 02 Dec 2026 | Live-Online | $ 1,800 | Register |
Intermediate Microsoft Power BI Training
| Start Date | End Date | Venue | Fees (US $) | |
|---|---|---|---|---|
| Intermediate Microsoft Power BI Training | 16 Nov 2026 | 18 Nov 2026 | Dubai, UAE | $ 2,500 |
| Intermediate Microsoft Power BI Training | 30 Nov 2026 | 02 Dec 2026 | Live-Online | $ 1,800 |
Introduction
This course is a continuation from the Fundamentals Power Bi course.
Learn how to get the most out of Power Query by editing and shaping the data before it lands into Power BI with M code.
Learn about Measures which are powerful functions written with DAX that can extract answers directly from the data.
Use DAX to automate settings inside Visuals and use Bookmarks and Buttons to help consumers navigate your reports.
Objectives
- Gain insight into business intelligence and how to use DAX in Power BI.
- Learn about Data Modelling and connect multiple data tables.
- Create a Date Table for better date related insights.
- Create a range of interactive visualisations including a range of charts, tables, matrixes and maps.
- How to publish and share your data.
Training Methodology
This is an interactive course. There will be open question and answer sessions, regular group exercises and activities, videos, case studies, and presentations on best practice. Participants will have the opportunity to share with the facilitator and other participants on what works well and not so well for them, as well as work on issues from their own organizations. The online course is conducted online using MS-Teams/ClickMeeting.
Who Should Attend?
Course Outline
Power Query Editor
- Advanced data transformation
- Cleaning irregularly formatted data
- Adding Columns
- Merge and Append Queries
- Query from a Folder
- View and Edit M Code
M Functions
- Text and dates Date functions
- Column from Examples
- Custom Column Functions
- Blank queries
Modelling in Power BI
- Database relationships
- Create calculated DAX columns
- Create calculated measures with DAX
Dates
- Create Date tables CALENDERAUTO function
- Working with time-based data
- Date based data comparisons with DAX
- SAMEPERIODLASTYEAR function
- TOTALYTD and TOTALMTD
- functions
DAX
- Columns and Measures
- CALCULATE
- SUMX, AVERAGEX etc.
- FILTER
- ALL, ALLEXCEPT, ALLSELECTED
- IF, SWITCH, FIND
- RELATED
- Manage Measures
- DAX Structure
DAX in Visualisations
- Use Measures to populate Fields in Visualisations
- Conditional Formatting
User Navigation
- Bookmarks
- Buttons
- Hyperlinks
Custom Tooltips
- Tooltip Page
- Applying Tooltips
Power BI Service - Workspaces and Apps
- Creating a Workspace
- Managing Workspace Access
- Publish to a Workspace
- Create and Publish an App

