Course Code: advpwbi
Duration: 14 hours
Prerequisites:

📌 Audience

This training is intended for:

  • Experienced Power BI users who want to deepen their expertise
  • Business analysts, data analysts, BI developers
  • Professionals with prior exposure to Power BI modeling and DAX who are seeking to optimize performance and automation

✅ Prerequisites

  • An understanding of core Power BI concepts and dashboard creation
  • Experience with data modeling, report building, and publishing in Power BI
  • Some DAX programming experience (basic level or higher)
Overview:

Power BI Advanced Training is an instructor-led, live training (online or onsite) aimed at advanced-level Power BI users who wish to use advanced data modeling, DAX, and automation tools in Power BI to build high-performing, interactive dashboards and automate BI workflows.

✅ By the end of this training, participants will be able to:

  • Install and configure Power BI Desktop and Power BI Service components.
  • Design optimized data models using star/snowflake schemas and calculation groups.
  • Create advanced DAX measures for complex business scenarios and time intelligence.
  • Implement Row-Level Security (RLS), scheduled refresh, and Power Automate flows.

🧩 Format of the Course

  • Interactive lecture and discussion
  • Lots of exercises and practice
  • Hands-on implementation in a live-lab environment
Course Outline:

Day 1: Advanced Data Modeling & DAX

Session 1: Advanced Data Modeling

• Star vs. Snowflake Schema Design
• Fact & Dimension Table Optimization
• Using Calculation Groups
• Best Practices for Data Model Performance

Session 2: Advanced DAX Concepts

• Deep Dive into Filter Context vs. Row Context
• Variables in DAX
• More Advanced Time Intelligence Functions (YTD, MTD, QTD, SAMEPERIODLASTYEAR)
• Advanced Measures: Cumulative Totals, Moving Averages
• DAX Debugging Techniques (Chat GPT)

 

Day 2: Advanced Visualization, Power BI Service, and Automation

Session 3: Advanced Visualization Techniques

• Custom Visuals (Profitbase Financial Reporting Matrix – extremely useful for building Financial Reports in Power BI)
• Bookmarks & Information Icon’s
• Mobile View
• UX/UI Optimization of Dashboards – Introduction into JSON Theme’s.
• KPI & Goal Tracking with other data sources being used as targets.

Session 4: Power BI Service, Security, and Automation

• Row-Level Security (RLS)
• Workspace Management & App Publishing
• Dataflows vs. Datasets
• Scheduled Refresh & Alerts 
• Power Automate with Power BI
• Integration with Excel, Teams, SharePoint