Previously Excel Consulting

power bi courses nexacu

Power Query Transformations

Preparing data sources for analysis using Power Query

Data is all around us. We get it from many sources and don’t always have control of its format or layout, which can make it difficult to analyse, draw insights from and visualise.

Power Query (part of Excel and Power BI) gives you the tools to connect to many data sources and apply transformations including merging, shaping and cleansing.

We are passionate about teaching skills that participants can put to practical use immediately. During this webinar we will show you a number of common data problems and demonstrate various transformation techniques that you can put into practice straight away.

Course Details
Price
$99
Duration
90 minutes
Interactive Courseware
provided
Practise Exams
provided
Instructor Led
yes
CPD Hours
1.5 hour
Access
12 month
Live Q&A
yes
Skill Level
Advanced
Course Prerequisites

There are basic skills and software requirements for this workshop. To get the most out of this webinar, make sure you have the software ready to go.

Skill Requirements:

  • Intermediate to Advanced users of Excel.
  • Some basic knowledge of Power Query is assumed.
  • Power BI Intermediate course level knowledge.

Software Requirements:

  • Power Query either in Excel or Power BI
  • Introduction to Power Query
  • Navigating the Power Query Workspace
  • Power Query in Excel and Power BI
  • The M language
  • Accessing the Advanced Editor and Formula bar
  • Using query steps

 

  • Why we transform data
  • What data formats work best
  • Less columns, more rows
  • One row, one record

 

  • Transforming simple Pivoted Data tables 
  • Removing rows
  • Using Fill up/down
  • Using Go To Special in Excel
  • Using filters on rows
  • Using Unpivot
  • Renaming columns

 

  • Using the transformed output
  • Loading to Excel
  • Loading to Power BI for visualisation
  • Copying data direct from Power Query

 

  • Transforming large and complex Pivot Tables
  • Transforming nested (multiple) row headers
  • Using Transpose
  • Using Merge columns
  • Testing the transformation steps for updated data

 

  • Connecting to multiple web pages
  • Importing a web query using parameters
  • Creating a custom function
  • Defining a List to create a new Query
  • Invoking custom functions

 

  • Appending multiple tables with varying columns
  • Appending multiple tables
  • Merging and Splitting columns

Learning Outcomes

Face to Face Courses
microsoft_gold
Try our skills test

Test your skills and find out which course is right for you.

Choose a Quiz

 

Contact Us

How do Online Courses work?

 

Book

Find the online course or webinar you

would like to sit and hit book now.

Login

Receive your login details and follow the instructions

to log on to the Nexacu learning portal.

Learn

Complete your online course or view

your webinar at your own pace.

System Requirements

Browser

  • Internet Explorer: Version 9 to 11
  • Firefox or Google Chrome: Latest Version

Software requirements

  • Microsoft Windows 7/8/10
  • Apple Mac OS X 10.5.x, 10.6.x *(Online self-paced courses courseware works with Mac OS, diagnostic tests do not.)

Why choose Nexacu?

Valued by Individuals

4.8/5
Over 16337 Reviews
Excellent introduction to Macro's Great run through pivots -Excel Advanced Brisbane
Clinton - Excel Advanced, .
Very useful. I wish we could cover more. -Excel Advanced Brisbane
Corinne - Excel Advanced, .
data consolidation was good -Excel Advanced Brisbane
Ashlee - Excel Advanced, .
Very good and highly informative. Lots of new information that I can now experiment with. -Excel Advanced Brisbane
Stuart - Excel Advanced, .
Excellent course, learnt a lot that will help me with my job -Excel Advanced Brisbane
Amy - Excel Advanced, .
The pace was good and the instructor remained aware of who was keeping up which is nice. I learnt a few things I didn't know but I guess about half of the content was known to me. good day thank you -Power BI Advanced Brisbane
Bonnie - Power BI Advanced, .
Great course. Afternoon content especially interesting. -Power BI Advanced Brisbane
Jennifer - Power BI Advanced, .
Good course. -Power BI Advanced Brisbane
Esther - Power BI Advanced, .
Good course. Learnt a lot. -Power BI Advanced Brisbane
Sarah - Power BI Advanced, .
great step by step instructions and also note to take home -Power BI Advanced Brisbane
Priyal - Power BI Advanced, .
Really good, will be implementing quite a few of the things i learnt today when i get back to work tomorrow. Good pace, clear instructor. -Power BI Advanced Brisbane
Gihan - Power BI Advanced, .
Well structured course. -Power BI Advanced Brisbane
Glen - Power BI Advanced, .
I found Jacqui to be an enthusiastic and very knowledgeable tutor. she was keen to make sure all the class not only worked at their own pace, but ensured that they were able to complete all exercise tasks - she is a great asset to your company -Project Beginner Adelaide
Chris - Project Beginner, .
excellent -Excel Advanced Melbourne
patelharshal1011@gmail.com - Excel Advanced, .
Great new tools - Excel Advanced Melbourne
Sabrina - Excel Advanced, .
Very good -Excel Advanced Melbourne
Sophea - Excel Advanced, .
A great course -Project Beginner Canberra
ivan - Project Beginner, .
Tim is professional and helpful with questions -Excel Advanced Melbourne
Anna - Excel Advanced, .
Very interesting to learn new functions. -Excel Advanced Melbourne
Taihla - Excel Advanced, .
Clear, concise and relevant. -Excel Advanced Melbourne
Suzanne - Excel Advanced, .

Trusted by Business

Procured by Government

Map of Australia