20778 – Analyzing Data with Power BI

Description

Overview:

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.

Prerequisite(s):

Excellent knowledge of relational databases and reporting, basic knowledge of data warehouse schema topology, exposure to basic programming constructs, awareness of business priorities, and familiarity with Office applications, particularly Excel.

Audience:

The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.

Outline:

Lesson 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 for self-service BI
• Microsoft tools for self-service BI

Lesson 2: Introducing Power BI

• Power BI
• The Power BI service

Lesson 3: Power BI

• Using Excel as a data source for Power BI
• The Power BI data model
• Using databases as a data source for Power BI
• The Power BI service

Lesson 4: Shaping and Combining Data

• Power BI desktop queries
• Shaping data
• Combining data

Lesson 5: Modelling data

• Relationships
• DAX queries
• Calculations and measures

Lesson 6: Interactive Data Visualizations

• Creating Power BI reports
• Managing a Power BI solution

Lesson 7: Direct Connectivity

• Cloud data
• Connecting to analysis services

Lesson 8: Developer API

• The developer API
• Custom visuals

Lesson 9: Power BI mobile app

• The Power BI mobile app
• Using the Power BI mobile app
• Power BI embedded