Self-Paced Course
Microsoft PL-300 Exam Prep
Complete, hands-on guide to acing the PL-300 Power BI Exam and becoming a Microsoft Power BI Data Analyst Associate
Course Description
This course is designed to help you build the exact skills you need to ace the Microsoft PL-300 exam, guaranteed.
Throughout the course, you’ll play the role of Lead BI Analyst for Maven Cycles, a boutique cycling shop. You’ll use Power BI Desktop and Service, along with the skills you learn throughout the course, to design and build an end-to-end business intelligence solution from the ground up.
Our project will incorporate all of the skills covered on the DA-100 Exam, including data prep, modeling, visualization and analysis, along with deploying and maintaining reports and deliverables.
We’ll also walk through everything you need to know about the certification process itself, including the exam structure, topic breakdown, question types, rules, results, and tips for success.
Finally, we'll wrap things up with a full-length practice exam, with knowledge-based and case study questions designed to mirror the actual exam experience and make sure you're ready for the real deal.
If you're ready to level-up your Power BI skills, increase your earning potential, and become a Microsoft Certified Analyst, this is the course for you.
COURSE CURRICULUM:
- Course Structure & Outline
- The Course Project
- Maven Cycles Data Model
- Setting Expectations
- DOWNLOAD: Course Resources
- Exam Structure
- Skills Measured
- Exam Question Types
- Example | Knowledge-Based Question
- Example | Case Study Question
- Exam Rules
- Scheduling the Exam
- UPDATE - Certification Renewal Process
- Exam Results
- Helpful Resources
- Tips for Success
- Installing Power BI Desktop
- Creating an Account & Free Trial
- Power BI Service Interface
- Creating Your First Workspace
- Introduction
- Connecting to Data
- The Query Editor
- Example | Connecting to JSON Files
- Example | Connecting to PBDIS Files
- Example | Connecting to the Microsoft Dataverse
- Example | Connecting to SSAS
- Example | Connecting to Sharepoint Online
- Storage Modes
- Data Source Settings
- PRO TIP: Dynamic Sources with Parameters
- QUIZ: Getting Data from Different Sources
- Introduction
- The View Menu
- Column Quality
- Column Distribution
- Column Profile
- QUIZ: Profiling
- Introduction
- Basic Table Transformations
- Index Columns
- Conditional Columns
- Columns from Examples
- Grouping & Aggregation
- Pivoting & Unpivoting
- Merging Queries
- Appending Queries
- Modifying Queries
- Intro to M Code & Editing Applied Steps
- The Advanced Editor
- Common M Function Categories
- M Code Syntax
- QUIZ: Cleaning, Transforming & Loading
- Introduction
- What is a Data Model?
- Data Tables vs. Lookup Tables
- Creating Table Relationships
- Relationship Cardinality & Filter Flow
- Active & Inactive Relationships
- Creating Snowflake Schemas
- Automatic Date Tables
- Date Table Requirements
- Model Optimization Tips
- QUIZ: Data Modeling 101
- Introduction
- Meet DAX
- Calculated Columns
- Measures
- Quick Measures
- Common DAX Function Categories
- Basic Aggregation Functions
- Iterator Functions
- DIVIDE
- CALCULATE
- CALCULATE Modifiers
- USERELATIONSHIP
- ALL
- FILTER
- TOPN
- Time Intelligence Functions
- QUIZ: DAX Calculations
- Introduction
- Power BI Report View
- Objects & Basic Charts
- PRO TIP: Small Multiples
- Editing Report Interactions
- Drillthrough Filters
- Bookmarks
- Tooltips
- Importing Custom Visuals
- R & Python Visuals
- Accessibility Features
- Creating a Dashboard in Power BI Service
- Dashboard Interface
- Web vs. Mobile Layout
- PRO TIP: Paginated Reports
- PRO TIP: Create PivotTables from Power BI Datasets
- QUIZ: Creating Reports & Dashboards
- Introduction
- Chart Types Based on Analysis
- Chart Analytics Options
- PRO TIP: Clustering
- PRO TIP: Grouping & Binning
- Q&A Visual
- Filtering Options
- Slicers
- Key Influencers Visual
- Decomposition Tree Visual
- QUIZ: Enhancing Reports
- Introduction
- Scheduled Dataset Refresh
- Static Row-Level Security
- Dynamic RLS
- Applying RLS in Power BI Service
- PRO TIP: Azure Security Groups
- Subscriptions
- Sharing Options
- User Roles & Permissions
- Publishing Apps
- Deployment Pipelines
- Data Lineage
- Incremental Refresh & Query Folding
- Configuring Incremental Refresh
- Endorsing Content
- Large Dataset Storage Format
- Sensitivity Labels
- QUIZ: Deploying & Maintaining Deliverables
- Practice Exam Intro
- Knowledge-Based Questions
- Case Study #1 Intro
- Case Study #1 Questions
- Case Study #2 Intro
- Case Study #2 Questions
- Case Study #3 Intro
- Case Study #3 Questions
- Practice Exam Walkthrough
- Course Feedback Survey
- Share the love!
- Next Steps
WHO SHOULD TAKE THIS COURSE?
- Power BI users looking to sharpen and certify their skills
- Aspiring analysts seeking to add industry-recognized credentials to the resume
- Anyone looking for a hands-on, comprehensive guide to clearing the Microsoft PL-300 Exam
WHAT ARE THE COURSE REQUIREMENTS?
- Power BI Desktop for PC/Windows (Power BI is currently unavailable for Mac)
- Work or school email address for a Power BI Service account (personal accounts such as gmail, aol, or hotmail are currently unsupported)
- For new users, we recommend completing the Power BI Desktop and Power BI Service courses before PL-300 Prep
Start learning for FREE, no credit card required!
Every subscription includes access to the following course materials
- Interactive Project files
- Downloadable e-books
- Graded quizzes and assessments
- 1-on-1 Expert support
- 100% satisfaction guarantee
- Verified credentials & accredited badges
Ready to become a
data rockstar?
Start learning for free, no credit card required!