PL-300: Microsoft Power BI Data Analyst Course

Module 1 Get Started with Microsoft Data Analytics

• Data Analytics and Microsoft
• Getting Started with Power BI

Module 2 Getting Data in Power BI

• Data Analytics and Microsoft
• Optimize Performance
• Resolve Data Errors

Module 3 Cleaning, Transforming, and Loading Data in Power BI

• Shaping the Data
• Profiling the Data
• Enhance the data structure

Module 4 Design a Data Model in Power BI

• Introduction to data modeling
• Working with tables
• Dimensions and Hierarchies
• Create Model Relationships
• Configure Tables and Column Properties
• Create hierarchies

Module 5 Create Model Calculations using DAX in Power BI

• Introduction to DAX
• Real-time dashboards
• Advanced DAX
• Create calculated tables
• Create calculated columns
• Create measures
• Use the CALCULATE() function to manipulate filter context
• Use Time Intelligence functions

Module 6 Optimize Model Performance in Power BI

• Optimize the data model for performance
• Optimize DirectQuery Models

Module 7 Create Reports in Power BI

• Design a report
• Enhance the report
• Create and configure Sync Slicers
• Create a drillthrough page
• Apply conditional formatting
• Create and use Bookmarks
• Design a report
• Configure visual fields and format properties

Module 8 Create Dashboards in Power BI

• Create a Dashboard
• Real-time Dashboards
• Enhance a Dashboard
• Create a Dashboard
• Pin visuals to a Dashboard
• Use Q&A to create a dashboard tile

Module 9 Identify Patterns and Trends in Power BI

• Advanced Analytics
• Data Insights through AI visuals
• Create animated scatter charts
• Use the visual to forecast values

Module 10 Create and Manage Workspaces in Power BI

• Creating Workspaces
• Sharing and Managing Assets

Module 11 Manage Files and Datasets in Power BI

• Parameters
• Datasets

Module 12 Row-level Security in Power BI

• Security in Power BI
• Configure many-to-many relationships
• Enforce row-level security