| Bonus Resources.txt | 102.4 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| M7 - Folder Combine.xlsx | 27 KB | ||
| Multisheet Consol | |||
| M7 - Consol.xlsx | 27.3 KB | ||
| MultiSheet_Sales.xlsx | 13.8 KB | ||
| Unpivot | |||
| Unpivot Clean.xlsx | 27.6 KB | ||
| Unpivot_Exercise.xlsx | 8.8 KB | ||
| ~Get Your Files Here ! | |||
| 1 - Module 0 Course Introduction and How to Succeed with Power Query | |||
| 1. Welcome and What You Will Achieve.mp4 | 46 MB | ||
| 2 - Power Query Foundations & the ETL Framework | |||
| 1. Module 1 Knowledge Test.html | 20.1 KB | ||
| 10. Mental Model and Step Sequencing.mp4 | 26.6 MB | ||
| 11. Load Bringing Clean Data Into Excel (The L of ETL).mp4 | 33.7 MB | ||
| 12. Module 1 Outro.mp4 | 13.5 MB | ||
| 3 - Data Cleaning & Transformations Using the Power Query Editor | |||
| 13. Module 2 Introduction.mp4 | 31.5 MB | ||
| 13. Module 2 Introduction_Resource_Module2 L2 RemoveFilter xlsx.xlsx | 8.5 KB | ||
| 13. Module 2 Introduction_Resource_Module2 L3 TextCleanup xlsx.xlsx | 8.4 KB | ||
| 13. Module 2 Introduction_Resource_Module2 L4 SplitColumns xlsx.xlsx | 8.3 KB | ||
| 13. Module 2 Introduction_Resource_Module2 L5 DataTypesErrors xlsx.xlsx | 4.9 KB | ||
| 13. Module 2 Introduction_Resource_Module2 L6 ReplaceFill xlsx.xlsx | 8.5 KB | ||
| 13. Module 2 Introduction_Resource_Module2 L7 GroupBy xlsx.xlsx | 4.9 KB | ||
| 13. Module 2 Introduction_Resource_Practice xlsx.xlsx | 20.4 KB | ||
| 14. Remove Rows Keep Rows & Filter Patterns.mp4 | 23.8 MB | ||
| 15. Trim Clean Extract and Change Case.mp4 | 36.8 MB | ||
| 16. Split Columns (Delimiters and Advanced).mp4 | 35.7 MB | ||
| 17. Data Types & Errors.mp4 | 35.3 MB | ||
| 18. Replace Values + Fill Down Fill Up.mp4 | 19.1 MB | ||
| 19. Aggregations.mp4 | 22.8 MB | ||
| 2. Module 2 Knowledge Test.html | 9.6 KB | ||
| 20. Loading transformed data and testing.mp4 | 17.6 MB | ||
| 21. Module 2 Outro.mp4 | 29.7 MB | ||
| 4 - Combining Data and Understanding Power Query Pitfalls | |||
| 22. Module 3 Introduction.mp4 | 35.7 MB | ||
| 23. Appending Data in Power Query.mp4 | 55.8 MB | ||
| 24. Append Watchouts Split Column Pitfall.mp4 | 26.5 MB | ||
| 25. Append Watchouts Rename Column Pitfall.mp4 | 40.8 MB | ||
| 26. Append Watchouts Skip Column Pitfall.mp4 | 12.8 MB | ||
| 27. Folder Based Data Consolidation Using Power Query.mp4 | 45.6 MB | ||
| 28. Folder Consolidation Deep Dive Auto Generated Queries.mp4 | 49.5 MB | ||
| 29. Skip Column Pitfall in Action.mp4 | 19 MB | ||
| 3. Module 3 Knowledge Test.html | 11.7 KB | ||
| 30. Merge Fundamentals in Power Query.mp4 | 59.4 MB | ||
| 31. Merge Pitfalls and Watchouts.mp4 | 69.6 MB | ||
| 32. Merge Types Explained.mp4 | 16 MB | ||
| 33. Data Structure Tall vs Wide Tables.mp4 | 17.2 MB | ||
| 34. Unpivoting Data in Power Query.mp4 | 39.9 MB | ||
| 35. Unpivot Pitfalls and Schema Changes.mp4 | 68.6 MB | ||
| 36. Consolidating Data from Multiple Sheets.mp4 | 44.2 MB | ||
| 37. Multi Sheet Consolidation Watchouts.mp4 | 30.5 MB | ||
| 38. Silent vs Blocking Errors in Power Query.mp4 | 13.3 MB | ||
| 39. Module 3 Summary and What’s Next.mp4 | 17.4 MB | ||
| M3 | |||
| Append | |||
| Feb_Sales.xlsx | 8.4 KB | ||
| Jan_Sales.xlsx | 8.4 KB | ||
| Mar_Sales.xlsx | 8.5 KB | ||
| Merge | |||
| Merge Exercise.xlsx | 19.2 KB | ||
| MultiSheet | |||
| MultiSheet_Sales.xlsx | 13.8 KB | ||
| Multisheet Consol.xlsx | 17.4 KB | ||
| Sales Consolidated.xlsx | 19.1 KB | ||
| Unpivot | |||
| 5 - M Language Foundations – Data Types and Core Objects | |||
| 4. Module 4 Knowledge Test.html | 13 KB | ||
| 40. Module 4 Introduction.mp4 | 30.8 MB | ||
| 40. Module 4 Introduction_Resource_Data Types Basic xlsx.xlsx | 9.5 KB | ||
| 41. Why Data Types Matter.mp4 | 26 MB | ||
| 42. Text.mp4 | 53.7 MB | ||
| 43. Numbers.mp4 | 18.7 MB | ||
| 44. Dates.mp4 | 14.6 MB | ||
| 45. Lists.mp4 | 69.1 MB | ||
| 46. Records.mp4 | 56.4 MB | ||
| 47. Tables.mp4 | 88.8 MB | ||
| 48. Module 4 Summary.mp4 | 18.1 MB | ||
| 6 - M Language Expressions Functions and Defensive Design | |||
| 49. Module 5 Introduction.mp4 | 21.6 MB | ||
| 49. Module 5 Introduction_Resource_M4 Practice File xlsx.xlsx | 22.3 KB | ||
| 49. Module 5 Introduction_Resource_PQ CustomFunction Exercise xlsx.xlsx | 13.3 KB | ||
| 5. Module 5 Knowledge Test.html | 10.5 KB | ||
| 50. Importance of Expressions and Logic.mp4 | 17.5 MB | ||
| 51. Understanding Expressions.mp4 | 22.6 MB | ||
| 52. Step Sequencing and Evaluation Order.mp4 | 33.4 MB | ||
| 53. The Let–In Structure Explained.mp4 | 13.7 MB | ||
| 54. Custom Functions What They Are and Why They Matter.mp4 | 25.4 MB | ||
| 55. Custom Function Syntax.mp4 | 11.4 MB | ||
| 56. Custom Functions in Action (Simple Example).mp4 | 10.6 MB | ||
| 57. Building Your First Custom Function.mp4 | 37.9 MB | ||
| 58. Calling Custom Functions.mp4 | 15.9 MB | ||
| 59. Calling Custom Functions Continued.mp4 | 50.7 MB | ||
| 60. Parameters.mp4 | 45.4 MB | ||
| 61. Defensive Programming.mp4 | 17.4 MB | ||
| 62. Module 5 wrap up.mp4 | 18 MB | ||
| 7 - Designing Robust Power Query Solutions at Scale | |||
| 63. Module 6 Introduction.mp4 | 29.9 MB | ||
| 64. Unpivot Pitfalls Recap.mp4 | 76.3 MB | ||
| 65. Solution Walkthrough Target Outcome.mp4 | 52.1 MB | ||
| 66. Designing the Mental Model.mp4 | 101.5 MB | ||
| 67. Implementing the Solution Using AI.mp4 | 89.7 MB | ||
| 68. Testing the Setup.mp4 | 88.5 MB | ||
| 69. Multi Sheet Consolidation Designing Guardrails.mp4 | 119.2 MB | ||
| 70. Multi Sheet Consolidation Implementing with AI.mp4 | 71.3 MB | ||
| 71. Multi Sheet Consolidation Testing and Validation.mp4 | 23.7 MB | ||
| 72. Handling Changed Type with Parameters.mp4 | 62.4 MB | ||
| 73. Handling Row Level Errors Safely.mp4 | 29.4 MB | ||
| 74. Folder Based Consolidation.mp4 | 42.7 MB | ||
| 75. Course Summary and Final Thoughts.mp4 | 29.6 MB | ||
| M6 | |||
| Folder Combine | |||
| Files | |||
| Apr.xlsx | 8.6 KB | ||
| Feb.xlsx | 8.5 KB | ||
| Jan.xlsx | 8.5 KB | ||
| Mar.xlsx | 8.5 KB | ||
| Unpivot_Exercise.xlsx | 8.5 KB | ||
| Unpivot_Query.xlsx | 18.5 KB | ||
| ProductMaster.xlsx | 8.4 KB | ||
| Sales.xlsx | 8.8 KB | ||
| Append from folder.xlsx | 20.6 KB | ||
| 5. Module 1 Introduction.mp4 | 52 MB | ||
| 5. Module 1 Introduction_Resource_Module1 SalesData xlsx.xlsx | 8.6 KB | ||
| 5. Module 1 Introduction_Resource_PQ File xlsx.xlsx | 18.5 KB | ||
| 5. Module 1 Introduction_Resource_ReadMe docx.docx | 15.9 KB | ||
| 6. ETL Framework.mp4 | 22.4 MB | ||
| 7. Connecting to Data.mp4 | 16.3 MB | ||
| 8. Power Query Editor Walkthrough.mp4 | 20.5 MB | ||
| 9. Transform Basic Transformations (The T of ETL).mp4 | 26.4 MB | ||
| 2. What Power Query Really Solves.mp4 | 32.2 MB | ||
| 3. Course learning objectives.mp4 | 26.8 MB | ||
| 4. Course Structure and How to Use This Course.mp4 | 48.5 MB |
Power Query Masterclass: Advanced Data Cleaning & Automation
https://WebToolTip.com
Published 12/2025
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Language: English | Duration: 5h 1m | Size: 2.74 GB
Build robust Power Query solutions using M-code, real-world datasets, and scalable data transformation techniques
What you'll learn
Clean, transform, and automate Excel and Power BI data using Power Query to build efficient, repeatable workflows
Design scalable Power Query solutions that continue working reliably as data grows and changes
Understand Power Query data types (tables, lists, records) and retrieve values with clarity and confidence
Read, write, and modify M language to extend Power Query beyond basic transformations
Design queries that handle errors intentionally, resulting in more reliable and refresh-safe reports
Transform and automate complex real-world datasets, including multi-folder consolidation and unpivoted data
Adopt a modern analyst mindset focused on automation, scalability, and long-term maintainability
Build a clear and structured query architecture in Power Query so your solutions remain understandable and easy to manage
Requirements
Basic familiarity with Excel e.g. knowledge of pivotables, lookup functions, if statements is needed.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
Udemy - Unlock The Power Of Myofascial Release - Head, Face and Neck Posted by
freecoursewb in Other
|
2.8 GB | freecoursewb | 4 days | 11 | 7 |
|
Udemy - Renew Your Power Bi Data Analyst Certification (Pl-300 Exam) Posted by
freecoursewb in Other
|
2.5 GB | freecoursewb | 2 weeks | 9 | 8 |
| 507 MB | freecoursewb | 2 weeks | 26 | 11 | |
| 2.7 GB | freecoursewb | 3 weeks | 12 | 1 | |
| 996.8 MB | freecoursewb | 1 month | 13 | 4 |
All Comments