Power Query For Data Transformation

COURSE OVERVIEW

Information is all around us. You can put it to use by learning SQL basics. Used in data science, analytics, and engineering, SQL makes it easy to work with data and make more informed strategy, operations, and business decisions. It’s a helpful skill for anyone who works with data (even in non-tech roles). In this SQL course, you’ll learn how to manage large datasets and analyze real data.

Who Will Benefit

  • Accounting professionals
  • Technology employees
  • Leaders and executives
  • Technology managers
  • Anyone with responsibilities in finance
  • Policy administrators
  • IT staff
  • CPAs interested in the CITP credential

Learning Outcomes

  • Use Power Query to solve your data clean-up issues.
  • Determine how Power Query allows you to get more data into Excel.
  • Apply a one-click step to refresh your data.

Key Topics

  • File maintenance
  • Custom columns
  • Un-pivoting a table

WHAT YOU WILL GET AFTER COMPLETION THE SERIES OF WEBINAR

  • Recorded Lectures
  • Practice Files
  • Notes