Course Overview
This 4-day, instructor-led course teaches participants to use Power BI for data analysis. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App. This is a refresh to the preceding versions to take account of changes in the Power BI service. After completing this course, students will be able to do the following:
- Describe self-service BI.
- Describe the Power BI suite of products.
- Connect to data sources and optimize data models.
- Shape and combine data from different sources.
- Model data.
- Create reports and manage solutions.
- Describe the Power BI developer API.
- Describe the Power BI mobile app.
There are no prerequisites for this course.
Schedule
MS 20778: Analyzing Data with Power BI
date
location
price
Duration
4 Days
Price
$2,395
Course Outline
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
Introducing Power BI
- Power BI
- The Power BI Service
Power BI Data
- 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
Shaping and Combining Data
- Power BI Desktop Queries
- Shaping Data
- Combining Data
Modeling Data
- Relationships
- DAX Queries
- Calculations and Measures
Interactive Data Visualizations
- Creating Power BI Reports
- Managing a Power BI Solution
Direct Connectivity
- Cloud Data
- Connecting to Analysis Services
Development with Power BI
- The Power BI API
- Custom Visuals
Power BI Mobile
- Power BI Mobile Apps
- Using the Power BI Mobile App