Analyzing Data with PowerBI (M20778)

  • Business analysts
  • Business intelligence developers
  • SQL professionals

Prerequisite

  • 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)

Expected Duration
3 day

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.

Objective

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

SUBSCRIPTION COST


$2,295.00

Select Course Options

 

NEED HELP OR NOT SURE?