Challenge #102: Tabulating Flu Data

[NicoleJohnson]

Took a similar approach to most, but added some visualizations to see some additional insights like @Claje, though I chose to practice my PowerBI this time instead of the reporting Alteryx tools...some cool insights, for sure! Interesting to see which years hit the elderly the hardest, or the 0-4 yr age group... and to see the spikes in certain months, definitely shows how volatile flu season can be. Future challenge idea perhaps - Would be really interesting to see this data with some spatial elements as well, to see when the flu hit certain parts of the country, where cases were most concentrated among certain age groups, etc.

Spoiler

PS. @PhilipMannering - I used RegEx in a Dynamic Rename tool to format the column names correctly... was just going to leave them but you inspired me to try cleaning it up a bit :)

Cheers,

NJ

[Claje]

Spoiler

Every time I see PowerBI/Tableau Visualizations I'm reminded that I should really just use them more often :)

That is a much prettier (and more effective) take on some of the information I was trying to investigate.

[gnans19]

Attached solution. Simillar to others.

[ggruccio]

Added a time series to the analysis, which brought up a few interesting puzzles: 

     1. What to do with years that have a 53rd week.

     2. What to do about missing observations (off-season).

[badiualex]

First weekly challenge for me. :) Easy pie

[kixe80]

Le voici

[dominiklz]

Spoiler

quick one this week

[AndyBate]

Done. :)

[kat]

Easy one this week :)

Spoiler

[nwhaley]

First Challenge! 

Spoiler