fbpx

Power Query Training Course Outline

Are you among those people who spend hours of their precious work time in cleaning the data and transforming it into the proper format? You are not alone. There are many professionals who spend their time for hours or sometimes even days to clean and transform their data so that they can bring data into the proper format to perform analysis on it. Do not worry Power Query Training Course is the solution to this problem which was prevalent for a long time and had become a pain in the life of analysts. You can boost your career with our Power Query Training Program and become an Excel Hero at the office.

ADVANCED EXCEL NINJA COURSE
• Course Certificate • Lifetime Access & Free Updates • Lifetime Support • Career Focused

 

All the professionals dealing with the data and spending hours on it should go for learning Power Query Training Course to automate their tasks.

Power Query helps in performing the following task like a cakewalk:

  • You can get or import the data from almost every source and combine it
  • You can cleanse and reshape or transform the raw data in your desired format
  • You can finally load this data into your reports or analyze it

To learn the course, it is very necessary to know the topics included in it. Or in other words, you should know the course outline. Let us discuss the Power Query Course along with its Course Outline in detail.

Power Query is the most important data preparation tool and is popularly known as the Get & Transform tool. Power Query Training Course helps you to learn the following things step by step:

  • Data Blending
  • Data Cleansing
  • Data Transformation
  • ETL (Extract, Transform and Load) Process

Power Query Training Course Outline

The Power Query Training Course is divided into 6 sections. The following is the flow of each section in detail:

ADVANCED EXCEL NINJA COURSE
• 200+ Video Tutorials • 80 Case Studies • 3 eBooks • 2 Webinar • 24*7 Dedicated Support

 

You can direct to a particular section by clicking on section name from below list:

Section 1: Getting Ready

This section prepares you to learn the Power Query Training Course. It clears or brushes up your basics regarding Power Query. This section involves the following topics:

  • Introduction to Power Query
  • A walkthrough to Power Query user interface
  • M-Query basics
  • Activating applied steps panel
  • List of M-Query commands
  • Process of importing data

Section 2: Data Preparation (Blending)

This section involves the first step of the data preparation process. The first step of data preparation involves in blending of data. It involves all the steps of blending the data. This section involves the following topics:

  • Combining and merging multiple files
  • Importing data from the web
  • Appending and merging of queries
  • Join and its types with a basic example
  • Do’s & Don’ts for merge queries
  • Merging queries with more than 1 ID column
  • Fuzzy Lookup

Section 3: Data Preparation (Cleaning)

This section performs the second step of Data Preparation. The second step of data preparation is the cleaning of data. This section involves the following topics:

  • Creating Headers
  • Cleaning the data by changing case, trim
  • Data type formatting
  • Removing duplicates, blank rows, fill down feature
  • Split Column by delimiter, position, digit, non-digit and split to rows
  • Formatting date
  • Adding a conditional column, merging columns
  • Replacing values and extracting characters

Section 4: Data Preparation (Re-Structuring)

This section performs the third step of Data Preparation. The third step of data preparation is restructuring. This section involves the following topics:

  • Comparison of cross tab and flat file, unpivot column
  • Basic to advanced group by
  • Pivot column
  • Transpose

Section 5: Data Preparation (ETL Project)

This section performs the final step of Data Preparation. The final step of data preparation is the ETL process. This section involves finding the top 3 analysts.

ADVANCED EXCEL NINJA COURSE
• Course Certificate • Lifetime Access & Free Updates • Lifetime Support • Career Focused

 

Section 6: Bonus Section

This section teaches you the bonus tricks related to Power Query. This section involves the following topics:

    • Copying data from Power Query tables
    • Column profiling and distribution
    • Duplicating and renaming queries

There is a sample case study file to download included in this course. You can download to practice on it. If you want to learn these cool Power Query Tips & Tricks to advanced your career then Join Our Power Query Training Program Today.