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
Instructor Led
yes
CPD Hours
1.5 hour
Access
12 month
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 18460 Reviews
Course was very good with practical applications covered extremely well. Steven was a very good presenter and covered all the requirements very well -PowerPoint Level 2 Brisbane
Mark - PowerPoint Level 2, .
Thanks Nexacu. Ben did a great job explaining things clearly and answering our individual questions. This was a great day. Many thanks. -Word Intermediate Brisbane
Tempe - Word Intermediate, .
Very helpful course. Teacher was lovely and patient This course is going to help me in my work. Thank you. -PowerPoint Level 2 Brisbane
Loren - PowerPoint Level 2, .
A lot of new information. Lots of info hard to take in everything. Learnt lots -PowerPoint Level 2 Brisbane
Gloria - PowerPoint Level 2, .
Covered a good range of topics and exercises. The course was very interactive which was great. I feel like the course needs to be longer to allow more time to build and practice skills or perhaps offer a beginner and advanced course. There is an awful lot that the software can do. It would be useful to be able to follow along with the manual as I'm worried I'll get lost when I try this in practice. -SharePoint Site Owner Adelaide
Sarah - SharePoint Site Owner, .
Great break down and summary with each section covered. Easy to follow with good examples. Facilitator was able to adjust the course to the different levels within our group. Inspired to try and test my knowledge back in the office. -SharePoint Site Owner Adelaide
Kristine - SharePoint Site Owner, .
It was a very complex topic which got confusing at times but I ended up taking away a lot of new knowledge which will be very useful in my work. -SharePoint Site Owner Adelaide
Cindy - SharePoint Site Owner, .
Fantastic couple of days. Very informative and I appreciate your patience training style. -SharePoint Site Owner Adelaide
Christine - SharePoint Site Owner, .
Jagg explained things well and made the course easy to understand. He is light and entertaining and made the days go fast. Thanks -SharePoint Site Owner Adelaide
Natalie - SharePoint Site Owner, .
Very interesting course -SharePoint Site Owner Adelaide
Jade - SharePoint Site Owner, .
Thank you, this was a very useful course. It is finally tying in all the bits I needed to have a full view of this product. -Power BI DAX Sydney
Wendy - Power BI DAX, .
Very helpful, thanks -Power BI DAX Sydney
Kate - Power BI DAX, .
Good pace and useful content -Office365 Intermediate Parramatta
Linda - Office365 Intermediate, .
was great and very informative. makes using PP seems so easy -PowerPoint Level 2 Melbourne
Fleur - PowerPoint Level 2, .
John was a great trainer. Very easy to follow and understand. I have left today definitely feeling like I have learnt something. Thank you. -PowerPoint Level 2 Melbourne
Jamie - PowerPoint Level 2, .
I thought it was very informative I learnt a lot and would highly recommend -PowerPoint Level 2 Melbourne
Jason - PowerPoint Level 2, .
Great trainer, very informative session. -PowerPoint Level 2 Melbourne
Rachael - PowerPoint Level 2, .
Knowledgeable. Able to answer my queries. -PowerPoint Level 2 Melbourne
Efrat - PowerPoint Level 2, .
Comprehensive course with knowledgeable trainer. -PowerPoint Level 2 Melbourne
Sai - PowerPoint Level 2, .
Very usufull -Excel Advanced Melbourne
wasantha - Excel Advanced, .

Trusted by Business

Procured by Government

Map of Australia