Name: Intermediate MS Power BI
Start: 2025-04-12T08:00:00+08:00
End: 2025-04-12T17:00:00+08:00
Location: 222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd,Quezon City,1109,PH

Learn how to prepare, model, and present data using PowerBI-- from processing data to preparing dashboards. In this level, the training will
VENUE
-Mpower Training Center
-222 Vivaldi Residences, EDSA cor Aurora Blvd.., Cubao, Quezon City
-Bring own laptop
TIME
All schedules are set at 8AM-5PM. However, if the headcount is low, the training may be set at 9AM-4PM or 9AM-5PM. Your certificate, still, will indicate 8 hours.The start time and end time will be finalized three days before the class. Please look for an email from us or chat with us to confirm.

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
Agenda
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. 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