~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