Basics of Power Query
- Offered byAlison
Basics of Power Query at Alison Overview
Basics of Power Query
at Alison
Learn how to extract and transform data using Power Query for Microsoft Excel with this free online course
Duration | 2 hours |
Total fee | Free |
Mode of learning | Online |
Official Website | Explore Free Course  |
Credential | Certificate |
Basics of Power Query at Alison Highlights
Basics of Power Query
at Alison
- Earn a certificate of completion from Alison
Basics of Power Query at Alison Course details
Basics of Power Query
at Alison
Skills you will learn
Who should do this course?
- For anyone working with large sets of data in data science, data analytics or engineering
What are the course deliverables?
- Discuss the history of the Microsoft Excel Power Query tool
- Explain the process of manipulating data with Power Query in Excel
- Summarize the steps for wrangling data to solve various problems
- Define the concept of M code
- Indicate the process of locating the M code
- Outline the Power Query features and items
- List the stages involved in merging several datasets from various systems
- Describe how to change the sample file
- Summarize the process of combining data from other folders
More about this course
- This free online Microsoft Excel tutorial focuses on Power Query's core functions, like data extraction, transformation, and reshaping
- You will discover new ways to process data by learning how to connect multiple data sources and perform transformations within the data before creating reports
- This advanced Microsoft Excel course takes you through how Power Query, like Power Pivot and Power View, is part of the Power BI Suite
- It begins by explaining the data manipulation techniques and the methods of fixing specific problems in the query table, such as changing the headers' names, filtering out null values, condensing three columns into one, removing a column, and saving the new file
- The next section of this Power BI training discusses the concept of M code and many Power Query features with their functionality, including Choose Column, Keep Rows, Remove Alternate Rows, Split Column, Merge Queries, Transform, Move, Format and others
- Your learning concludes by comprehensively covering the procedure for constructing a relationship between two tables so that you can look up data and get matching results as well as how to combine multiple data from the same folder
Basics of Power Query at Alison Curriculum
Basics of Power Query
at Alison
Using Power Query
Using Power Query - Learning OutcomesStart Topic
Introduction To Power QueryStart Topic
Manipulating DataStart Topic
Tour Of Power Query ItemsStart Topic
File From FolderStart Topic
Using Power Query - Lesson Summary
Course Assessment
Fundamentals Of Power Query - Course Assessment
Other courses offered by Alison
Free
1 hours
– / –
View Other 299 Courses
Basics of Power Query
at Alison
Student Forum
Anything you would want to ask experts?