Udemy - Power Query Masterclass - Advanced Data Cleaning and Auto...

Files:

• Get Bonus Downloads Here.url (0.2 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.0 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)
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)
• 5. Module 1 Introduction.mp4 (52.0 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)
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.0 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.0 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 from folder.xlsx (20.6 KB)
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)
• ProductMaster.xlsx (8.4 KB)
• Sales.xlsx (8.8 KB)
MultiSheet
• MultiSheet_Sales.xlsx (13.8 KB)
• Multisheet Consol.xlsx (17.4 KB)
• Sales Consolidated.xlsx (19.1 KB)
Unpivot
• Unpivot_Exercise.xlsx (8.5 KB)
• Unpivot_Query.xlsx (18.5 KB)
5 - M Language Foundations – Data Types and Core Objects
• 4. Module 4 Knowledge Test.html (13.0 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.0 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.0 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)
• M7 - Folder Combine.xlsx (27.0 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)
• Bonus Resources.txt (0.1 KB)