Investigating Data with Bar Graphs and Pivot Tables

/in /by

There are a couple of reasons for this video.
1. Often, to be good with data, the technical Excel tips & tricks aren’t necessary. Sometimes we have to think, probe and strategize.
2. This follows on my previous video that showed how graphing the data unlocked a mystery. Here again, is a true situation where it helped to make a pivot table and trow the data into a bar chart.

The video also uses Tables, and the WEEKNUM function to get to the bottom of the mystery.

For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
#WEEKNUM
#PivotTable
#ColumnChart

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2