Power BI Data Analyst

8 Courses · 267 Lessons

C1 Preparing Data for Analysis with Microsoft Excel 30 lessons

M1 Introduction to Data Analysis with Excel 8
M2 Excel Formulas and Functions 8
M3 Data Cleaning and Preparation in Excel 7
M4 Pivot Tables and Data Summarization 7

C2 Harnessing the Power of Data with Power BI 29 lessons

M1 Introduction to Power BI 7
M2 Power BI Desktop Interface and Navigation 7
M3 Connecting to Data Sources 7
M4 Creating Basic Visualizations 8

C3 Extract Transform and Load Data in Power BI 28 lessons

M1 Introduction to Power Query 7
M2 Data Transformation Techniques 7
M3 Merging and Appending Queries 7
M4 Advanced ETL Patterns in Power BI 7

C4 Data Modeling in Power BI 28 lessons

M1 Data Modeling Fundamentals 7
M2 Star Schema and Relationships 7
M3 Introduction to DAX 7
M4 Advanced DAX Calculations 7

C5 Data Analysis and Visualization with Power BI 28 lessons

M1 Advanced Data Analysis Techniques 7
M2 AIPowered Visuals in Power BI 7
M3 Time Intelligence with DAX 7
M4 Data Storytelling and Insights 7

C6 Creative Designing in Power BI 28 lessons

M1 Report Design Principles 7
M2 Custom Themes and Formatting 7
M3 Interactive Report Features 7
M4 MobileOptimized Reports 7

C7 Deploy and Maintain Power BI Assets and Capstone Project 28 lessons

M1 Power BI Service and Workspaces 7
M2 RowLevel Security and Governance 7
M3 Deployment Pipelines and Best Practices 7
M4 Capstone Project EndtoEnd BI Solution 7

C8 PL300 Exam Preparation and Practice 28 lessons

M1 PL300 Exam Overview and Study Guide 7
M2 Practice Questions Data Preparation 7
M3 Practice Questions Data Modeling and Visualization 7
M4 Final Exam Review and Strategies 7