2|ALTERYX – Little Chicken

[Madison_Jones]

Here’s my solution!

ChickenWorkflow.yxmd (15.1 KB)

[Ken_Wesemann]

I think this works!

[Aaron_Gill]

Great challenge! I think that the free drink policy was effective, however it would be good to limit drinks to 1 per customer or something of the sort to manage expenses a little better.

[Michael_Ebert]

I really liked this challenge! I used the same data set in an excel challenge and it’s interesting seeing the limits and capabilities of different programs using the same data set.

[Faith_Call]

This was a fun challenge to see what I could remember about alteyx!

[Sydni_Hales]

Great challenge! It seems that the drinks increase overall profitability, but decrease profit margin. Continuing to offer the drinks will likely increase Tom’s income.

LittleChickenSolution.yxmd (13.0 KB)

[Sierra_Monja]

Here is my answer! The free drinks seem to be working! It’s possible that a limit to the free drinks could boost net income even more, but he definitely is earning more offering free drinks than he did before!
TechHubChallenge_LittleChicken.yxmd (15.2 KB)

[Madeline_Westover]

407 - TechHub Training Challenge #3.yxmd (13.7 KB)

I tried this one originally with a filter for drinks given being null, but I decided that data cleansing is a better option since it allows null values to be replaced with zeros. I thought it made more sense when calculating the net income. Thanks for the challenge!

[Aubrey_Parkinson]

This was a fun, simple challenge, I love how creative people got with their answers
TechHubChallenge#2.yxmd (12.7 KB)

[Kyle_Parkinson]

After splitting up the data into before and after the drinking era, I relied on the formula tool to both calculate relevant data and group by whether free drinks were in play or not. Good practice!
LilChicken.yxmd (13.0 KB)

[Ryan_OReilly]

Fun challenge to do with alteryx! The profits did increase with the free sodas but they were very insignificant compared to the revenue increase. If Tom bought the sodas in bulk he could find a better deal than $1.59/bottle and his profits would skyrocket like his revenues did.

LittleChicken.yxmd (12.6 KB)

[Ryan_Hickman]

Alteryx 2 - Solution.yxmd (13.7 KB)

Pretty fun case to do side-by-side comparisons with a union tool! I wonder if he should maybe stock the fridge with a cheaper soda brand? Free soda is free soda–I’m not very picky about flavor when it’s free.

[Garrett_Jones]

Good practice!

[Megan_Arnold]

Here is my solution to this challenge.

MeganArnoldLittleChicken.yxmd (14.0 KB)

[Spencer_Forsberg]

This was a fun, quick challenge. It is cool to see Alteryx in a real world scenario.

[Kacy_Paul]

I did mine a little differently and didn’t divide out the isnull drink population until later. my format at the end wasn’t as neat to compare profitability.

[Carter_Ringger]

Couldn’t quite figure out all of the rounding/formatting specifics. Here is my solution:

[Kassidy_Robinson]

Here is my solution. I saw that net income did not vary greatly between the periods before and after the mini fridge was being used. That means that if Tom decided to limit the customers to one or two free drinks he might be able to see a rise in profitability for future periods.
LittleChicken.yxmd (13.4 KB)

[Jenna_Sofoul]

Here is my solution! I would recommend limiting the amount of free drinks Tom gives to his customers. Maybe one free drink per customer?

New Workflow2.yxmd (12.7 KB)

[Dillon_Atkinson]

New Workflow8.yxmd (12.7 KB)