Course Objectives

• Describe key features of a self-service BI solution
• Describe Power BI and its data sources
• Model, shape, and combine data
• Describe Power BI data visualizations

Curriculum

Module 1: Introduction to Self-Service BI Solutions

• Introduction to business intelligence, data analysis, data visualization
• Overview of self-service BI
• Considerations of self-service BI
• Lab: Exploring an enterprise BI solution

Module 2: Introducing Power BI

• The Power BI service
• Power BI mobile apps
• Lab: Creating a Power BI dashboard

Module 3: Power BI Data

• Using Excel as a Power BI data source
• Using databases as Power BI data sources
• Lab: Import data into Power BI

Module 4: Shaping and Combining Data

• Power BI desktop queries
• Shaping and Combining Data
• Lab: Shaping and combining data

Module 5: Modelling Data

• Relationships
• DAX queries
• Calculations and measures
• Lab: Modelling data

Module 6: Interactive Data Visualizations

• Creating Power BI reports
• Managing a Power BI solution
• Lab: Creating a Power BI report