Microsoft Power BI Data Analyst Bootcamp PL-300

Schedule

The time frames are only estimates and may vary according to how the class is progressing.

Day 1: Prepare and Model the Data in Power BI (300 minutes)

Course Introduction (15 minutes)

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

Get Data Into Power BI (30 minutes)

• Presentation: Connect to different data sources
• Change data source settings
• Create a local model or connect to a shared model
• Understand different storage modes (DirectQuery, Import, Dual)
• Q&A
• Break

Data Cleaning (20 minutes)

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

Data Transformation and Loading (75 minutes)

• Presentation: Choose the appropriate data types for columns
• Create and transform columns
• Design a star schema
• Implement duplicate and/or reference queries
• Implement merge and/or append queries
• Identify relationship keys
• Common query transformations (Unpivot, Transpose, Group By, etc.)
• Q&A
• Break

Design Data Model (40 minutes)

• Presentation: Configure table and column properties
• Implement role-playing dimensions
• Configure relationship cardinality and cross-filter direction
• Create a calendar table
• Q&A

Enhance Data Model With DAX (60 minutes)

• Presentation: Create single aggregation measures
• Use CALCULATE function to manipulate the filter context
• Implement time-intelligence functions
• Understand implicit vs explicit measures
• Create calculated columns and tables
• Implement DAX calculation with quick measures
• Q&A
• Break

Optimize Model Performance (30 minutes)

• Presentation: Implement performance improvements by removing unnecessary data
• Use Performance Analyzer to identify poorly performing report elements
• Implement performance improvements by choosing the optimal data types
• Implement performance improvements by aggregating the data
• Q&A

Hands-on Lab: Data Transformation, Data Modeling, and DAX Calculations (30 minutes)

• Hands-on lab: Load data into Power BI Desktop
• Transform data with Power Query
• Create a data model
• Enhance the data model with DAX calculations

Day 2: Visualize and Analyze the Data, Manage Workspaces, and Secure Power BI Items (300 minutes)

Introduction and Recap (10 minutes)

• Presentation: Recap learning from the previous day
• Q&A

Create Reports (70 minutes)

• Presentation: Identify and implement appropriate visualization types
• Configure and format visualizations
• Use custom visuals
• Apply custom theme to Power BI report
• Configure conditional formatting
• Implement slicers and filters
• Configure report page
• Create Visual calculations
• Use Paginated reports
• Q&A
• Break

Enhance Reports for Usability and Storytelling (75 minutes)

• Presentation: Create and configure bookmarks
• Create custom tooltips
• Edit interactions between the visuals
• Configure sync slicers and group visuals in the Selection pane
• Configure options for drill down
• Apply sorting
• Export report content
• Design reports for mobile devices
• Enable personalize visuals feature
• Designing for accessibility
• Configure Automatic page refresh
• Q&A
• Break

Identify Patterns and Trends in Data (35 minutes)

• Presentation: Use the Analyze feature
• Apply grouping and binning
• Implement Q&A feature
• Implement AI visuals
• Implement reference lines, error bars, and forecasting
• Identify outliers and anomalies

Create and Manage Workspaces and Assets (25 minutes)

• Create a workspace
• Configure workspace app
• Publish and update items in a workspace
• Create a dashboard
• Understand distribution methods
• Configure subscriptions and alerts
• Promote and certify Power BI content in the workspace
• Understand gateways
• Configure scheduled refresh
• Q&A
• Break

Secure and Govern Power BI Items (25 minutes)

• Assign workspace roles
• Configure Item-level access
• Configure access to semantic models
• Implement Row-Level security
• Configure membership for row-level security
• Apply sensitivity labels to data

Hands-on Lab: Data Visualization and Storytelling (30 minutes)

• Hands-on lab: Create a Power BI report
• Choose appropriate visualization types
• Enhance the user experience with advanced visualization features (i.e. tooltips, drillthrough pages)
• Apply sorting and filtering

Practical Exam Tips, Quiz, and Closing (30 minutes)

• Presentation: How to prepare for the exam - practical tips, tricks and recommendations
• Discussion: What do you expect from the certificate?
• Quiz: Check participants’ knowledge in an interactive quiz using Slido (10 questions)
• Q&A session
• Wrap up and feedback