MASTERCLASS - Microsoft Power Query Fundamentals Concepts with Tips & Tricks | Microsoft POWER BI
Learn how to import, transform and prepare data using the Query Editor in Microsoft Power BI
Lectures -16
Resources -30
Duration -2 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
MASTERCLASS - Microsoft Power Query Fundamentals Concepts with Tips & Tricks | Microsoft POWER BI
Skills in data analysis, reporting and the creation of dashboards are HIGHLY valued in today's business environment. Microsoft Power BI is now recognized as the leading Business Intelligence tool in the world for developing reports, data analysis, and dashboards.
In this course, you will learn the to use the AMAZING Power BI tool to transform and prepare your data for analysis. You will learn to use the Query Editor to connect to data, perform advanced transformation, and clean data.
In this course :
PQ 1 - What is Power Query
PQ 2 - Data Types
PQ 3 - Fixing Dates & Date Locale Setting
PQ 4 - For Columns - MOVE, REMOVE, RENAME, DUPLICATES
PQ 5 - Split Columns
PQ 6 - Merge
PQ 7 - Filtering Rows
PQ 8 - Removing Duplicates and Errors
PQ 9 - Sorting
PQ 10 - Appending Data from Multiple Excel Worksheets
PQ 11 - Appending Data from Multiple Excel Workbooks (Same Table Names)
PQ 11-1 - Appending Data from Multiple Excel Workbooks (Same Sheet Names)
PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet Names
PQ 13 - Replace and Fill
PQ 14 - Formatting Numbers and Dates
PQ 15 - Adding Custom Calculated Columns
PQ 16 - GroupBy
PQ 17 - Unpivot
PQ 18 - 6 Types of Joins
PQ 19 - Create Calendar in PQ vs. DAX
Goals
- Power Query is an ETL tool created by Microsoft for data extraction, loading, and transformation, and it is used to retrieve data from sources, process it, and load them into one or more target systems.
Prerequisites
- None
![MASTERCLASS - Microsoft Power Query Fundamentals Concepts with Tips & Tricks | Microsoft POWER BI MASTERCLASS - Microsoft Power Query Fundamentals Concepts with Tips & Tricks | Microsoft POWER BI](https://d3mxt5v3yxgcsr.cloudfront.net/courses/13666/course_13666_image.png)
Curriculum
Check out the detailed breakdown of what’s inside the course
PQ 1 - What is Power Query
1 Lectures
-
PQ 1 - What is Power Query 06:34 06:34
PQ 2 - Data Types
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PQ 3 - Fixing Dates & Date Locale Setting
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PQ 4 - For Columns - MOVE, REMOVE, RENAME, DUPLICATES
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PQ 5 - Split Columns
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PQ 6 - Merge
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PQ 7 - Filtering Rows
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PQ 8 - Removing Duplicates and Errors
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PQ 9 - Sorting
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PQ 10 - Appending Data from Multiple Excel Worksheets
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PQ 11 - Appending Data from Multiple Excel Workbooks (Same Table Names)
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PQ 11-1 - Appending Data from Multiple Excel Workbooks (Same Sheet Names)
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PQ 12 - Appending Data from Multiple Excel Workbooks - Different Table and Sheet Names
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PQ 13 - Replace and Fill
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PQ 14 - Formatting Numbers and Dates
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PQ 15 - Adding Custom Calculated Columns
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PQ 16 - GroupBy
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PQ 17 - Unpivot
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PQ 18 - 6 Types of Joins
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
PQ 19 - Create Calendar in PQ vs. DAX
1 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![user profile image](/market/public/assets/newDesign/img/default-user-img.jpg)
Rahim Zulfiqar Ali
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)