Power Bi Data Analyst Associate PL-300

• Connect to and prepare data from different sources.
• Clean, transform, and load data using Power Query.
• Design and implement Power BI data models.
• Create calculations using DAX.
• Optimize data models for performance.
• Create and configure Power BI reports and visualizations.
• Apply filtering, slicing, bookmarks, drillthrough, and navigation.
• Identify patterns and trends in data.
• Create and manage Power BI workspaces and assets.
• Configure Power BI security and governance.
• Manage semantic models, refreshes, dashboards, and data distribution.

Module 1: Get started with Microsoft data analytics

• Discover the different roles in data
• Identify the tasks that a data analyst performs
• Describe the landscape of Microsoft data analytics
• Identify the services and technologies used by data analysts

Module 2: Prepare data for analysis with Power BI

• Get or connect to data
• Profile and clean data
• Transform and load data
• Work with data sources and query settings
• Create and transform columns
• Merge and append queries
• Create fact and dimension tables

Module 3: Model data with Power BI

• Design and implement a data model
• Work with relationships and cardinality
• Create date tables
• Create calculated columns and tables
• Create DAX measures
• Use CALCULATE and time intelligence
• Optimize model performance

Module 4: Design effective reports in Power BI

• Create reports
• Select and configure appropriate visuals
• Apply themes and conditional formatting
• Apply filters and slicers
• Configure report pages
• Create visual calculations
• Enhance reports for usability and storytelling
• Configure bookmarks and custom tooltips
• Configure visual interactions
• Configure navigation and drillthrough
• Design reports for mobile devices and accessibility

Module 5: Analyze data with Power BI

• Identify patterns and trends
• Use the Analyze feature
• Use grouping, binning, and clustering
• Use AI visuals
• Use reference lines and error bars
• Apply forecasting
• Detect outliers and anomalies
• Use Copilot to summarize semantic models

Module 6: Manage and secure Power BI

• Create and manage workspaces
• Configure and update apps
• Publish and update workspace content
• Create dashboards
• Configure subscriptions and data alerts
• Promote and certify Power BI content
• Configure gateways and scheduled refresh
• Assign workspace roles
• Configure item-level access
• Configure semantic model access
• Implement row-level security
• Apply sensitivity labels

3 Days

Certification: Microsoft Certified: Power BI Data Analyst Associate
Exam: PL-300: Microsoft Power BI Data Analyst
Duration: 100 minutes

• Data professionals.
• Business intelligence professionals.
• Professionals who perform data analysis using Power BI.
• Professionals who develop reports that visualize data from cloud and on-premises data platforms.
• Professionals working with business stakeholders to identify data and reporting requirements.

• Proficiency with Power Query.
• Proficiency with Data Analysis Expressions (DAX).
• Familiarity with preparing, modeling, visualizing, and analyzing data.
• Understanding of working with data sources and business requirements.