Udemy - Power Query Masterclass - Advanced Data Cleaning and Automation
File List
| File | Size |
|---|---|
| Get Bonus Downloads Here.url | 180 B |
| ~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.03 MB |
| ~Get Your Files Here !/1 - Module 0 Course Introduction and How to Succeed with Power Query/2. What Power Query Really Solves.mp4 | 32.23 MB |
| ~Get Your Files Here !/1 - Module 0 Course Introduction and How to Succeed with Power Query/3. Course learning objectives.mp4 | 26.78 MB |
| ~Get Your Files Here !/1 - Module 0 Course Introduction and How to Succeed with Power Query/4. Course Structure and How to Use This Course.mp4 | 48.47 MB |
| ~Get Your Files Here !/2 - Power Query Foundations & the ETL Framework/1. Module 1 Knowledge Test.html | 20.06 KB |
| ~Get Your Files Here !/2 - Power Query Foundations & the ETL Framework/10. Mental Model and Step Sequencing.mp4 | 26.63 MB |
| ~Get Your Files Here !/2 - Power Query Foundations & the ETL Framework/11. Load Bringing Clean Data Into Excel (The L of ETL).mp4 | 33.7 MB |
| ~Get Your Files Here !/2 - Power Query Foundations & the ETL Framework/12. Module 1 Outro.mp4 | 13.49 MB |
| ~Get Your Files Here !/2 - Power Query Foundations & the ETL Framework/5. Module 1 Introduction.mp4 | 52.03 MB |
| ~Get Your Files Here !/2 - Power Query Foundations & the ETL Framework/5. Module 1 Introduction_Resource_Module1 SalesData xlsx.xlsx | 8.56 KB |
| ~Get Your Files Here !/2 - Power Query Foundations & the ETL Framework/5. Module 1 Introduction_Resource_PQ File xlsx.xlsx | 18.52 KB |
| ~Get Your Files Here !/2 - Power Query Foundations & the ETL Framework/5. Module 1 Introduction_Resource_ReadMe docx.docx | 15.88 KB |
| ~Get Your Files Here !/2 - Power Query Foundations & the ETL Framework/6. ETL Framework.mp4 | 22.39 MB |
| ~Get Your Files Here !/2 - Power Query Foundations & the ETL Framework/7. Connecting to Data.mp4 | 16.32 MB |
| ~Get Your Files Here !/2 - Power Query Foundations & the ETL Framework/8. Power Query Editor Walkthrough.mp4 | 20.54 MB |
| ~Get Your Files Here !/2 - Power Query Foundations & the ETL Framework/9. Transform Basic Transformations (The T of ETL).mp4 | 26.45 MB |
| ~Get Your Files Here !/3 - Data Cleaning & Transformations Using the Power Query Editor/13. Module 2 Introduction.mp4 | 31.48 MB |
| ~Get Your Files Here !/3 - Data Cleaning & Transformations Using the Power Query Editor/13. Module 2 Introduction_Resource_Module2 L2 RemoveFilter xlsx.xlsx | 8.47 KB |
| ~Get Your Files Here !/3 - Data Cleaning & Transformations Using the Power Query Editor/13. Module 2 Introduction_Resource_Module2 L3 TextCleanup xlsx.xlsx | 8.4 KB |
| ~Get Your Files Here !/3 - Data Cleaning & Transformations Using the Power Query Editor/13. Module 2 Introduction_Resource_Module2 L4 SplitColumns xlsx.xlsx | 8.27 KB |
| ~Get Your Files Here !/3 - Data Cleaning & Transformations Using the Power Query Editor/13. Module 2 Introduction_Resource_Module2 L5 DataTypesErrors xlsx.xlsx | 4.88 KB |
| ~Get Your Files Here !/3 - Data Cleaning & Transformations Using the Power Query Editor/13. Module 2 Introduction_Resource_Module2 L6 ReplaceFill xlsx.xlsx | 8.53 KB |
| ~Get Your Files Here !/3 - Data Cleaning & Transformations Using the Power Query Editor/13. Module 2 Introduction_Resource_Module2 L7 GroupBy xlsx.xlsx | 4.95 KB |
| ~Get Your Files Here !/3 - Data Cleaning & Transformations Using the Power Query Editor/13. Module 2 Introduction_Resource_Practice xlsx.xlsx | 20.42 KB |
| ~Get Your Files Here !/3 - Data Cleaning & Transformations Using the Power Query Editor/14. Remove Rows Keep Rows & Filter Patterns.mp4 | 23.82 MB |
| ~Get Your Files Here !/3 - Data Cleaning & Transformations Using the Power Query Editor/15. Trim Clean Extract and Change Case.mp4 | 36.77 MB |
| ~Get Your Files Here !/3 - Data Cleaning & Transformations Using the Power Query Editor/16. Split Columns (Delimiters and Advanced).mp4 | 35.69 MB |
| ~Get Your Files Here !/3 - Data Cleaning & Transformations Using the Power Query Editor/17. Data Types & Errors.mp4 | 35.26 MB |
| ~Get Your Files Here !/3 - Data Cleaning & Transformations Using the Power Query Editor/18. Replace Values + Fill Down Fill Up.mp4 | 19.15 MB |
| ~Get Your Files Here !/3 - Data Cleaning & Transformations Using the Power Query Editor/19. Aggregations.mp4 | 22.8 MB |
| ~Get Your Files Here !/3 - Data Cleaning & Transformations Using the Power Query Editor/2. Module 2 Knowledge Test.html | 9.64 KB |
| ~Get Your Files Here !/3 - Data Cleaning & Transformations Using the Power Query Editor/20. Loading transformed data and testing.mp4 | 17.59 MB |
| ~Get Your Files Here !/3 - Data Cleaning & Transformations Using the Power Query Editor/21. Module 2 Outro.mp4 | 29.74 MB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/22. Module 3 Introduction.mp4 | 35.73 MB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/23. Appending Data in Power Query.mp4 | 55.83 MB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/24. Append Watchouts Split Column Pitfall.mp4 | 26.55 MB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/25. Append Watchouts Rename Column Pitfall.mp4 | 40.77 MB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/26. Append Watchouts Skip Column Pitfall.mp4 | 12.77 MB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/27. Folder Based Data Consolidation Using Power Query.mp4 | 45.64 MB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/28. Folder Consolidation Deep Dive Auto Generated Queries.mp4 | 49.53 MB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/29. Skip Column Pitfall in Action.mp4 | 19.01 MB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/3. Module 3 Knowledge Test.html | 11.65 KB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/30. Merge Fundamentals in Power Query.mp4 | 59.43 MB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/31. Merge Pitfalls and Watchouts.mp4 | 69.63 MB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/32. Merge Types Explained.mp4 | 15.99 MB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/33. Data Structure Tall vs Wide Tables.mp4 | 17.23 MB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/34. Unpivoting Data in Power Query.mp4 | 39.93 MB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/35. Unpivot Pitfalls and Schema Changes.mp4 | 68.63 MB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/36. Consolidating Data from Multiple Sheets.mp4 | 44.25 MB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/37. Multi Sheet Consolidation Watchouts.mp4 | 30.54 MB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/38. Silent vs Blocking Errors in Power Query.mp4 | 13.31 MB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/39. Module 3 Summary and What’s Next.mp4 | 17.35 MB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/M3/Append from folder.xlsx | 20.65 KB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/M3/Append/Feb_Sales.xlsx | 8.41 KB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/M3/Append/Jan_Sales.xlsx | 8.41 KB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/M3/Append/Mar_Sales.xlsx | 8.49 KB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/M3/Merge/Merge Exercise.xlsx | 19.21 KB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/M3/Merge/ProductMaster.xlsx | 8.38 KB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/M3/Merge/Sales.xlsx | 8.81 KB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/M3/MultiSheet/MultiSheet_Sales.xlsx | 13.8 KB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/M3/MultiSheet/Multisheet Consol.xlsx | 17.37 KB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/M3/Sales Consolidated.xlsx | 19.07 KB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/M3/Unpivot/Unpivot_Exercise.xlsx | 8.48 KB |
| ~Get Your Files Here !/4 - Combining Data and Understanding Power Query Pitfalls/M3/Unpivot/Unpivot_Query.xlsx | 18.45 KB |
| ~Get Your Files Here !/5 - M Language Foundations – Data Types and Core Objects/4. Module 4 Knowledge Test.html | 13.03 KB |
| ~Get Your Files Here !/5 - M Language Foundations – Data Types and Core Objects/40. Module 4 Introduction.mp4 | 30.75 MB |
| ~Get Your Files Here !/5 - M Language Foundations – Data Types and Core Objects/40. Module 4 Introduction_Resource_Data Types Basic xlsx.xlsx | 9.49 KB |
| ~Get Your Files Here !/5 - M Language Foundations – Data Types and Core Objects/41. Why Data Types Matter.mp4 | 26.03 MB |
| ~Get Your Files Here !/5 - M Language Foundations – Data Types and Core Objects/42. Text.mp4 | 53.72 MB |
| ~Get Your Files Here !/5 - M Language Foundations – Data Types and Core Objects/43. Numbers.mp4 | 18.7 MB |
| ~Get Your Files Here !/5 - M Language Foundations – Data Types and Core Objects/44. Dates.mp4 | 14.64 MB |
| ~Get Your Files Here !/5 - M Language Foundations – Data Types and Core Objects/45. Lists.mp4 | 69.05 MB |
| ~Get Your Files Here !/5 - M Language Foundations – Data Types and Core Objects/46. Records.mp4 | 56.36 MB |
| ~Get Your Files Here !/5 - M Language Foundations – Data Types and Core Objects/47. Tables.mp4 | 88.84 MB |
| ~Get Your Files Here !/5 - M Language Foundations – Data Types and Core Objects/48. Module 4 Summary.mp4 | 18.12 MB |
| ~Get Your Files Here !/6 - M Language Expressions Functions and Defensive Design/49. Module 5 Introduction.mp4 | 21.57 MB |
| ~Get Your Files Here !/6 - M Language Expressions Functions and Defensive Design/49. Module 5 Introduction_Resource_M4 Practice File xlsx.xlsx | 22.27 KB |
| ~Get Your Files Here !/6 - M Language Expressions Functions and Defensive Design/49. Module 5 Introduction_Resource_PQ CustomFunction Exercise xlsx.xlsx | 13.34 KB |
| ~Get Your Files Here !/6 - M Language Expressions Functions and Defensive Design/5. Module 5 Knowledge Test.html | 10.48 KB |
| ~Get Your Files Here !/6 - M Language Expressions Functions and Defensive Design/50. Importance of Expressions and Logic.mp4 | 17.54 MB |
| ~Get Your Files Here !/6 - M Language Expressions Functions and Defensive Design/51. Understanding Expressions.mp4 | 22.59 MB |
| ~Get Your Files Here !/6 - M Language Expressions Functions and Defensive Design/52. Step Sequencing and Evaluation Order.mp4 | 33.44 MB |
| ~Get Your Files Here !/6 - M Language Expressions Functions and Defensive Design/53. The Let–In Structure Explained.mp4 | 13.7 MB |
| ~Get Your Files Here !/6 - M Language Expressions Functions and Defensive Design/54. Custom Functions What They Are and Why They Matter.mp4 | 25.36 MB |
| ~Get Your Files Here !/6 - M Language Expressions Functions and Defensive Design/55. Custom Function Syntax.mp4 | 11.38 MB |
| ~Get Your Files Here !/6 - M Language Expressions Functions and Defensive Design/56. Custom Functions in Action (Simple Example).mp4 | 10.57 MB |
| ~Get Your Files Here !/6 - M Language Expressions Functions and Defensive Design/57. Building Your First Custom Function.mp4 | 37.87 MB |
| ~Get Your Files Here !/6 - M Language Expressions Functions and Defensive Design/58. Calling Custom Functions.mp4 | 15.92 MB |
| ~Get Your Files Here !/6 - M Language Expressions Functions and Defensive Design/59. Calling Custom Functions Continued.mp4 | 50.67 MB |
| ~Get Your Files Here !/6 - M Language Expressions Functions and Defensive Design/60. Parameters.mp4 | 45.43 MB |
| ~Get Your Files Here !/6 - M Language Expressions Functions and Defensive Design/61. Defensive Programming.mp4 | 17.45 MB |
| ~Get Your Files Here !/6 - M Language Expressions Functions and Defensive Design/62. Module 5 wrap up.mp4 | 17.95 MB |
| ~Get Your Files Here !/7 - Designing Robust Power Query Solutions at Scale/63. Module 6 Introduction.mp4 | 29.94 MB |
| ~Get Your Files Here !/7 - Designing Robust Power Query Solutions at Scale/64. Unpivot Pitfalls Recap.mp4 | 76.25 MB |
| ~Get Your Files Here !/7 - Designing Robust Power Query Solutions at Scale/65. Solution Walkthrough Target Outcome.mp4 | 52.09 MB |
| ~Get Your Files Here !/7 - Designing Robust Power Query Solutions at Scale/66. Designing the Mental Model.mp4 | 101.46 MB |
| ~Get Your Files Here !/7 - Designing Robust Power Query Solutions at Scale/67. Implementing the Solution Using AI.mp4 | 89.67 MB |
| ~Get Your Files Here !/7 - Designing Robust Power Query Solutions at Scale/68. Testing the Setup.mp4 | 88.52 MB |
| ~Get Your Files Here !/7 - Designing Robust Power Query Solutions at Scale/69. Multi Sheet Consolidation Designing Guardrails.mp4 | 119.23 MB |
Trackers
No trackers found.