Intermediate-Advanced MS Power BI
- This workshop enhances Power BI skills beyond the basics by teaching advanced data modeling, DAX calculations, and interactive dashboard design.
- It is intended for data analysts, business users, and decision-makers who want to improve their report building and visualization capabilities.
- Participants learn practical techniques to create scalable, insight-driven reports for better business decisions.
About this event
Introduction
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.
Main Objectives
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
Who This Training Is For
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
Methodologies
Guided Hands-On Build
Participants develop a full Power BI report step-by-step—from raw data to final dashboard
Scenario-Based Problem Solving
Real-world cases requiring modeling fixes, DAX logic, and visualization improvements
INCLUSIONS
For onsite:
printed handout
printed certificate
snacks (AM and PM)
lunch (fastfood)
candies and coffee
WIFI access
For via Zoom:
PDF handout
PDF certificate
Where in Cubao:
Mpower Learning Manila
222 Vivaldi Residences, 628 EDSA cor Aurora Blvd., Cubao, Quezon City
Agenda
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
Organiz