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 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.
Duration
32 hours (4 days)
Prerequisites
- 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.
Course Outline
1. Introduction to Power BI
- Overview of Power BI and its components (Power BI Desktop, Power BI Service, Power BI Mobile)
- Navigating the Power BI interface and workspace
2. Data Preparation and Transformation
- Connecting to various data sources (Excel, SQL, Web)
- Using Power Query to clean and transform data
- Combining multiple datasets using Power Query Editor
3. Data Modeling and Relationships
- 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
4. Visualizing Data and Creating Reports
- 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)
5. Analyzing Data and Generating Insights
- Applying advanced analytics using Power BI’s in-built features (Quick Insights, What-If analysis)
- Creating calculated measures and using Time Intelligence in DAX
6. Sharing and Collaborating with Power BI
- Publishing and sharing reports on Power BI Service
- Collaborating and managing workspaces and datasets
- Creating and scheduling data refresh in Power BI Service
7. Power BI Security and Administration
- Setting up row-level security (RLS) for data access control
- Managing Power BI licenses and user access
8. Exam Preparation and Practice Tests
- PL-300 exam structure and tips
- Mock exams and scenario-based questions