POWER QUERY COURSE

What is Power Query?

Power Query is a data transformation and data preparation engine. Power Query comes with a graphical interface for getting data from sources and a Power Query Editor for applying transformations. Because the engine is available in many products and services, the destination where the data will be stored depends on where Power Query was used. Using Power Query, you can perform the extract, transform, and load (ETL) processing of data.

Course Overview?

Do you spend time each month/day cleaning and transforming data into the right format before you can even begin to analyse it or incorporate it into your reports? If you are using MUSE or any other ERP, then you must understand what I mean! The Data Cleaning hassle is real!

Do you perform repetitive data cleansing tasks like:

Deleting rows, columns, or blanks, filtering out data you don’t need

Fixing the layout so it will work in a PivotTable

Splitting or joining columns or text, removing spaces and special characters from your data

Merging worksheets, text/CSV files together, extracting data from external sources, etc.

The Good News!

If you have Excel 2013, or later, you can use Power Query to automate the tasks of:

Getting your data – from almost anywhere

Cleaning and reformatting your data – so it works in Pivot Tables etc.

Updating your reports – Power Query will update new or existing Tables, PivotTables or Power Pivot models

You see once you show Power Query where to find your data and how you want it cleaned and reformatted (which is dead easy), it will remember the steps so next time you can simply hit the Refresh button and it’ll do it automatically.

If you haven’t heard of Excel’s Power Query tool, or you’ve heard of it but you’re not sure if it’ll be useful to you, then don’t dare to miss our training where I will show you practically what the fuss is all about. And this means after data cleaning and formatting, you can get on with the fun part of Analysing the Big Data and impressing your boss so you can go home early. And this is where the Power Business Intelligence (Power BI) comes in!

Target group

This Power Query course is perfect for anyone who would like to build up their understanding of Business Intelligence. This course is designed to equip anyone who desires to begin a career in data analysis, quantitative analysis, business intelligence, or other areas of finance with the fundamental knowledge of Power Query.

Course contents

• Adding Columns
• Appending Queries
• Columns – Move, Remove, Rename & Duplicate
• Combine Multiple Files Containing Multiple Sheets
• Data Source and Privacy Settings
• Duplicating and Referencing Another Query
• Editing and Optimising Queries
• Filtering Rows
• Use First Rows as Headers
• Date
• Getting Data from multiple sources
• Grouping
• If Function
• Introduction to M
• Load Settings & Automatic Refresh
• Loading to the Data Model or Power Pivot
• Loading to the Workbook Options
• Merging Columns
• Merging Queries
• Multiple Excel Tables or Named Ranges
• Organising Queries
• Power Query in Power BI vs Excel
• Query Dependencies View
• Remove Duplicates & Errors
• Replace and Fill
• Sorting
• Splitting Columns and Extracting Text
• Transforming Dates
• Transforming Text and Numbers
• Transpose
• Unpivot
• Column Form Examples
• Custom Column
• What is Power Query
• Where to Edit and Write M
• Worksheets not Correctly Formatted