Computer Technology
Analyzing Data With Power BI
Duration (Days)
3
Overview
This is a 3 days course designed to give participants a good understanding of data analysis with Power BI. Participants will learn how to connect excel data, collaborate with Power BI data, data stores , mobile app and develop API
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
Course Outline
-
Introduction to business intelligence
-
Introduction to data analysisIntroduction to data visualization
-
Overview of self-service BI
-
Considerations for self-service BI
-
Microsoft tools for self-service BI
-
Power BI
-
The Power BI service
-
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
-
Power BI desktop queries
-
Shaping data
-
Combining data
-
Relationships
-
DAX queries
-
Calculations and measures
-
Creating Power BI reports
-
Managing a Power BI solution
-
Cloud data
-
Connecting to analysis services
-
The developer API
-
Custom visuals
-
Power BI mobile apps
-
Using the Power BI mobile app
-
Power BI embedded