Webinar: Data Mining in Excel - Pivot Tables, Power Query, and Power Pivot | Everyday Office
As part of the webinar series Insights with Knack Training, Neil Malek recorded the following hour-long session using Microsoft Excel to experiment with data mining techniques. During the data mining process, we must compile and clean useful data; then categorize that data; then analyze and visualize it. We used Pivot Tables, Power Query, and Power Pivot tools and techniques to accomplish these tasks.
0:00 Introduction
10:54 Pivot Tables
21:46 Grouping
26:54 Drilling into Data
30:36 Power Query
45:45 Power Pivot
Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orlando, FL. More content can be found on:
http://www.knacktraining.com/blog/
http://www.knacktraining.com/podcast/
Check the playlists on the Everyday Office channel for more tutorials in the areas you are having the most trouble with.