[ WebToolTip.com ] Udemy - Power Query Masterclass - Advanced Data Cleaning and Automation
大小2.75 GB
文件数116
Info Hash:7ACCBAAD5938E1C201C776CDE2DAA08467516C28
收录时间2026-01-23 07:08:30
更新时间2026-01-23 07:08:30
文件列表 (116)
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
~Get Your Files Here !/7 - Designing Robust Power Query Solutions at Scale/70. Multi Sheet Consolidation Implementing with AI.mp4
71.27 MB
~Get Your Files Here !/7 - Designing Robust Power Query Solutions at Scale/71. Multi Sheet Consolidation Testing and Validation.mp4
23.65 MB
~Get Your Files Here !/7 - Designing Robust Power Query Solutions at Scale/72. Handling Changed Type with Parameters.mp4
62.41 MB
~Get Your Files Here !/7 - Designing Robust Power Query Solutions at Scale/73. Handling Row Level Errors Safely.mp4
29.43 MB
~Get Your Files Here !/7 - Designing Robust Power Query Solutions at Scale/74. Folder Based Consolidation.mp4
42.73 MB
~Get Your Files Here !/7 - Designing Robust Power Query Solutions at Scale/75. Course Summary and Final Thoughts.mp4
29.59 MB
~Get Your Files Here !/7 - Designing Robust Power Query Solutions at Scale/M6/Folder Combine/Files/Apr.xlsx
8.56 KB
~Get Your Files Here !/7 - Designing Robust Power Query Solutions at Scale/M6/Folder Combine/Files/Feb.xlsx
8.52 KB
~Get Your Files Here !/7 - Designing Robust Power Query Solutions at Scale/M6/Folder Combine/Files/Jan.xlsx
8.53 KB
~Get Your Files Here !/7 - Designing Robust Power Query Solutions at Scale/M6/Folder Combine/Files/Mar.xlsx
8.53 KB
~Get Your Files Here !/7 - Designing Robust Power Query Solutions at Scale/M6/Folder Combine/M7 - Folder Combine.xlsx
27.04 KB
~Get Your Files Here !/7 - Designing Robust Power Query Solutions at Scale/M6/Multisheet Consol/M7 - Consol.xlsx
27.3 KB
~Get Your Files Here !/7 - Designing Robust Power Query Solutions at Scale/M6/Multisheet Consol/MultiSheet_Sales.xlsx
13.85 KB
~Get Your Files Here !/7 - Designing Robust Power Query Solutions at Scale/M6/Unpivot/Unpivot Clean.xlsx
27.55 KB
~Get Your Files Here !/7 - Designing Robust Power Query Solutions at Scale/M6/Unpivot/Unpivot_Exercise.xlsx