Analytics

AIT10 Data Wrangler’s Magic Wand; Power Query in Excel or Power BI

12/04/2018

4:15pm - 5:30pm

Level: Introductory to Intermediate

Reza Rad

Author, Trainer, Speaker and Consultant

A data wrangling tool for a data scientist is like a wand for a wizard; it’s both magical and indispensable. In this session, you will learn some of the most common data wrangling and transformation use cases, using a variety of data sources. With Power Query as our data wrangling tool, we will look at scenarios combining data sets of different structure together, changing the granularity of the data, as well as changing rows to columns, and columns to rows. Come to this demo-filled session to learn how to transform your data into just the right format, so you can answer all of your data science questions.

You will learn:

  • How to transform different data scenarios into desired format for analytics
  • What format of data is not good, and what format of data it should change to
  • How to use a data transformation tool such as Power Query for data wrangling