Udemy - Master Microsoft POWER QUERY in POWER BI and Excel (ETL Tool)
|
|
Torrent File Contents
Udemy - Master Microsoft POWER QUERY in POWER BI and Excel (ETL Tool)
Get Bonus Downloads Here.url
~Get Your Files Here !/1. PQ 1 - What is Power Query/1. PQ 1 - What is Power Query.mp4
~Get Your Files Here !/1. PQ 1 - What is Power Query/1.1 Sample Dataset.xlsx
~Get Your Files Here !/10. PQ 10 - Appending Data from Multiple Excel Worksheets/1. PQ 10 - Appending Data from Multiple Excel Worksheets.mp4
~Get Your Files Here !/10. PQ 10 - Appending Data from Multiple Excel Worksheets/1.1 Append Multiple Worksheets.xlsx
~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
~Get Your Files Here !/11. PQ 11 - Appending Data from Multiple Excel Workbooks (Same Table Names)/1.1 Apr.xlsx
~Get Your Files Here !/11. PQ 11 - Appending Data from Multiple Excel Workbooks (Same Table Names)/1.2 Feb.xlsx
~Get Your Files Here !/11. PQ 11 - Appending Data from Multiple Excel Workbooks (Same Table Names)/1.3 Jan.xlsx
~Get Your Files Here !/11. PQ 11 - Appending Data from Multiple Excel Workbooks (Same Table Names)/1.4 Mar.xlsx
~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
~Get Your Files Here !/12. PQ 11-1 - Appending Data from Multiple Excel Workbooks (Same Sheet Names)/1.1 East.xlsx
~Get Your Files Here !/12. PQ 11-1 - Appending Data from Multiple Excel Workbooks (Same Sheet Names)/1.2 North.xlsx
~Get Your Files Here !/12. PQ 11-1 - Appending Data from Multiple Excel Workbooks (Same Sheet Names)/1.3 South.xlsx
~Get Your Files Here !/12. PQ 11-1 - Appending Data from Multiple Excel Workbooks (Same Sheet Names)/1.4 West.xlsx
~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
~Get Your Files Here !/13. PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet/1.1 East.xlsx
~Get Your Files Here !/13. PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet/1.2 North.xlsx
~Get Your Files Here !/13. PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet/1.3 South.xlsx
~Get Your Files Here !/13. PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet/1.4 West.xlsx
~Get Your Files Here !/14. PQ 13 - Replace and Fill/1. PQ 13 - Replace and Fill.mp4
~Get Your Files Here !/14. PQ 13 - Replace and Fill/1.1 Replace and Fill.xlsx
~Get Your Files Here !/15. PQ 14 - Formatting Numbers and Dates/1. PQ 14 - Formatting Numbers and Dates.mp4
~Get Your Files Here !/15. PQ 14 - Formatting Numbers and Dates/1.1 Formatting Numbers and Dates.xlsx
~Get Your Files Here !/16. PQ 15 - Adding Custom Calculated Columns/1. PQ 15 - Adding Custom Calculated Columns.mp4
~Get Your Files Here !/16. PQ 15 - Adding Custom Calculated Columns/1.1 Adding Calculated Field in Custom Column.xlsx
~Get Your Files Here !/17. PQ 16 - GroupBy/1. PQ 16 - GroupBy.mp4
~Get Your Files Here !/17. PQ 16 - GroupBy/1.1 Merge in Power Query - Group-By.xlsx
~Get Your Files Here !/18. PQ 17 - Unpivot/1. PQ 17 - Unpivot.mp4
~Get Your Files Here !/18. PQ 17 - Unpivot/1.1 Unpivot Columns.xlsx
~Get Your Files Here !/19. PQ 18 - 6 Types of Joins/1. PQ 18 - 6 Types of Joins.mp4
~Get Your Files Here !/19. PQ 18 - 6 Types of Joins/1.1 Types of joins - Power Query and Power BI.xlsx
~Get Your Files Here !/2. PQ 2 - Data Types/1. PQ 2 - Data Types.mp4
~Get Your Files Here !/2. PQ 2 - Data Types/1.1 Data Types.xlsx
~Get Your Files Here !/20. PQ 19 - Create Calendar in PQ vs. DAX/1. PQ 19 - Create Calendar in PQ vs. DAX.mp4
~Get Your Files Here !/20. PQ 19 - Create Calendar in PQ vs. DAX/1.1 calendar-dax.txt
~Get Your Files Here !/3. PQ 3 - Fixing Dates & Date Locale Setting/1. PQ 3 - Fixing Dates & Date Locale Setting.mp4
~Get Your Files Here !/3. PQ 3 - Fixing Dates & Date Locale Setting/1.1 Locale Settings Date.csv
~Get Your Files Here !/4. PQ 4 - For Columns - MOVE, REMOVE, RENAME, DUPLICATES/1. PQ 4 - For Columns - MOVE, REMOVE, RENAME, DUPLICATES.mp4
~Get Your Files Here !/4. PQ 4 - For Columns - MOVE, REMOVE, RENAME, DUPLICATES/1.1 MOVE, REMOVE, RENAME, DUPLICATES Columns.xlsx
~Get Your Files Here !/5. PQ 5 - Split Columns/1. PQ 5 - Split Columns.mp4
~Get Your Files Here !/5. PQ 5 - Split Columns/1.1 Parse URLs.xlsx
~Get Your Files Here !/5. PQ 5 - Split Columns/1.2 Separating Text Fields.xlsx
~Get Your Files Here !/6. PQ 6 - Merge/1. PQ 6 - Merge.mp4
~Get Your Files Here !/6. PQ 6 - Merge/1.1 Merge in Power Query.xlsx
~Get Your Files Here !/7. PQ 7 - Filtering Rows/1. PQ 7 - Filtering Rows.mp4
~Get Your Files Here !/7. PQ 7 - Filtering Rows/1.1 Filtering Rows.xlsx
~Get Your Files Here !/8. PQ 8 - Removing Duplicates and Errors/1. PQ 8 - Removing Duplicates and Errors.mp4
~Get Your Files Here !/8. PQ 8 - Removing Duplicates and Errors/1.1 Removing Duplicates and Errors.xlsx
~Get Your Files Here !/9. PQ 9 - Sorting/1. PQ 9 - Sorting.mp4
~Get Your Files Here !/9. PQ 9 - Sorting/1.1 Sorting.xlsx
~Get Your Files Here !/Bonus Resources.txt
Get Bonus Downloads Here.url
- 182 Bytes
~Get Your Files Here !/1. PQ 1 - What is Power Query/1. PQ 1 - What is Power Query.mp4
- 50.25 MB
~Get Your Files Here !/1. PQ 1 - What is Power Query/1.1 Sample Dataset.xlsx
- 26.81 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.92 MB
~Get Your Files Here !/10. PQ 10 - Appending Data from Multiple Excel Worksheets/1.1 Append Multiple Worksheets.xlsx
- 28.91 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
- 62.96 MB
~Get Your Files Here !/11. PQ 11 - Appending Data from Multiple Excel Workbooks (Same Table Names)/1.1 Apr.xlsx
- 11.54 KB
~Get Your Files Here !/11. PQ 11 - Appending Data from Multiple Excel Workbooks (Same Table Names)/1.2 Feb.xlsx
- 11.53 KB
~Get Your Files Here !/11. PQ 11 - Appending Data from Multiple Excel Workbooks (Same Table Names)/1.3 Jan.xlsx
- 11.58 KB
~Get Your Files Here !/11. PQ 11 - Appending Data from Multiple Excel Workbooks (Same Table Names)/1.4 Mar.xlsx
- 11.58 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.74 MB
~Get Your Files Here !/12. PQ 11-1 - Appending Data from Multiple Excel Workbooks (Same Sheet Names)/1.1 East.xlsx
- 11.78 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.77 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.72 MB
~Get Your Files Here !/13. PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet/1.1 East.xlsx
- 12.33 KB
~Get Your Files Here !/13. PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet/1.2 North.xlsx
- 12.34 KB
~Get Your Files Here !/13. PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet/1.3 South.xlsx
- 12.34 KB
~Get Your Files Here !/13. PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet/1.4 West.xlsx
- 12.17 KB
~Get Your Files Here !/14. PQ 13 - Replace and Fill/1. PQ 13 - Replace and Fill.mp4
- 29.03 MB
~Get Your Files Here !/14. PQ 13 - Replace and Fill/1.1 Replace and Fill.xlsx
- 11.47 KB
~Get Your Files Here !/15. PQ 14 - Formatting Numbers and Dates/1. PQ 14 - Formatting Numbers and Dates.mp4
- 34.67 MB
~Get Your Files Here !/15. PQ 14 - Formatting Numbers and Dates/1.1 Formatting Numbers and Dates.xlsx
- 20.85 KB
~Get Your Files Here !/16. PQ 15 - Adding Custom Calculated Columns/1. PQ 15 - Adding Custom Calculated Columns.mp4
- 24.35 MB
~Get Your Files Here !/16. PQ 15 - Adding Custom Calculated Columns/1.1 Adding Calculated Field in Custom Column.xlsx
- 39.39 KB
~Get Your Files Here !/17. PQ 16 - GroupBy/1. PQ 16 - GroupBy.mp4
- 90.55 MB
~Get Your Files Here !/17. PQ 16 - GroupBy/1.1 Merge in Power Query - Group-By.xlsx
- 55.76 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.46 KB
~Get Your Files Here !/19. PQ 18 - 6 Types of Joins/1. PQ 18 - 6 Types of Joins.mp4
- 230.74 MB
~Get Your Files Here !/19. PQ 18 - 6 Types of Joins/1.1 Types of joins - Power Query and Power BI.xlsx
- 11.17 KB
~Get Your Files Here !/2. PQ 2 - Data Types/1. PQ 2 - Data Types.mp4
- 13.73 MB
~Get Your Files Here !/2. PQ 2 - Data Types/1.1 Data Types.xlsx
- 26.81 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.55 MB
~Get Your Files Here !/20. PQ 19 - Create Calendar in PQ vs. DAX/1.1 calendar-dax.txt
- 571 Bytes
~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.37 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.27 MB
~Get Your Files Here !/4. PQ 4 - For Columns - MOVE, REMOVE, RENAME, DUPLICATES/1.1 MOVE, REMOVE, RENAME, DUPLICATES Columns.xlsx
- 64.74 KB
~Get Your Files Here !/5. PQ 5 - Split Columns/1. PQ 5 - Split Columns.mp4
- 44.48 MB
~Get Your Files Here !/5. PQ 5 - Split Columns/1.1 Parse URLs.xlsx
- 11.19 KB
~Get Your Files Here !/5. PQ 5 - Split Columns/1.2 Separating Text Fields.xlsx
- 13.42 KB
~Get Your Files Here !/6. PQ 6 - Merge/1. PQ 6 - Merge.mp4
- 46.53 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.74 KB
~Get Your Files Here !/8. PQ 8 - Removing Duplicates and Errors/1. PQ 8 - Removing Duplicates and Errors.mp4
- 26.49 MB
~Get Your Files Here !/8. PQ 8 - Removing Duplicates and Errors/1.1 Removing Duplicates and Errors.xlsx
- 13.55 KB
~Get Your Files Here !/9. PQ 9 - Sorting/1. PQ 9 - Sorting.mp4
- 28.99 MB
~Get Your Files Here !/9. PQ 9 - Sorting/1.1 Sorting.xlsx
- 26.81 KB
~Get Your Files Here !/Bonus Resources.txt
- 386 Bytes
Torrent Description
Master Microsoft POWER QUERY in POWER BI & Excel (ETL Tool)
https://DevCourseWeb.com
Published 12/2022
Created by Rahim Zulfiqar Ali
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 20 Lectures ( 2h 19m ) | Size: 1.1 GB
Learn how to import, transform and prepare data using the Query Editor in Microsoft Power BI
What you'll learn
Enjoy CLEAR and CONCISE step by step lessons from instructor in FULL HD 1080 P video
Perform BASIC transformations such as filtering, changing data types, remove columns and creating new calculated columns
Learn to CLEAN data and LOAD data using parameters
Perform ADVANCED transformations such as Merging, Appending, Unpivoting, Grouping and Calculating Custom Columns
Requirements
Download the Power BI Desktop app which is available free from Microsoft for Windows