Weekly Challenges

ChristineB · ‎01-29-2018

A solution to last week's Challenge has been posted HERE!

This year's (2017-2018) flu season has been reported to be the most severe in the past decade. In particular, influenza-related hospitalizations are on the rise across a wider range of age groups than normal. For this week's Challenge, we'll use data from the Center for Disease Control (CDC) concerning California's data on influenza-related hospitalizations. Create a table that shows the cumulative number of hospitalizations per age group for each flu season.

Looking for additional analyses to do? How about a week-by-week comparison of hospitalizations? Or perhaps a forecast of the number of expected hospitalizations for a particular age group? Or maybe a visual representation of the data is up your alley!

Stay healthy out there!

kcgreen · ‎01-29-2018

Done!

Spoiler

David-Carnes · ‎01-29-2018

Simple enough to do during my lunch break. (I took a break from working in Alteryx to ...... work in Alteryx.)

Spoiler

Claje · ‎01-29-2018

Spoiler

This one was simple enough to do that I did some charting for the sake of refreshing my memory on how charting works in Alteryx. I took the top 12 weeks by average cases for each age category and charted them.

More difficult than I thought it would be, but I got some neat stuff even without using a Visualization tool like Tableau. EG: Based on this dataset, "Flu Season" is really two seasons, depending on age. For infants and adults over age 50 it is the "expected" weeks 51-9, roughly December-February. However, in the 5-17 and 18-49 demographics, they tend to get hit much earlier on average, with weeks 36-39 showing up in the top 12, but then there is a lull until ~January. Obviously, given the limitations of this dataset, these findings don't mean anything, but I thought it was neat to see. Particularly, I don't think of the month of September as a flu season.

This one was simple enough to do that I did some charting for the sake of refreshing my memory on how charting works in Alteryx. I took the top 12 weeks by average cases for each age category and charted them.More difficult than I thought it would be, but I got some neat stuff even without using a Visualization tool like Tableau. EG: Based on this dataset, "Flu Season" is really two seasons, depending on age. For infants and adults over age 50 it is the "expected" weeks 51-9, roughly December-February. However, in the 5-17 and 18-49 demographics, they tend to get hit much earlier on average, with weeks 36-39 showing up in the top 12, but then there is a lull until ~January. Obviously, given the limitations of this dataset, these findings don't mean anything, but I thought it was neat to see. Particularly, I don't think of the month of September as a flu season.

patrick_digan · ‎01-30-2018

Spoiler

Claje · ‎01-30-2018

Spoiler

You know, in all the filters I've ever written in Alteryx, I never tried IN (NULL()). That's a really good thing to remember and probably simplifies some of my formulas.