Analyzing Data with PowerBI (M20778)



The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.

  • Business analysts
  • Business intelligence developers
  • SQL professionals
  • Excellent knowledge of relational databases and reporting
  • Some Basic knowledge of data warehouse schema topology (including star and snowflake schemas)
  • Some exposure to basic programming constructs (such as looping and branching)
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable
  • Familiarity with Microsoft Office applications (particularly Excel)
Learning Objectives
  • Perform Power BI desktop data transformation
  • Describe Power BI desktop modelling
  • Create a Power BI desktop visualization
  • Implement the Power BI service
  • Describe how to connect to Excel data
  • Describe how to collaborate with Power BI data
  • Connect directly to data stores
  • Describe the Power BI developer API
  • Describe the Power BI mobile app
  1. Introduction to Self-Service BI Solutions
  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations of self-service BI
  • Microsoft tools for self-service BI
2. Introducing Power BI
  • Power BI
  • The Power BI service
3. Power BI Data
  • Using Excel as a data source for Power BI
  • The Power BI data model
  • Using databases as a Power BI data source
  • The Power BI service
4. Shaping and Combining Data
  • Power BI desktop queries
  • Shaping data
  • Combining data
5. Modeling Data
  • Relationships
  • DAX queries
  • Calculations and measures
6. Interactive Data Visualizations
  • Creating Power BI reports
  • Managing a Power BI solution
7. Direct Connectivity
  • Cloud data
  • Connecting to analysis services
8. Developer API
  • The developer API
  • Custom Visuals
9. Power BI mobile app
  • Using the Power BI mobile app
  • Power BI embedded

Virtual Classroom Live Labs

  • Lab 1: Exploring an Enterprise BI Solution
  • Lab 2: Creating a Power BI Dashboard
  • Lab 3: Import Data into Power BI
  • Lab 4: Shaping and Combining Data
  • Lab 5: Modeling Data
  • Lab 6: Creating a Power BI Report
  • Lab 7: Direct Connectivity
  • Lab 8: Using the Developer API