Power BI Data Analyst Training Course (PL-300)

In this module, you'll learn how to: 

• Get data from various data sources
• Optimise 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

In this module, you'll learn how to:

• Apply data shape transformations
• Enhance the structure of the data
• Profile and examine the data

Lab: Transforming and Loading Data

In this module, you'll learn how to:

• Understand the basics of data modelling
• Working with tables
• Implement Dimensions and Hierarchies

Lab: Data Modelling 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 Modelling in Power BI Desktop

• Configure many-to-many relationships
• Enforce row-level security

In this module, you'll learn how to:

• 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
• After completing this module, you will be able to:

In this module, you'll learn how to:

• Understand the importance of variables
• Optimise the model for performance
• Optimise DirectQuery Models
• Optimise the storage model
• Create and manage Aggregations

In this module, you'll learn how to:

• Design a report page layout
• Enhance the report with effective visualisations
• 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

In this module, you'll learn how to:

• 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

In this module, you'll learn how to:

• 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
   

In this module, you'll learn how to:

• Explore statistical summary with Advanced Analytics
• Use the Analyse 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
   

In this module, you'll learn how to:

• 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

In this module, you'll learn how to:

• 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