Advanced Excel: Power Query, Pivot Table, DAX, Data Modeling https://WebToolTip.com Published 7/2025 Created by Ahmed Ali MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch Level: Beginner | Genre: eLearning | Language: English | Duration: 41 Lectures ( 3h 46m ) | Size: 2.4 GB Master Data importing, Cleaning, modeling, and analysis using Power Query, Power Pivot, DAX to build Reports, Dashboards What you'll learn Power Query: Quickly clean, reshape, and prepare disorganized data using Power Query Pivot Table Mastery – slicing, grouping, charting, and interactive reports DAX Essentials – calculated fields, advanced measures, and time-based logic Data Modeling – create linked tables using best-practice relationships Automate data workflows to save hours each week Build visually appealing dashboards and reports with minimal effort Solve common Excel challenges with confidence and accuracy Develop and apply DAX formulas for dynamic calculations Design and format Pivot Tables to reveal insights from big data sets Connect multiple datasets through robust data models and relationships Data Preparation with Power Query – clean, merge, and transform files Real-World Scenarios – sales trends, quality reports, audit prep, and more Smart Automation – reduce errors and update reports with one click Requirements A willingness to learn and apply what you learn in real data scenarios
Filename Size ~Get Your Files Here !/1 - Introduction/1 -Presentation.mp4 6.4 MB ~Get Your Files Here !/1 - Introduction/2 -Why Pivot Tables.mp4 9.2 MB ~Get Your Files Here !/1 - Introduction/3 -Introduction to Pivot tables.mp4 47.4 MB ~Get Your Files Here !/1 - Introduction/4 -Cleanse Data.mp4 36 MB ~Get Your Files Here !/1 - Introduction/5 -Power Query Overview.mp4 68.5 MB ~Get Your Files Here !/1 - Introduction/6 -Load Data from Tables and Files.mp4 46.6 MB ~Get Your Files Here !/10 - Loading Query to Pivot Table/1 -Pivot Table Overview.mp4 101.2 MB ~Get Your Files Here !/11 - Power Query Conclusion/1 -Recap.mp4 31.7 MB ~Get Your Files Here !/12 - Pivot Tables Overview/1 -Exploring Raw Data.mp4 14.7 MB ~Get Your Files Here !/12 - Pivot Tables Overview/2 -Create Your Very First Table.mp4 29.9 MB ~Get Your Files Here !/13 - Power of Pivot Tables/1 -Format, Sort, and Analyze Your Pivot Table.mp4 24.8 MB ~Get Your Files Here !/13 - Power of Pivot Tables/2 -Add Filters and Slicers Like a Pro.mp4 46.6 MB ~Get Your Files Here !/14 - Build Pivot Charts That Impress/1 -Build Pivot Charts That Impress.mp4 73.8 MB ~Get Your Files Here !/15 - Advanced Pivot Tables/1 -Grouping Dates and Numbers for better insights.mp4 82.1 MB ~Get Your Files Here !/15 - Advanced Pivot Tables/2 -Timeline Slicer.mp4 25.6 MB ~Get Your Files Here !/15 - Advanced Pivot Tables/3 -Grouping Dates.mp4 23.1 MB ~Get Your Files Here !/16 - Pivot Table Conclusion/1 -Recap.mp4 15.5 MB ~Get Your Files Here !/17 - Data Modeling & Dax Calculations/1 -Master Data Modelling and Calculation.mp4 110.3 MB ~Get Your Files Here !/17 - Data Modeling & Dax Calculations/2 -Master Calculations in Pivot Tables.mp4 101.2 MB ~Get Your Files Here !/18 - Data Analysis/1 -Style Your Pivot Table like a Pro.mp4 128.4 MB ~Get Your Files Here !/18 - Data Analysis/2 -Style your Slicer like a pro.mp4 135.6 MB ~Get Your Files Here !/18 - Data Analysis/3 -Style Timeline Slicers like a pro.mp4 51.8 MB ~Get Your Files Here !/18 - Data Analysis/4 -Style Pivot charts like a pro.mp4 23.8 MB ~Get Your Files Here !/19 - Advanced Pivot Tables/1 -Pivot Tables Layouts.mp4 122.3 MB ~Get Your Files Here !/2 - Advanced Power Query/1 -Merge Queries.mp4 54.6 MB ~Get Your Files Here !/3 - Data Transformation/1 -Adding Custom Column.mp4 48.9 MB ~Get Your Files Here !/3 - Data Transformation/2 -Split Column.mp4 71.4 MB ~Get Your Files Here !/4 - Power Query Tips & Tricks/1 -Merge Query Tips & Tricks.mp4 89 MB ~Get Your Files Here !/4 - Power Query Tips & Tricks/2 -Tips & Tricks for Dealing with null values.mp4 70 MB ~Get Your Files Here !/5 - Data Cleanse & Transformation/1 -Adding Index Column.mp4 41.4 MB ~Get Your Files Here !/5 - Data Cleanse & Transformation/2 -Odd & Even Rows.mp4 19.9 MB ~Get Your Files Here !/5 - Data Cleanse & Transformation/3 -Column Formatting.mp4 70.3 MB ~Get Your Files Here !/5 - Data Cleanse & Transformation/4 -Column View.mp4 26.4 MB ~Get Your Files Here !/5 - Data Cleanse & Transformation/5 -Add Conditional Column.mp4 15.6 MB ~Get Your Files Here !/5 - Data Cleanse & Transformation/6 -Add Column From Example.mp4 19.1 MB ~Get Your Files Here !/6 - Advanced Power Query & Data Transformation/1 -Group By Function.mp4 51.9 MB ~Get Your Files Here !/7 - Power of Power Query/1 -Power of Power Query.mp4 89.6 MB ~Get Your Files Here !/8 - Science of Dealing with errors/1 -Dealing with errors.mp4 90.9 MB ~Get Your Files Here !/8 - Science of Dealing with errors/2 -Dealing with errors part 2.mp4 40.9 MB ~Get Your Files Here !/9 - Advanced Data Transformation using AI/1 -Unpivot Columns.mp4 160.4 MB ~Get Your Files Here !/9 - Advanced Data Transformation using AI/2 -Append Queries.mp4 148.4 MB ~Get Your Files Here !/Bonus Resources.txt 70 B