Intermediate-Advanced MS Power BI

As organizations move beyond basic dashboards, the real value of Microsoft Power BI lies in how effectively data is modeled, analyzed, and transformed into actionable insights. This program bridges the gap between foundational usage and advanced analytical capability—equipping participants to build scalable models, dynamic dashboards, and intelligent reports using DAX and advanced visualization techniques.

• Strengthen foundational Power BI skills for better report building
• Design efficient data models using relationships and transformations
• Create interactive, insight-driven dashboards with advanced visuals
• Apply DAX to produce dynamic, context-aware calculations
• Optimize reports for usability, storytelling, and decision-making

• Data analysts and reporting specialists
• Business users working with dashboards and KPIs
• Excel users transitioning into Power BI
• Team leads and decision-makers who rely on data insights

1. Guided Hands-On Build
   Participants develop a full Power BI report step-by-step—from raw data to final dashboard
2. Scenario-Based Problem Solving
   Real-world cases requiring modeling fixes, DAX logic, and visualization improvements

INCLUSIONS

For onsite:

1. printed handout
2. printed certificate
3. snacks (AM and PM)
4. lunch (fastfood)
5. candies and coffee
6. WIFI access

For via Zoom:

1. PDF handout
2. PDF certificate

Where in Cubao:

Mpower Learning Manila

222 Vivaldi Residences, 628 EDSA cor Aurora Blvd., Cubao, Quezon City

Part 1. Review of Basic PowerBI

Setting up PowerBI

Connecting Data using PowerQuery

Creating Basic Visuals

Publishing Reports

Hiding Elements from Published View

Publishing in Mobile View

Part 2. Data Modeling using Table Relationships​

Editing Table Relationships

Fixing Data Relationship Problems

Part 3. Advanced Data Visualizations

Report Filtering Options

Creating Advanced Charts

Forecasting using PowerBI

Gauge Charts

Other Charts

Using Hierarchy

Creating Drill Down Reports

Organizing the Data Pane

Applying Report Themes

AI Charts

Q&A Charts

Creating Synonyms for AI Charts

Part 4. Using DAX Formulas

Understanding Implicit and Explicit Measures

Creating Calculated Columns and Calculated Measures

Using Calculated Measures in Visuals

Using DAX Formulas

Common DAX Functions

Iterator X Functions

RELATED Function

CALCULATE Function

ALL Function

Know what’s Happening Next — before everyone else does.

Get App

Host or Publisher Insights Training