- Module 1: Steps of installing the required software on your computer so that you can complete this course.
This module explains the following concepts:
- The system requirements needed to work with Power BI
- How to install the Power BI Desktop application
- The required course files to complete the modules
- Module 2: Learn to access and prepare data for Power BI Desktop.
This module explains the following concepts:
- Learn how to load data from common data sources like Microsoft Excel and Comma-Separated Values (CSV) files.
- Understand how to clean the data and prepare it for reporting.
- Understand how to prepare tables using Power Query and load them into the model.
- Module 3: In this module, you build a Power BI data model for the first time. Then use your first data model to explore data, create relationships, add data visualizations, group and bin data, and create a date table.
In this module, you learn:
- Understand how to create relationships to link data property
- how to add and use visualizations
- how to create groups to organize data
- Module 4: In this module, you add measures to a Power BI data model for the first time. You use hierarchies, matrix visuals, and DAX in your data model to explore the data further.
In this module, you practice how to:
- Learn how to create hierarchies for organizing data
- Learn how to add and use matrix visualizations
- Learn to add DAX measures to models for further analysis
- Module 5: Work through exercises to learn about data visualization and reports in Power BI.
This module explains the following concepts:
- Understand how to apply conditional formatting
- Understand how to add custom logos
- Module 6: Follow exercises to learn to import custom visuals and add bookmarks to a report.
This module explains the following concepts:
- Learn how to apply custom report themes
- Learn how to add bookmarks to a report
- Module 7: Learn how to use Power BI to create a mobile view, publish a report, build a dashboard, and use storytelling with Power BI within PowerPoint.
This module explains the following concepts:
- Understand how to design reports for mobile
- Understand how to publish reports to the Power BI Service
- Understand how to build dashboards
- Module 8: Learn how to share Power BI dashboards, collaborate with other users, and access a dashboard on a mobile device.
This module explains the following concepts:
- Understand Power BI collaboration and distribution
- Understand how to access reports from a mobile device
Overview
Syllabus
- Module 1: Module 1: Introduction and prerequisites for Power BI – Online workshop
- Introduction to Power BI
- Install the Power BI Desktop application
- Tour of Power BI Desktop
- Unzip the course files
- Check your knowledge
- Summary
- Module 2: Module 2: Access and prepare data for Power BI Desktop - Online workshop
- Introduction
- Exercise - Load data from various sources into Power BI
- Exercise - Perform common data cleaning practices
- Check your knowledge
- Summary
- Module 3: Module 3: Build your first data model and explore the data by using Power BI - Online workshop
- Introduction
- Create model and explore the data
- Create missing relationships and use data visualizations
- Group and bin data
- Create a date table
- Check your knowledge
- Summary
- Module 4: Module 4: Use hierarchies and DAX in your first data model - Online workshop
- Introduction
- Use hierarchies in your data model
- Build a matrix visual
- Build DAX measures
- Knowledge check
- Summary
- Module 5: Module 5: Data visualization and reports in Power BI - Online workshop
- Introduction
- Apply conditional formatting
- Exercise - Add a logo to the manufacturer filter
- Exercise - Apply a custom report theme
- Check your knowledge
- Summary
- Module 6: Module 6: Import custom visuals and add bookmarks to a report in Power BI - Online workshop
- Introduction
- Exercise - Import custom visuals
- Exercise - Add bookmarks to a report
- Check your knowledge
- Summary
- Module 7: Module 7: Publish and access reports in Power BI service – Online workshop
- Introduction
- Exercise – Create a mobile report view
- Exercise – Publish a report to the Power BI service
- Exercise – Build a dashboard
- Check your knowledge
- Summary
- Module 8: Module 8: Interact, share, and collaborate Power BI dashboards – Online workshop
- Introduction
- Exercise – Power BI service interaction and personalization (Bookmarks, alerts, Q&A)
- Exercise – Share your work with Power BI apps
- Exercise – Access the report from your mobile device
- Check your knowledge
- Summary
