Udemy - Master Microsoft POWER QUERY in POWER BI and Excel (ETL Tool)

• Udemy - Master Microsoft POWER QUERY in POWER BI and Excel (ETL Tool)
• ~Get Your Files Here !/1. PQ 1 - What is Power Query/1. PQ 1 - What is Power Query.mp4 50.2 MB
• ~Get Your Files Here !/1. PQ 1 - What is Power Query/1.1 Sample Dataset.xlsx 26.8 KB
• ~Get Your Files Here !/10. PQ 10 - Appending Data from Multiple Excel Worksheets/1. PQ 10 - Appending Data from Multiple Excel Worksheets.mp4 79.9 MB
• ~Get Your Files Here !/10. PQ 10 - Appending Data from Multiple Excel Worksheets/1.1 Append Multiple Worksheets.xlsx 28.9 KB
• ~Get Your Files Here !/11. PQ 11 - Appending Data from Multiple Excel Workbooks (Same Table Names)/1. PQ 11 - Appending Data from Multiple Excel Workbooks (Same Table Names).mp4 63 MB
• ~Get Your Files Here !/11. PQ 11 - Appending Data from Multiple Excel Workbooks (Same Table Names)/1.1 Apr.xlsx 11.5 KB
• ~Get Your Files Here !/11. PQ 11 - Appending Data from Multiple Excel Workbooks (Same Table Names)/1.2 Feb.xlsx 11.5 KB
• ~Get Your Files Here !/11. PQ 11 - Appending Data from Multiple Excel Workbooks (Same Table Names)/1.3 Jan.xlsx 11.6 KB
• ~Get Your Files Here !/11. PQ 11 - Appending Data from Multiple Excel Workbooks (Same Table Names)/1.4 Mar.xlsx 11.6 KB
• ~Get Your Files Here !/12. PQ 11-1 - Appending Data from Multiple Excel Workbooks (Same Sheet Names)/1. PQ 11-1 - Appending Data from Multiple Excel Workbooks (Same Sheet Names).mp4 39.7 MB
• ~Get Your Files Here !/12. PQ 11-1 - Appending Data from Multiple Excel Workbooks (Same Sheet Names)/1.1 East.xlsx 11.8 KB
• ~Get Your Files Here !/12. PQ 11-1 - Appending Data from Multiple Excel Workbooks (Same Sheet Names)/1.2 North.xlsx 11.7 KB
• ~Get Your Files Here !/12. PQ 11-1 - Appending Data from Multiple Excel Workbooks (Same Sheet Names)/1.3 South.xlsx 11.8 KB
• ~Get Your Files Here !/12. PQ 11-1 - Appending Data from Multiple Excel Workbooks (Same Sheet Names)/1.4 West.xlsx 11.8 KB
• ~Get Your Files Here !/13. PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet/1. PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet.mp4 69.7 MB
• ~Get Your Files Here !/13. PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet/1.1 East.xlsx 12.3 KB
• ~Get Your Files Here !/13. PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet/1.2 North.xlsx 12.3 KB
• ~Get Your Files Here !/13. PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet/1.3 South.xlsx 12.3 KB
• ~Get Your Files Here !/13. PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet/1.4 West.xlsx 12.2 KB
• ~Get Your Files Here !/14. PQ 13 - Replace and Fill/1. PQ 13 - Replace and Fill.mp4 29 MB
• ~Get Your Files Here !/14. PQ 13 - Replace and Fill/1.1 Replace and Fill.xlsx 11.5 KB
• ~Get Your Files Here !/15. PQ 14 - Formatting Numbers and Dates/1. PQ 14 - Formatting Numbers and Dates.mp4 34.7 MB
• ~Get Your Files Here !/15. PQ 14 - Formatting Numbers and Dates/1.1 Formatting Numbers and Dates.xlsx 20.8 KB
• ~Get Your Files Here !/16. PQ 15 - Adding Custom Calculated Columns/1. PQ 15 - Adding Custom Calculated Columns.mp4 24.4 MB
• ~Get Your Files Here !/16. PQ 15 - Adding Custom Calculated Columns/1.1 Adding Calculated Field in Custom Column.xlsx 39.4 KB
• ~Get Your Files Here !/17. PQ 16 - GroupBy/1. PQ 16 - GroupBy.mp4 90.6 MB
• ~Get Your Files Here !/17. PQ 16 - GroupBy/1.1 Merge in Power Query - Group-By.xlsx 55.8 KB
• ~Get Your Files Here !/18. PQ 17 - Unpivot/1. PQ 17 - Unpivot.mp4 39.9 MB
• ~Get Your Files Here !/18. PQ 17 - Unpivot/1.1 Unpivot Columns.xlsx 10.5 KB
• ~Get Your Files Here !/19. PQ 18 - 6 Types of Joins/1. PQ 18 - 6 Types of Joins.mp4 230.7 MB
• ~Get Your Files Here !/19. PQ 18 - 6 Types of Joins/1.1 Types of joins - Power Query and Power BI.xlsx 11.2 KB
• ~Get Your Files Here !/2. PQ 2 - Data Types/1. PQ 2 - Data Types.mp4 13.7 MB
• ~Get Your Files Here !/2. PQ 2 - Data Types/1.1 Data Types.xlsx 26.8 KB
• ~Get Your Files Here !/20. PQ 19 - Create Calendar in PQ vs. DAX/1. PQ 19 - Create Calendar in PQ vs. DAX.mp4 110.5 MB
• ~Get Your Files Here !/20. PQ 19 - Create Calendar in PQ vs. DAX/1.1 calendar-dax.txt 571 B
• ~Get Your Files Here !/3. PQ 3 - Fixing Dates & Date Locale Setting/1. PQ 3 - Fixing Dates & Date Locale Setting.mp4 42.4 MB
• ~Get Your Files Here !/3. PQ 3 - Fixing Dates & Date Locale Setting/1.1 Locale Settings Date.csv 75.4 KB
• ~Get Your Files Here !/4. PQ 4 - For Columns - MOVE, REMOVE, RENAME, DUPLICATES/1. PQ 4 - For Columns - MOVE, REMOVE, RENAME, DUPLICATES.mp4 26.3 MB
• ~Get Your Files Here !/4. PQ 4 - For Columns - MOVE, REMOVE, RENAME, DUPLICATES/1.1 MOVE, REMOVE, RENAME, DUPLICATES Columns.xlsx 64.7 KB
• ~Get Your Files Here !/5. PQ 5 - Split Columns/1. PQ 5 - Split Columns.mp4 44.5 MB
• ~Get Your Files Here !/5. PQ 5 - Split Columns/1.1 Parse URLs.xlsx 11.2 KB
• ~Get Your Files Here !/5. PQ 5 - Split Columns/1.2 Separating Text Fields.xlsx 13.4 KB
• ~Get Your Files Here !/6. PQ 6 - Merge/1. PQ 6 - Merge.mp4 46.5 MB
• ~Get Your Files Here !/6. PQ 6 - Merge/1.1 Merge in Power Query.xlsx 55.8 KB
• ~Get Your Files Here !/7. PQ 7 - Filtering Rows/1. PQ 7 - Filtering Rows.mp4 19.5 MB
• ~Get Your Files Here !/7. PQ 7 - Filtering Rows/1.1 Filtering Rows.xlsx 64.7 KB
• ~Get Your Files Here !/8. PQ 8 - Removing Duplicates and Errors/1. PQ 8 - Removing Duplicates and Errors.mp4 26.5 MB
• ~Get Your Files Here !/8. PQ 8 - Removing Duplicates and Errors/1.1 Removing Duplicates and Errors.xlsx 13.5 KB
• ~Get Your Files Here !/9. PQ 9 - Sorting/1. PQ 9 - Sorting.mp4 29 MB
• ~Get Your Files Here !/9. PQ 9 - Sorting/1.1 Sorting.xlsx 26.8 KB
• ~Get Your Files Here !/Bonus Resources.txt 386 B

No comments yet.