If you work with data in any capacity, you probably know that the most tedious part of all the tasks is getting the data ready. Nevertheless, it is arguably the most essential part of the analytics process because it lays the foundation for every other aspect.
If you get it wrong at the Data Prep stage, many things will go wrong down the line. That is why the instructor has specified and recommended strictly that all intending students of this course must complete the following course first:
Don’t worry, it is also free 😉
Microsoft Power Query is an easy-to-use and powerful ETL application with Desktop versions running in Excel and Power BI.
In this course, you will learn and master the use of Power Query to Extract, Transform, Prepare, and Clean dirty data.
Some specific things you will learn are:
- Connecting to Data Sources
- Profiling and Exploring Data in Power Query
- Combining Data with Power Query (Joins and Union)
- Shaping and Transposing Data with Power Query
- Dealing with Errors in Power Query
- Summarizing Data with Group By in Power Query
What Will You Learn?
- Gain proficiency in using Microsoft Power Query for effective data extraction.
- Learn advanced techniques for connecting to various data sources.
- Develop skills in data profiling and exploration to understand data quality and structure.
- Master the art of combining data from different sources using Joins and Union methods.
- Acquire the ability to shape and transpose data for tailored analysis.
- Enhance your skills in identifying and resolving errors within Power Query.
- Discover methods for summarizing and grouping data to extract meaningful insights.
- Understand the process of cleaning and preparing data for accurate analytics.
- Develop a solid foundation in ETL processes, crucial for data analytics.
- Equip yourself with practical, hands-on experience in data manipulation and analysis.
Getting Data into Power Query06:34
Understanding how Power Query works08:24
Previewing Column Quality for Errors and Empty values03:37
Previewing number of Unique and Distinct Values with Column Distribution04:16
Previewing Column Statistical Summaries with Column Profile03:20
Setting Data Preview Checks for Entire Dataset01:30
Structuring Data in Power Query
Creating New Columns in Power Query
Other Power Query Transformations
Cleaning Dirty Data
This course offers certificate of completion
Add this certificate to your resume, and be the standout candidate recruiters cannot ignore