Learn Power Bi And Ace The Pl-300 Exam On Your First Attempt
Published 1/2025
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 4.42 GB | Duration: 8h 36m
Published 1/2025
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 4.42 GB | Duration: 8h 36m
Become a PL-300 Power BI Data Analyst Associate with Real-World Projects and Certification Exam Preparation
What you'll learn
Build end-to-end Power BI project from scratch.
Clean, transform, and model data for effective analysis.
Create dynamic dashboards and visualizations.
Master DAX for advanced calculations and insights.
Learn best practices for managing and securing Power BI content.
Tackle PL-300 certification exam questions with confidence.
Requirements
None! This course is designed for complete beginners. No prior experience with Power BI or data analysis is required.
Description
This course was developed using the most recent version of Power BI Desktop.The only course you need to clear the PL-300 certification and master Power BI from scratch! This comprehensive program is designed to help you become a certified Power BI Data Analyst Associate while equipping you with real-world skills to tackle data challenges and advance your career in data analytics.What sets this course apart? It’s project-based! You’ll work on a complete Power BI project from start to finish, using provided datasets to learn data preparation, modeling, visualization, and analysis. Alongside practical learning, you’ll gain access to sample PL-300 exam questions with step-by-step solutions, ensuring you’re fully prepared for the certification.Our detailed curriculum covers:Prepare the Data: Connect, clean, and transform datasets efficiently.Model the Data: Build robust data models and write advanced DAX calculations.Visualize the Data: Create dynamic dashboards and interactive reports.Manage and Secure Power BI: Publish, share, and govern your content effectively.Additionally, the course provides pro tips, best practices, and troubleshooting guidance to help you handle real-world scenarios. By the end of this course, you’ll have the confidence to ace the PL-300 exam, create professional Power BI projects, and impress stakeholders with actionable insights that drive decisions.
Overview
Section 1: Introduction
Lecture 1 Course Introduction
Lecture 2 Skills Measured
Lecture 3 What is Power BI?
Lecture 4 Power BI Installation
Section 2: Prepare the data
Lecture 5 Connect to data sources
Lecture 6 Configure Data Source Settings
Lecture 7 Storage Mode
Lecture 8 Create and Modify Parameters
Lecture 9 Understand Project Dataset and import the data
Lecture 10 Data Profiling
Lecture 11 Resolve Inconsistencies and Data Quality Issues
Lecture 12 Custom Column
Lecture 13 Index Column
Lecture 14 Conditional Column
Lecture 15 Column from examples
Lecture 16 Group and aggregation
Lecture 17 Pivot, Unpivot and Transpose
Lecture 18 Merge Queries
Lecture 19 Append Queries
Lecture 20 Configure Data Loading
Lecture 21 Facts and Dimension Tables
Lecture 22 Duplicate and Reference
Lecture 23 M code
Section 3: Model the data
Lecture 24 Data Modelling Introduction, Common Schemas
Lecture 25 Define the Relationship
Lecture 26 Cross filter
Lecture 27 Table and column properties
Lecture 28 DAX Introduction
Lecture 29 DAX - Information function
Lecture 30 DAX - Text functions
Lecture 31 DAX - Date and time functions
Lecture 32 DAX - Related function
Lecture 33 DAX - Logical Functions
Lecture 34 Measures
Lecture 35 Basic Statistics Measures
Lecture 36 Iterators
Lecture 37 Calculate
Lecture 38 Date Table
Lecture 39 Active Vs Inactive Relationship
Lecture 40 Role playing dimension
Lecture 41 Time Intelligence Functions
Lecture 42 Semi-Additive Measures
Lecture 43 Quick Measures
Lecture 44 DAX Vs M Code
Lecture 45 Measure table and improve model performance
Lecture 46 Identify poorly performing measures, relationships, and visuals
Section 4: Visualize and Analyze the data
Lecture 47 Select an appropriate visual
Lecture 48 Clustered Column and bar chart
Lecture 49 Format a visual
Lecture 50 Stacked Charts
Lecture 51 Pie, Donut, TreeMap
Lecture 52 Line, Area Charts
Lecture 53 Combo Charts
Lecture 54 Ribbon Chart
Lecture 55 Waterfall Chart
Lecture 56 Hierachies and drill down
Lecture 57 Funnel Chart
Lecture 58 Scatter Chart
Lecture 59 Custom Tooltip
Lecture 60 Card Visuals
Lecture 61 KPI, Gauge Chart
Lecture 62 Conditional Formatting
Lecture 63 Apply Sorting
Lecture 64 Apply Themes
Lecture 65 Filters
Lecture 66 Slicers
Lecture 67 Add logo and Report Formatting
Lecture 68 Bookmark and Selection
Lecture 69 Drillthrough Navigation
Lecture 70 Sync Slicers
Lecture 71 Edit Interactions
Lecture 72 Work with Geographic data
Lecture 73 AI Visual - Q&A
Lecture 74 AI Visual - Decomposition tree
Lecture 75 Analyze Feature
Lecture 76 Group and bins
Lecture 77 Reference Lines
Lecture 78 Forecasting
Lecture 79 Configure Page Navigation
Lecture 80 Design Reports for Mobile Device
Section 5: Manage and secure Power BI
Lecture 81 Subscription Model
Lecture 82 Sign Up to Power BI Service
Lecture 83 Workspace creation
Lecture 84 Publish the report
Lecture 85 Assign Workspace roles
Lecture 86 Create and update Workspace App
Lecture 87 Publish, import, or update items in a workspace
Lecture 88 Create Dashboards
Lecture 89 Configure Subscription and alerts
Lecture 90 Promoted and Certified
Lecture 91 Identify when a gateway is required
Lecture 92 Schedule Refresh
Lecture 93 Configure item-level access
Lecture 94 RLS
Lecture 95 Dynamic RLS
Lecture 96 Export Settings
Section 6: Exam Readiness
Lecture 97 Sample Questions (1-10)
Lecture 98 Sample Questions (11-20)
Lecture 99 How to schedule the exam
Anyone who wants to learn Power BI from scratch.,Individuals preparing for the Microsoft Certified: Power BI Data Analyst Associate (PL-300) exam.,Professionals looking to enhance their data analysis and visualization skills.