Analyzing Data with PowerBI (M20778)

COURSE OUTLINE:

Description

In this course, you will be introduced to the key concepts in business intelligence (BI), data analysis, and data visualization. You will discover the capabilities of a self-service BI solution and learn to create a dashboard and Power BI Desktop queries.

Audience

  • Business analysts
  • Business intelligence developers
  • SQL professionals

Prerequisites

  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Basic knowledge of data warehouse schema topology (including star and snowflake schemas)
  • Some exposure to basic programming concepts (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 Power BI data source
  • 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

  • Custom visuals

9. Power BI mobile app

  • Using the Power BI mobile app
  • Power BI embedded