Introduction to Power Query Training

Key Points

  • Power Query is a FREE add-in to Excel 2010 and in-built functionality from Excel 2016
  • Power Query automates the extraction, clean up and integration of your data
  • It is often used to automate routine reporting
  • CMBI provides training on Power Pivot, Power Query and Power BI

Power Query is an ETL tool that allows end users to pull data from a variety of sources, perform complex transformations on the data, then load it into a workbook - all whilst remaining completely within the Excel environment. CMBI's Power Query training will turn Excel gurus into advanced data analysis gurus!

About CMBI

What is Excel Power Query?

Do you work with data that has been extracted from a variety of systems, and then spend hours transforming that data so it can be used in reporting? If so, then Power Query is for you.

Power Query is Excel's ETL tool that allows end users to automate the process of importing data from multiple sources, and then perform routine, yet complex, transformations on the data so that it is ready to be used in Excel pivot tables, charts and other reporting solutions. All without the need for VBA, macros or any other coding!

CMBI's "Introduction to Power Query" training course will show you how to automate your reporting, solely within the Excel environment.

 

 

Course Details

CMBI's "Introduction to Power Query" training course will quickly get analysts, accountants and other business professionals up to speed with this great tool. The content is a mixture of technical knowledge transfer as well as practical advice on how you can get the best out of Power Query for your organisation.

 

Duration: 1 day

Cost: $1,440 + GST per training session hosted at your venue

Number of Attendees: to ensure each person gets the required level of support during the workshop we recommend a maximum of 6 attendees.

Prerequisites: To get the most out of this course, we recommend that attendees to this course are proficient in Excel, and familiar with the more advanced Excel concepts such as PivotTables and functions such as SUM, IIF and VLOOKUP.

If you are not sure if this is the right course for you, just email us and we'll be happy to advise.

 

Course Outline

CMBI's "Introduction to Power Query" training course covers the following topics:

Introduction to Power Query

  • What is Power Query, and when to use it?
  • Overview of the Power Query interface
  • Importing Data

  • Importing data into Power Query using a variety of methods, including Excel, flat files, databases and webpages
  • In-built transformations
  • Transforming your data in Power Query

  • Changing data types
  • Adding custom columns
  • Joining data together from different sources
  • Grouping data
  • Adding parameters to your queries
  • Building custom functions with "M"
  • Using your data

  • Loading your data into an Excel workbook or the Internal Data Model
  • Refreshing your data
  • Editing your queries
  • Making queries work together
  •  

    Why Choose CMBI?

    Why should you choose CMBI for your next training solution?

    • Trainers with hands-on, real world experience
    • Real datasets from an array of education, financial services and government sources
    • Small groups for one-to-one mentoring
    • Instructional videos to take away for future reference
    • Options to tailor the training session to your organisation
    Click here for more training benefits CMBI can offer you and your organisation.

     

    Contact Us

    For more information or to book a training course, email Julie McGowan or contact CMBI via our contact page.

     

    See Also