This course is ideal for accounting professionals, financial analysts, and anyone who regularly works with data and seeks to improve their skills in data management and analysis using Power Query.
Learning Objectives
After attending this presentation you will be able to ...
- Identify the key features and functionalities of Microsoft Power Query.
- Distinguish between different data transformation techniques in Power Query, including data cleaning, merging, and pivoting.
- Indicate the best practices for documenting each step in your data transformation process.
Major Topics
The major topics that will be covered in this class include:
- Introduction to Power Query in Power BI: Understanding the interface and basic functionalities.
- Data Cleaning Techniques: Removing duplicates, handling null values, and data type conversions.
- Data Transformation: Advanced methods for manipulating data, including pivoting, merging, and appending queries.
- Data Loading: Efficiently loading data into the Power BI data model.
- Document the Process Steps: Setting up details for each step in the process so you can document what is happening and why.
