Made a quick viz showing some of the data re: the Ohio State vs Michigan rivalry. I’d like to make another draft with updated formatting and some BANs etc.
https://public.tableau.com/profile/jpkeeton#!/vizhome/OhioStatevMichiganFootball/OSUvMichigan
Describing the process, I copied the data from Wikipedia into Google Sheets. I then split, trimmed and used some Regexreplace to get the data in shape. Then, I linked Tableau to the Google sheet and just started exploring before I found a few views I wanted to keep.
The final step was gathering the hex codes and logos to add in addition to a lot of general formatting.
My goal was to post something before tomorrow’s game. Some things I might include next time are more complex and hopefully informative vizzes.
#GoBucks!
JeremyPK 