Power BI Data Analyst

8 Courses · 163 Lessons
🔍
📖 C1 Preparing Data for Analysis with Microsoft Excel 4 Modules · 22 Lessons
▶ M1 Introduction to Data Analysis with Excel 6
1L1 Data Analysis Kya Hai→ 2L2 Microsoft Excel Ka Overview→ 3L3 Data Entry aur Formatting Basics→ 4L4 Data Organization Techniques→ 5L5 Basic Charts aur Visual Summaries→ 6L6 Module Review aur Practice→
▶ M2 Excel Formulas and Functions 6
1L1 Formulas Ki Duniya→ 2L2 Essential Functions SUM AVERAGE COUNT→ 3L3 Logical Functions IF AND OR→ 4L4 Lookup Functions VLOOKUP HLOOKUP XLOOKUP→ 5L5 Text aur Date Functions→ 6L6 Module Review aur Practice→
▶ M3 Data Cleaning and Preparation in Excel 5
1L1 Data Cleaning Kyon Zaroori Hai→ 2L2 Duplicates aur Missing Values Handle Karna→ 3L3 Text Data Cleaning Techniques→ 4L4 Data Transformation aur Standardization→ 5L5 Module Review aur Practice→
▶ M4 Pivot Tables and Data Summarization 5
1L1 Pivot Tables Ka Introduction→ 2L2 Pivot Table Fields aur Layouts→ 3L3 Pivot Table Filtering aur Slicers→ 4L4 Pivot Charts aur Dashboards→ 5L5 Module Review aur Capstone Exercise→
📖 C2 Harnessing the Power of Data with Power BI 4 Modules · 21 Lessons
▶ M1 Introduction to Power BI 5
1L1 Power BI Kya Hai→ 2L2 Power BI Desktop Install aur Setup→ 3L3 Power BI Workflow Samajhna→ 4L4 Power BI vs Other BI Tools→ 5L5 Module Review→
▶ M2 Power BI Desktop Interface and Navigation 5
1L1 Power BI Desktop Interface Tour→ 2L2 Pages aur Canvas Management→ 3L3 Visualizations Pane aur Format Options→ 4L4 Filters Pane aur Interactions→ 5L5 Module Review→
▶ M3 Connecting to Data Sources 5
1L1 Data Sources Ka Overview→ 2L2 Excel aur CSV Files Import Karna→ 3L3 Database Connections→ 4L4 Web aur API Data Sources→ 5L5 Module Review→
▶ M4 Creating Basic Visualizations 6
1L1 Visualization Types Samajhna→ 2L2 Bar aur Column Charts→ 3L3 Line Charts aur Trend Analysis→ 4L4 Tables Matrices aur Cards→ 5L5 First Dashboard Complete Karna→ 6L6 Module Review→
📖 C3 Extract Transform and Load Data in Power BI 4 Modules · 20 Lessons
▶ M1 Introduction to Power Query 5
1L1 Power Query Kya Hai→ 2L2 Data Sources se Connect Karna Power Query Me→ 3L3 Basic Transformations→ 4L4 Query Management→ 5L5 Module Review→
▶ M2 Data Transformation Techniques 5
1L1 Column Transformations→ 2L2 RowLevel Transformations→ 3L3 Data Type Conversions aur Locale→ 4L4 Conditional Columns aur Groups→ 5L5 Module Review→
▶ M3 Merging and Appending Queries 5
1L1 Append Queries Data Stack Karna→ 2L2 Merge Queries Data Join Karna→ 3L3 Advanced Merge Scenarios→ 4L4 Folder aur MultiFile Combinations→ 5L5 Module Review→
▶ M4 Advanced ETL Patterns in Power BI 5
1L1 Parameters aur Dynamic Queries→ 2L2 Error Handling aur Data Quality→ 3L3 Query Functions aur Custom Logic→ 4L4 Dataflows aur Incremental Refresh→ 5L5 Module Review→
📖 C4 Data Modeling in Power BI 4 Modules · 20 Lessons
▶ M1 Data Modeling Fundamentals 5
1L1 Data Model Kya Hai→ 2L2 Tables aur Columns Manage Karna→ 3L3 Relationships Create Karna→ 4L4 Model View Aur Best Practices→ 5L5 Module Review→
▶ M2 Star Schema and Relationships 5
1L1 Star Schema Deep Dive→ 2L2 Date Dimension Table→ 3L3 RolePlaying Dimensions→ 4L4 ManytoMany Relationships→ 5L5 Module Review→
▶ M3 Introduction to DAX 5
1L1 DAX Kya Hai→ 2L2 Calculated Columns vs Measures→ 3L3 Basic DAX Functions→ 4L4 Filter Functions Introduction→ 5L5 Module Review→
▶ M4 Advanced DAX Calculations 5
1L1 Time Intelligence Functions→ 2L2 Table Functions aur Variables→ 3L3 Iterator Functions→ 4L4 Advanced CALCULATE Patterns→ 5L5 Module Review→
📖 C5 Data Analysis and Visualization with Power BI 4 Modules · 20 Lessons
▶ M1 Advanced Data Analysis Techniques 5
1L1 Advanced DAX Patterns for Analysis→ 2L2 Statistical Analysis in Power BI→ 3L3 Grouping aur Binning Data→ 4L4 Advanced Filtering Techniques→ 5L5 Module Review→
▶ M2 AIPowered Visuals in Power BI 5
1L1 AI Visuals Ka Overview→ 2L2 QA Visual Natural Language Queries→ 3L3 Key Influencers Visual→ 4L4 Decomposition Tree aur Smart Narrative→ 5L5 Module Review→
▶ M3 Time Intelligence with DAX 5
1L1 Time Intelligence Foundation→ 2L2 YeartoDate aur PeriodtoDate→ 3L3 PeriodoverPeriod Comparisons→ 4L4 Custom Time Calculations→ 5L5 Module Review→
▶ M4 Data Storytelling and Insights 5
1L1 Data Storytelling Fundamentals→ 2L2 Effective Dashboard Design→ 3L3 Annotations aur Context Add Karna→ 4L4 Presentation aur Sharing Strategies→ 5L5 Module Review→
📖 C6 Creative Designing in Power BI 4 Modules · 20 Lessons
▶ M1 Report Design Principles 5
1L1 Visual Design Fundamentals→ 2L2 Color Theory for Dashboards→ 3L3 Layout Patterns aur Spacing→ 4L4 Typography aur Labels→ 5L5 Module Review→
▶ M2 Custom Themes and Formatting 5
1L1 Power BI Themes Overview→ 2L2 Custom Theme JSON File Create Karna→ 3L3 Conditional Formatting Advanced→ 4L4 Visual Formatting Deep Dive→ 5L5 Module Review→
▶ M3 Interactive Report Features 5
1L1 Buttons aur Navigation→ 2L2 Bookmarks aur Selections→ 3L3 Drillthrough Pages→ 4L4 Custom Tooltips aur Overlays→ 5L5 Module Review→
▶ M4 MobileOptimized Reports 5
1L1 Mobile Report Design Basics→ 2L2 Mobile Layout Create Karna→ 3L3 Mobile Interactivity→ 4L4 Mobile Deployment aur Testing→ 5L5 Module Review→
📖 C7 Deploy and Maintain Power BI Assets and Capstone Project 4 Modules · 20 Lessons
▶ M1 Power BI Service and Workspaces 5
1L1 Power BI Service Overview→ 2L2 Workspaces Create aur Manage Karna→ 3L3 Reports Publish aur Share Karna→ 4L4 Data Refresh aur Gateways→ 5L5 Module Review→
▶ M2 RowLevel Security and Governance 5
1L1 RowLevel Security RLS Basics→ 2L2 Dynamic RowLevel Security→ 3L3 Data Governance Fundamentals→ 4L4 Monitoring aur Audit→ 5L5 Module Review→
▶ M3 Deployment Pipelines and Best Practices 5
1L1 Deployment Pipelines Ka Overview→ 2L2 Pipeline Stages aur Deployment→ 3L3 Version Control aur Collaboration→ 4L4 Performance Optimization Best Practices→ 5L5 Module Review→
▶ M4 Capstone Project EndtoEnd BI Solution 5
1L1 Capstone Project Planning→ 2L2 Data Preparation aur Modeling→ 3L3 Report Development→ 4L4 Deployment aur Presentation→ 5L5 Module Review aur Course Completion→
📖 C8 PL300 Exam Preparation and Practice 4 Modules · 20 Lessons
▶ M1 PL300 Exam Overview and Study Guide 5
1L1 PL300 Exam Ka Overview→ 2L2 Domain 1 Study Guide Prepare the Data→ 3L3 Domain 2 Study Guide Model the Data→ 4L4 Domain 34 Study Guide Visualize aur Deploy→ 5L5 Study Plan aur Resources→
▶ M2 Practice Questions Data Preparation 5
1L1 Power Query Practice Questions→ 2L2 Data Cleaning Scenarios→ 3L3 Advanced ETL Questions→ 4L4 Timed Practice Exam Data Preparation→ 5L5 Module Review→
▶ M3 Practice Questions Data Modeling and Visualization 5
1L1 Data Modeling Practice Questions→ 2L2 DAX Practice Scenarios→ 3L3 Visualization Practice Questions→ 4L4 Timed Practice Exam Modeling aur Visualization→ 5L5 Module Review→
▶ M4 Final Exam Review and Strategies 5
1L1 FullLength Mock Exam→ 2L2 Weak Areas Deep Dive→ 3L3 Exam Day Strategies→ 4L4 LastMinute Quick Review→ 5L5 Certification Next Steps→