Intermediate to Advanced Power BI

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

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

VENUE

• Mpower Training Center
• 222 Vivaldi Residences, EDSA cor Aurora Blvd.., Cubao, Quezon City
• Bring own laptop

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

Outline

This training includes a review of the basics of MS Power BI visuals. The module will then proceed with creating complex charts and using DAX functions to perform efficient and better visuals.

• Module 1: Review of Power BI Basics
• • Loading and connecting data
  • Creating relationships between tables
  • Building a basic data model
  • Creating standard charts and tables
  • Using basic filters and slicers
• Module 2: Advanced Data Preparation and Modeling
• • Merging vs. Appending Queries
  • Combining multiple tables and files
  • Unpivoting data for analysis
  • Loading and combining files from folders
  • Managing supporting queries and relationships
• Module 3: DAX Calculated Columns
• • Introduction to DAX
  • Creating calculated columns
  • Text, date, and arithmetic calculations
  • Logical functions: IF, AND, OR, IN
  • Lookup functions: LOOKUPVALUE and RELATED
• Module 4: DAX Measures and Calculations
• • Implicit vs. explicit measures
  • Creating reusable measures
  • SUMX and other iterator functions
  • CALCULATE for conditional calculations
  • Understanding filter context and filter precedence
• Module 5: DAX Tables and Supporting Data
• • Creating calculated tables
  • Generating unique lists
  • Using DAX Query and EVALUATE
  • Creating supporting tables
  • Custom sorting with Sort by Column
• Module 6: Advanced Visualizations and Report Interaction
• • Conditional formatting
  • Creating and using hierarchies
  • Drill-down and expand functionality
  • Matrix and interactive visual techniques
  • Using buttons for report navigation
  • Adding additional visuals from Microsoft Marketplace