Microsoft Certified: Data Analyst Associate (PL-300)

Course Overview The Microsoft Certified: Data Analyst Associate (PL-300) course by Stalwart Learning is designed for individuals who want to gain expertise in data analysis and visualization using Microsoft Power…

Created by

Stalwart Learning

Category

Date & Time

Price

Duration

4 Days / 32hrs

Location

https://stalwartlearning.com/

ENQUIRE NOW

Course Description

The Microsoft Certified: Data Analyst Associate (PL-300) course by Stalwart Learning is designed for individuals who want to gain expertise in data analysis and visualization using Microsoft Power BI. This course covers essential skills, such as data preparation, modeling, visualizing, and analyzing data, along with sharing insights to help drive informed business decisions. Participants will learn how to transform raw data into meaningful reports and dashboards, enabling organizations to leverage data-driven strategies. By the end of this course, learners will be well-prepared for the PL-300 certification exam.

32 hours (4 days)

  • Familiarity with basic data analysis concepts and Microsoft Excel.
  • No prior experience with Power BI required, but a basic understanding of business intelligence tools is recommended.
  • Overview of Power BI and its components (Power BI Desktop, Power BI Service, Power BI Mobile)
  • Navigating the Power BI interface and workspace
  • Connecting to various data sources (Excel, SQL, Web)
  • Using Power Query to clean and transform data
  • Combining multiple datasets using Power Query Editor
  • Designing data models and creating relationships between tables
  • Using DAX (Data Analysis Expressions) to create calculated columns, measures, and tables
  • Understanding star schema and snowflake schema for optimized models
  • Building interactive and insightful reports with Power BI visuals
  • Using slicers, filters, and conditional formatting to enhance reports
  • Implementing advanced visualizations (maps, KPIs, combo charts)
  • Applying advanced analytics using Power BI’s in-built features (Quick Insights, What-If analysis)
  • Creating calculated measures and using Time Intelligence in DAX
  • Publishing and sharing reports on Power BI Service
  • Collaborating and managing workspaces and datasets
  • Creating and scheduling data refresh in Power BI Service
  • Setting up row-level security (RLS) for data access control
  • Managing Power BI licenses and user access
  • PL-300 exam structure and tips
  • Mock exams and scenario-based questions

ENQUIRE NOW