Building Business Intelligence is an online video course that is perfect for anyone looking to build reports and quickly summarize 10s to 1,000s of rows of data quickly. This course will provide the analyst with the best ways to source and clean up source data for reporting. As the data is cleansed, the course will show you how to present the data in a way that is easy to use for analysis by presenting data in both tabular and visually. The course will further explore the best ways to analyze the data and drill in and out of data. By the end of this course, you will feel confident sourcing data, cleansing it, and analyzing it through pivot tables and dashboards.
Overview
COURSE DIFFICULTY
COURSE DURATION
6h 55m
Skills Learned
After completing this online training course, students will be able to:
Build interactive dashboards and reports in Power BI
Design efficient data models with proper relationships
Transform and shape data using Power Query
Publish and share reports through Power BI Service
BI Developers, Data Analysts
None
01. Introduction
02. Desktop Overview
03. Import Data Into Power BI Desktop and Power Query Walk Through
04. Transforming Data - Basic Transforms
05. Transforming Data - Reading and Understanding M
06. Introduction To Data Modeling
07. Creating Calculated Columns
08. Creating Calculated Measures
09. Introduction To Visualizing Data
10. Creating Basic Reports
11. Creating Interactive Reports - Adding Slicers For Filters
12. Creating Interactive Reports - Visualizing Tabular Data
13. Creating Interactive Reports - Visualizing Categorical Data
14. Creating Interactive Reports - Visualizing Data Trends
15. Creating Interactive Reports - Visualizing Categorical And Trend Data Together
16. Creating Interactive Reports - Visualizing Geographic Data With Maps
17. Creating Interactive Reports - Visualizing Goal Tracking
18. Creating Interactive Reports - Using Custom Visuals
19. Using The Power BI Service - Deploying
20. Using The Power BI Service - Setting Up Workspaces
21. Using The Power BI Service - Creating And Sharing Dashboards
22. Using The Power BI Service - Interacting With Q&A
23. Using The Power BI Service - Scheduling A Data Refresh
24. Power BI Mobile (Designing Reports And Dashboards For Power BI Mobile
25. Power BI Mobile
26. Class Wrap Up
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Build interactive dashboards and reports in Power BI
Design efficient data models with proper relationships
Transform and shape data using Power Query
Publish and share reports through Power BI Service
WHO SHOULD ATTEND
BI Developers, Data Analysts
PREREQUISITES
None
COURSE OUTLINE
01. Introduction
02. Desktop Overview
03. Import Data Into Power BI Desktop and Power Query Walk Through
04. Transforming Data - Basic Transforms
05. Transforming Data - Reading and Understanding M
06. Introduction To Data Modeling
07. Creating Calculated Columns
08. Creating Calculated Measures
09. Introduction To Visualizing Data
10. Creating Basic Reports
11. Creating Interactive Reports - Adding Slicers For Filters
12. Creating Interactive Reports - Visualizing Tabular Data
13. Creating Interactive Reports - Visualizing Categorical Data
14. Creating Interactive Reports - Visualizing Data Trends
15. Creating Interactive Reports - Visualizing Categorical And Trend Data Together
16. Creating Interactive Reports - Visualizing Geographic Data With Maps
17. Creating Interactive Reports - Visualizing Goal Tracking
18. Creating Interactive Reports - Using Custom Visuals
19. Using The Power BI Service - Deploying
20. Using The Power BI Service - Setting Up Workspaces
21. Using The Power BI Service - Creating And Sharing Dashboards
22. Using The Power BI Service - Interacting With Q&A
23. Using The Power BI Service - Scheduling A Data Refresh
24. Power BI Mobile (Designing Reports And Dashboards For Power BI Mobile
25. Power BI Mobile
26. Class Wrap Up
