• Register
  • FAQs
  • Contact
  • Time Zone
  • Chat on WhatsApp

Power BI Intermediate to Advanced

Batch Price From £210 (approx. $285 USD) View Dates & Prices Short course on Power BI Intermediate to Advanced
Total Duration: 6-Hour
Course level: Intermediate to Advanced
Delivery Method: Instructor Led Online and Classroom Training
Certification: Certificate of Completion will be provided after completing the course.

Course Overview

This instructor-led training course is designed for learners who have a foundational understanding of Power BI and are ready to elevate their skills in data modelling, analytics, and performance optimisation. Participants will explore advanced topics such as efficient data schema design, managing complex relationships, writing sophisticated DAX formulas for time intelligence and context control, and performing powerful data transformations using the M language in Power Query. This course equips participants with the expertise to build highly interactive, efficient, and insightful Power BI solutions for real-world business scenarios.

Course Objects

By the end of the course, students will:

  • Model complex data using star/snowflake schemas efficiently
  • Write powerful DAX expressions including context transition and time intelligence
  • Perform advanced data transformations using the M language
  • Optimise data models and reports for high performance
  • Use forecasting and Python integration for predictive analytics
  • Enhance reports with advanced visuals and conditional formatting

Requirements

  • Basic Power BI knowledge
  • Installed latest version of Power BI Desktop
  • Optional: Power BI Service account for deployment practice

We highly recommend you complete the following course(s) before attending the Power BI Intermediate to Advanced course:

You may also complete the following course(s) before attending the Power BI Intermediate to Advanced course but they are not mandatory:

Course Dates, Prices & Enrolment

All Training Physical Classes Virtual Classes
Time Zone:
Training MethodDates and TimesPrice 
Classroom Training 25 Jul 2025 - 01 Aug 2025
2 Fridays
05:00 AM - 08:00 AM ET
£210
(approx. $285 USD)
Enrol Now
Classroom Training 14 Aug 2025 - 15 Aug 2025
Thursday & Friday
05:00 AM - 08:00 AM ET
£210
(approx. $285 USD)
Enrol Now

Course Content

  1. Advanced Data Modelling & Relationships
    • Star & Snowflake schema design
    • Many-to-many relationships
    • Role-playing dimensions (e.g., multiple date fields)
    • Managing model performance with calculated tables vs. relationships
    • Managing relationships with DAX (e.g., USERELATIONSHIP)
  2. Advanced DAX for Data Analysis
    • Understanding row context vs. filter context
    • Time intelligence functions: SAMEPERIODLASTYEAR, DATESYTD, PARALLELPERIOD
    • Iterator functions: SUMX, AVERAGEX, RANKX
    • Context transition and CALCULATE()
    • Debugging and optimizing DAX
  3. Power Query – Advanced Data Transformation
    • Custom columns using M
    • Merging & appending queries
    • Conditional transformations
    • Handling errors and nulls
    • Parameterizing queries
    • Using functions in Power Query
  4. Advanced Visualisations & UX Design
    • KPI visualizations and custom visuals
    • Bookmarks & buttons for storytelling
    • Drillthrough and tooltip pages
    • Conditional formatting and dynamic visuals
    • Grouping, binning, and segmentation visuals
  5. Performance Optimization & Best Practices
    • Query diagnostics and performance analyzer
    • Reducing model size with summarization
    • Avoiding cardinality issues
    • Using variables in DAX for clarity and performance
  6. Power BI Service & Deployment
    • Publishing to Power BI Service
    • Workspaces and sharing reports
    • Data refresh and scheduled refresh
    • Creating and managing dashboards
    • Row-Level Security (RLS) setup
    • Introduction to Power BI Mobile
Materials Provided
  • Practice datasets
  • Power BI templates and DAX/M cheat sheets
  • Slides and post-course exercise

Share This Course

Newsletter Sign-up

Have a Question?