Intermediate MS Power BI

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

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

Event Venue & Nearby Stays

Mpower Learning Manila, 222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd, Mandaluyong City, Philippines