Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep (2024)
5h 38mIntermediate2024-11-09
Authors
Microsoft Press
Microsoft
Chris Sorensen
Course details
Prepare for the PL-300 exam with this in-depth course that helps you master data handling, from sourcing and cleaning to modeling and visualizing, by focusing on the skills measured by the exam’s objectives. Learn how to connect to various data sources, adjust data settings, import data, and clean your data for accurate analysis. Dive into data modeling techniques such as creating calculated tables, optimizing model performance, and implementing security measures. Then, review data visualization essentials for creating compelling, interactive reports. Then, learn how to enhance reports with advanced usability features, identifying key patterns and employing AI-driven insights to elevate the analysis. The course concludes with lessons on deploying and maintaining data assets efficiently within organizational frameworks. Whether you're a business analyst, data analyst, or data engineer, this course can equip you with the skills needed to turn raw data into actionable insights.
Skills covered
Power BIBusiness AnalyticsBusiness IntelligenceData AnalysisCert PrepData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoft
Concepts
0. Introduction
- 01 - Exam PL-300 Microsoft Power BI Data Analyst - Introduction
Module 1 - Prepare the Data
- 02 - Module introduction
Lesson 1 - Get Data from Data Sources
- 03 - Learning objectives
- 04 - Identify and connect to a data source
- 05 - Change data source settings, including credentials, privacy levels, and data source locations
- 06 - Select a shared semantic model, or create a local semantic model
- 07 - Choose between DirectQuery, Import, and Dual mode
- 08 - Change the value in a parameter
Lesson 2 - Clean the Data
- 09 - Learning objectives
- 10 - Evaluate data, including data statistics and column properties
- 11 - Resolve inconsistencies, unexpected or null values, and data quality issues
- 12 - Resolve data import errors
Lesson 3 - Transform and Load the Data
- 13 - Learning objectives
- 14 - Select appropriate column data types
- 15 - Create and transform columns
- 16 - Transform a query
- 17 - Design a star schema that contains facts and dimensions
- 18 - Identify when to use reference or duplicate queries and the resulting impact
- 19 - Merge and append queries
- 20 - Identify and create appropriate keys for relationships
- 21 - Configure data loading for queries
Module 2 - Model the Data
- 22 - Module introduction
Lesson 4 - Design and Implement a Data Model
- 23 - Learning objectives
- 24 - Configure table and column properties
- 25 - Implement role-playing dimensions
- 26 - Define a relationship's cardinality and cross-filter direction
- 27 - Create a common date table
- 28 - Implement row-level security roles
Lesson 5 - Create Model Calculations by Using DAX
- 29 - Learning objectives
- 30 - Create single aggregation measures
- 31 - Use CALCULATE to manipulate filters
- 32 - Implement time intelligence measures
- 33 - Identify implicit measures and replace with explicit measures
- 34 - Use basic statistical functions
- 35 - Create semi-additive measures
- 36 - Create a measure by using quick measures
- 37 - Create calculated tables
Lesson 6 - Optimize Model Performance
- 38 - Learning objectives
- 39 - Improve performance by identifying and removing unnecessary rows and columns
- 40 - Identify poorly performing measures, relationships, and visuals by using Performance Analyzer
- 41 - Improve performance by choosing optimal data types
- 42 - Improve performance by summarizing data
Module 3 - Visualize and Analyze the Data
- 43 - Module introduction
Lesson 7 - Create Reports
- 44 - Learning objectives
- 45 - Identify and implement appropriate visualizations
- 46 - Format and configure visualizations
- 47 - Use a custom visual
- 48 - Apply and customize a theme
- 49 - Configure conditional formatting
- 50 - Apply slicing and filtering
- 51 - Configure the report page
- 52 - Use the Analyze in Excel feature
- 53 - Choose when to use a paginated report
Lesson 8 - Enhance Reports for Usability and Storytelling
- 54 - Learning objectives
- 55 - Configure bookmarks
- 56 - Create custom tooltips
- 57 - Edit and configure interactions between visuals
- 58 - Configure navigation for a report
- 59 - Apply sorting
- 60 - Configure sync slicers
- 61 - Group and layer visuals by using the Selection pane
- 62 - Drill down into data using interactive visuals
- 63 - Configure export of report content and perform an export
- 64 - Design reports for mobile devices
- 65 - Enable personalized visuals in a report
- 66 - Design and configure Power BI reports for accessibility
Lesson 9 - Identify Patterns and Trends
- 67 - Learning objectives
- 68 - Use the Analyze feature in Power BI
- 69 - Use grouping, binning, and clustering
- 70 - Incorporate the Q&A feature in a report
- 71 - Use AI visuals
- 72 - Use reference lines, error bars, and forecasting
- 73 - Detect outliers and anomalies
- 74 - Create and share scorecards and metrics
Module 4 - Deploy and Maintain Assets
- 75 - Module introduction
Lesson 10 - Create and Manage Workspaces and Items
- 76 - Learning objectives
- 77 - Create and configure a workspace
- 78 - Assign workspace roles
- 79 - Configure and update a workspace app
- 80 - Publish, import, or update items in a workspace
- 81 - Create dashboards
- 82 - Choose a distribution method
- 83 - Apply sensitivity labels to workspace content
- 84 - Configure subscriptions and data alerts
- 85 - Promote or certify Power BI content
- 86 - Manage global options for files
Lesson 11 - Manage Semantic Models
- 87 - Learning objectives
- 88 - Identify when a gateway is required
- 89 - Configure a semantic model scheduled refresh
- 90 - Configure row-level security group membership
- 91 - Provide access to semantic models
Summary
- 92 - Exam PL-300 Microsoft Power BI Data Analyst - Summary