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?

 

Booknexacu book

Fine the online course or webinar you would like to sit and hit book now.

Loginnexacu login

Receive your login details and follow the instructions to log on to the Nexacu learning portal.

Learnnexacu 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 15837 Reviews
Training is really good. Topics selected were good and all questions were answered patiently. Will prefer this facilitator for the next sessions. -Power BI Intermediate Canberra
suz - Power BI Intermediate, .
Great course, great trainer learned alot -Analysis & Dashboards Brisbane
Karen - Analysis & Dashboards, .
Found it to be very informative. Now I need to go and put it into action. Jagg was an excellent trainer, just the right level of understanding of the differing skills in the room. -Power BI Intermediate Adelaide
John - Power BI Intermediate, .
Thank you -Power BI Intermediate Canberra
Anon - Power BI Intermediate, .
Great -Power BI Intermediate Adelaide
David - Power BI Intermediate, .
Good trainer who made sure I understood everything and took the time to cover any queries I had. Very interactive which really helped my understanding. -Analysis & Dashboards Brisbane
Amy - Analysis & Dashboards, .
Thank you -Analysis & Dashboards Brisbane
LGC - Analysis & Dashboards, .
Excellent Trainer -Power BI Intermediate Canberra
Prakash - Power BI Intermediate, .
Thanks! -Power BI Intermediate Canberra
GP - Power BI Intermediate, .
Thanks. Good efficient course and engaging instructor! -Power BI Intermediate Canberra
Elise - Power BI Intermediate, .
Great knowledge of the trainer, who provided data insight and visualisation advice for various audience -Power BI Beginner Melbourne
Zoe - Power BI Beginner, .
Comprehensive and great for beginners -Power BI Beginner Melbourne
mlim - Power BI Beginner, .
clear teaching -Power BI Beginner Melbourne
Lay - Power BI Beginner, .
thanks John -Power BI Beginner Melbourne
dh - Power BI Beginner, .
John was great to work with. Really enjoyed his style and patience with us. Thanks John! -Power BI Beginner Melbourne
David - Power BI Beginner, .
Good pace and engagement. Answered questions well. Friendly and pleasant. -Power BI Beginner Melbourne
John - Power BI Beginner, .
A thorough overview of analysis and dashboards and the intrinsic possibilities -Analysis & Dashboards Melbourne
LUMART - Analysis & Dashboards, .
Tim was very clear and easy to understand and took the time to understand what we did for our jobs and tried to then give useful examples as to how we could use these tools in our work. -Analysis & Dashboards Melbourne
Nicola - Analysis & Dashboards, .
Very insightful session into Power BI, will definitely come back for another level so I could leverage the tool for the business -Power BI Beginner Melbourne
Tham - Power BI Beginner, .
Good course -Analysis & Dashboards Melbourne
Lauren - Analysis & Dashboards, .

Trusted by Business

Procured by Government

Map of Australia