Power Query 101: Import, Clean & Transform Your Big Data

Summary

In this 90-minute, highly interactive instructor-led training, you will learn how to transform big data much more efficiently.  Discover how to import data into Excel from a variety of sources and automate the data cleaning process - with a click of the button!

Gain must-have skills for working with imported data and join us for this hands-on training to discover:

  • How to navigate the UI: Master the Power Query Editor
  • Simple solutions for automating the data cleansing process
  • 2 simple steps for repeating the data import & cleansing process
  • The “power” of Power Query: Import & manage large datasets with ease

Why You Should Attend

We’ll cover the following & more!

  • Import data into Excel from sources such as text files, web pages and databases
  • Avoid Excel’s "million-row limitation"
  • Keep the imported data in sync with the source data using just two clicks
  • Using the Power Query Editor to Create data transformation actions
  • Managing actions in the Power Query Editor
  • No-code Query creation
  • Unpivot – the hidden gem of the Power Query Editor
  • Calculations without formulas – the power of The Query Editor Ribbon
  • Save a ton of time - automate the data cleaning process

Additional tools:

  • Your questions & specific use-cases will be addressed in real-time, all throughout the workshop
  • A 15-minute question & answer, plus wrap-up & review session

Program Benefits

If you work with, analyze, and generate reports from large datasets, having a good understanding and working knowledge of Power Query is a must! In this workshop, you’ll discover how to transform big data more efficiently, with fast, plus powerful data gathering and cleansing capabilities.

If you'd like this program customized for your organization, call us at 1-800-964-6033.
We're certain we can fulfill your training needs, while making it fit in your budget!

About The Speaker

Mike Thomas

"Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. Mike has produced nearly 200 written and video-based Excel tutorials, and... hundreds of courses and webinars on a wide variety of technology-related topics. Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes."