Basic PowerBI

Learn how to prepare, model, and present data using PowerBI-- from processing data to preparing basic dashboards.

INCLUSIONS

F or onsite:

1. printed handout
2. printed certificate
3. snacks (AM and PM)
4. lunch (fastfood)
5. candies and coffee
6. WIFI access

Bring own laptop.

F or via Zoom:

PDF handout

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.

Outline

This training includes a thorough review of the basics of MS Power BI in connecting and transforming data, and presenting using charts/visuals.

Part 1. The PowerBI Interface

• Setting Up PowerBI for First Time Use
• Understanding the PowerBI Interface

Part 2. Connecting Data using Power Query

• Using the Query Editor
• Conditional Columns
• Text-Related Problems
• Math Formulas in Power Query
• Importing Data Using Folder Approach
• Managing Data Source Settings
• Formatting Data

Part 3. Data Modeling using Table Relationships

• Introduction to Table Relationships
• Creating Relationships between Data Sources
• Editing Table Relationships

Part 4. Data Visualization

• Adding Simple Objects to the Power BI Canvas
• Basic Charts and Formatting Options
• Report Filtering Options
• Basic Matrix Visuals
• Slicers
• Basic Card Visual
• Geospatial Data and Mapping
• Publishing Reports