- Home >
- Continuing Education
- > Microsoft Power BI Training Course Outline
Microsoft Power BI Training Course Outline
Important Power BI Training Course Information
Module 1: Get Started with Microsoft Data Analytics
- Data Analytics and Microsoft
- Explore the different roles in data
- Identify the tasks that are performed by a data analyst
- Describe the Power BI landscape of products and services
- Getting Started with Power BI
- Lab: Getting Started
- Use the Power BI service
Module 2: Prepare Data in Power BI
- Get data from various data sources
- Optimize performance
- Resolve data errors
- Identify and retrieve data from different data sources
- Understand the connection methods and their performance implications
- Lab: Preparing Data in Power BI Desktop
- Use Microsoft Dataverse
- Connect to a data flow
Module 3: Clean, Transform, and Load Data in Power BI
- Apply data shape transformations
- Enhance the structure of the data
- Profile and examine the data
- Lab: Transforming and Loading Data
Module 4: Design a Data Model in Power BI
- Understand the basics of data modeling
- Working with tables
- Implement Dimensions and Hierarchies
- Lab: Data Modeling in Power BI Desktop
- Create and Define Model Relationships and their cardinality
- Configure Tables
- Review the model interface
- Create Quick Measures
- Create histograms and rankings
- Lab: Advanced Data Modeling in Power BI Desktop
- Configure many-to-many relationships
- Enforce row-level security
Module 5: Create Measures using DAX in Power BI
- Understand DAX and DAX context
- Use DAX for simple formulas and expressions
- Lab: Introduction to DAX in Power BI Desktop
- Use the CALCULATE() function to manipulate filter context
- Work with Time Intelligence and Key Performance Indicators
- Lab: Advanced DAX in Power BI Desktop
- Create calculated tables and measures
- Create calculated columns
- Create and build simple measures
Module 6: Optimize Model Performance
- Understand the importance of variables
- Optimize the model for performance
- Optimize DirectQuery Models
- Optimize the storage model
- Create and manage Aggregations
Module 7: Create Reports
- Design a report page layout
- Enhance the report with effective visualizations
- Add basic report functionality
- Add report navigation and interactions
- Improve report performance
- Design for accessibility
- Lab: Designing a report in Power BI
- Create a live connection in Power BI Desktop
- Design a report
- Configure visual fields and format properties
- Lab: Enhancing Power BI reports with interaction and formatting
- Create and configure Sync Slicers
- Create a drillthrough page
- Apply conditional formatting
- Create and use Bookmarks
Module 8: Create Dashboards
- Create a Dashboard
- Understand real-time Dashboards
- Enhance Dashboard usability
- Lab: Designing a report in Power BI Desktop - Part 1
- Pin visuals to a Dashboard
- Configure a Dashboard tile alert
- Use Q&A to create a dashboard tile
Module 9: Create Paginated Reports in Power BI
- Explain paginated reports
- Create Paginated reports
- Lab: Creating a Paginated report
- Use Power BI Report Builder
- Design a multi-page report layout
- Create and configure a data source and dataset
- Work with charts and tables
- Create a report parameter
- Export a report to PDF
Module 10: Perform Advanced Analytics
- Explore statistical summary with Advanced Analytics
- Use the Analyze feature to gain Data Insights through AI visuals
- Lab: Data Analysis in Power BI Desktop
- Create animated scatter charts
- Use the visual to forecast values
- Identify outliers in data
- Conduct time-series analysis
- Use the AI visuals
- Use the Advanced Analytics custom visual
- Work with Decomposition Tree visual
- Work with the Key Influencers visual
Module 11: Manage Datasets in Power BI
- Create and work with parameters
- Manage datasets
- Configure dataset refresh
- Troubleshoot gateway connectivity
- Understand the aspects of Power BI security
- Configure row-level security roles and group memberships
Module 12: Create and Manage Workspaces in Power BI
- Creating Workspaces
- Sharing and Managing Assets
- Create and manage a workspace
- Lab: Publishing and Sharing Power BI Content
- Map security principals to dataset roles
- Share a dashboard
- Understand workspace collaboration
- Monitor workspace usage and performance
- Publish and Distribute an App