Microsoft Power BI Data Analyst Bootcamp PL-300

Day 1: Preparing and Modeling Data in Power BI

Course introduction (15 minutes)

• Presentation: Check-in; the agenda and learning outcomes
• Group discussion: What’s your experience level with Microsoft Power BI and related tools?
• Q&A

Getting data into Power BI (45 minutes)

• Presentation: Connecting to different data sources; changing data source settings; creating a local model or connecting to a shared model; understanding different storage modes (DirectQuery, Import, Dual)
• Q&A
• Break

Data cleaning (20 minutes)

• Presentation: Data profiling in Power Query; resolving data inconsistencies; resolving data loading errors

Data transformation and loading (60 minutes)

• Presentation: Choosing the appropriate data types for columns; creating and transforming columns; designing a star schema; implementing duplicate and/or reference queries; implementing merge and/or append queries; identifying relationship keys
• Q&A
• Break

Designing data model (40 minutes)

• Presentation: Configuring table and column properties; implementing role-playing dimensions; configuring relationship cardinality and cross-filter direction; creating a calendar table; implementing row-level security
• Q&A

Day 2: Modeling, Visualizing, and Analyzing Data

Enhancing data model with DAX (75 minutes)

• Presentation: Recap previous day; creating single aggregation measures; using CALCULATE function to manipulate the filter context; implementing time-intelligence functions; understanding implicit versus explicit measures; creating calculated columns and tables; implementing DAX calculation with quick measures
• Q&A
• Break

Optimizing model performance (30 minutes)

• Presentation: Implementing performance improvements by removing unnecessary data; using Performance Analyzer to identify poorly performing report elements; implementing performance improvements by choosing the optimal data types; implementing performance improvements by aggregating the data
• Q&A
• Break

Creating reports (75 minutes)

• Presentation: Identifying and implementing appropriate visualization types; configuring and formatting visualizations; using custom visuals; applying custom themes to Power BI report; configuring conditional formatting; implementing slicers and filters; configuring report page; using the Analyze in Excel feature; using paginated reports
• Q&A

Day 3: Visualizing and Analyzing Data and Deploying Power BI Items

Enhancing reports for usability and storytelling (60 minutes)

• Presentation: Recap previous day; creating and configuring bookmarks; creating custom tooltips; editing interactions between the visuals; configuring sync slicers and group visuals in the Selection pane; configuring options for drill down
• Q&A
• Break

Identifying patterns and trends in data (30 minutes)

• Presentation: Using the Analyze feature; applying grouping and binning; implementing Q&A feature; implementing AI visuals; implementing reference lines, error bars, and forecasting; identifying outliers and anomalies

Creating and managing workspace and items (45 minutes)

• Presentation: Creating a workspace; assigning workspace roles; configuring workspace app; creating a dashboard; applying sensitivity labels to data; configuring subscriptions; promoting and certifying Power BI content in the workspace; configuring semantic model scheduled refresh; configuring membership for row-level security
• Q&A
• Break

Practical exam tips, quiz, and closing (45 minutes)

• Presentation: How to prepare for the exam—practical tips, tricks, and recommendations
• Group discussion: What do you expect from the certificate?
• Hands-on activity: Take an interactive quiz using Slido (10 questions)
• Q&A