From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge

Unlock this course with a free trial

Join today to access over 25,400 courses taught by industry experts.

Unpivoting data from existing reports

Unpivoting data from existing reports

From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge

Start my 1-month free trial Buy for my team

Unpivoting data from existing reports

“

- [Instructor] One of the biggest challenges we face as data analysts is the inability to get to all of the raw data that we need. Source systems will sometimes limit you to the pre-built reports that are exported to PDF or Excel. These reports are canned reports and they're generated by the system internally. These canned reports can be valuable but we want to extend what we can do with them and other visualizations. We really need them to function more as records than pivot displays. In our research team, we often refer to this format as the wide format. Again, there are limitations in the visuals if you leave your data in the wide format. One of the key cleaning commands of power query is unpivot. Power query gives us the ability to take wide displays and create long displays that act as records. We unpivot them giving us a valuable record set to work with. Unpivot exists in power query for any dataset and you can unpivot Excel data or even PDFs. Let's go ahead and get started and…

Contents