Microsoft Power BI

Prerequisite

To ensure your success, you should have experience managing data with a spreadsheet program such as Microsoft Excel or Google Sheets. To meet this prerequisite, you can take any one or more of the following Logical Operations courses:

• Microsoft® Office Excel® 2016: Part 1 (Desktop/Office 365™)
• Microsoft® Office Excel® 2016: Part 2
• Using Google G Suite™

Lesson 1: Analyzing Data with Self-Service BI
Topic A: Data Analysis and Visualization for Business Intelligence
Topic B: Self-Service BI with Microsoft Power BI

Lesson 2: Connecting to Data
Topic A: Create Data Connections
Topic B: Model Data with Relationships
Topic C: Save Power BI Files

Lesson 3: Performing Advanced Data Modeling and Shaping
Topic A: Clean and Transform Data with the Query Editor
Topic B: Shape Data with the Query Editor
Topic C: Combine and Manage Data Rows

Lesson 4: Visualizing Data with Power BI
Topic A: Create Visualizations in Power BI
Topic B: Chart Data in Power BI

Lesson 5: Enhancing Data Analysis
Topic A: Enhance Analysis with Customized Visuals and Pages
Topic B: Enhance Analysis with Tooltips

Lesson 6: Modeling Data with Calculations
Topic A: Create Calculations with Data Analysis Expressions (DAX)
Topic B: Create Calculated Measures and Conditional Columns

Lesson 7: Creating Interactive Visualizations
Topic A: Create and Manage Data Hierarchies
Topic B: Filter and Slice Reports
Topic C: Create Dashboards in Power BI

Lesson 8: Performing Advanced Analysis
Topic A: Create Calculated Tables, Variables, and Parameters
Topic B: Enhance Visuals with Statistical Analysis
Topic C: Review Analysis Services Connection Options

Lesson 9: Publishing and Sharing Reports and Dashboards
Topic A: Publish Reports
Topic B: Share Reports and Dashboards

Lesson 10: Extending Access to Power BI
Topic A: Access Reports Using Power BI Mobile
Topic B: Extend Access with the Power BI API

Appendix A: Mapping Course Content to the Analyzing and Visualizing Data with Microsoft® Power BI® Certification Objectives