Intermediate MS Power BI

• 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

Where in Cubao:

Mpower Learning Manila

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

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 inquire@insightsmanila.com or chat with us to confirm.

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