Basic PowerBI

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

VENUE

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

INCLUSIONS

F or onsite:

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

F or via Zoom:

1. PDF handout
2. PDF certificate
   

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