New Workflow4.yxmd (12.0 KB)
Here is my solution!
1 Like
This was a great challenge! Loved practicing with the tools.
Homework 11.3 Pt. 2.yxmd (12.7 KB)
This one was great to see the power of Alteryx. Doing this with excel or SQL would have been way more difficult.
1 Like
After attempting this on Excel it was interesting to apply it to Alteryx. Fun challenge and good application to help me think a little different. Thanks for the challenge
ChickenCallenge1.yxmd (18.0 KB)
Providing free drinks increased net income but some customers definitely took advantage of it.
New Workflow3.yxmd (13.7 KB)
Challenge2Workflow.yxmd (12.4 KB)
Here is my solution. It looks like offering free drinks was slightly more profitable! It seems the mini fridge strategy was effective, but not by much. This needs some more looking in to to be sure. I would like Tom to gather more detailed data going forward (like what brands of drinks are most popular, seasonal changes in sales, etc).
This was a good challenge. I was able to filter the data based on whether the free drinks column contained a null value. After filtering, I used some basic mathematical formulas to calculate revenue, expenses and net income. I used a summarize tool to solve aggregate the data and unioned the two tables together for a comprehensive view of the net income.
1 Like
I ended up doing this two different ways since the first way didn’t turn out as organized as I wanted. Here are both my solutions. Overall the free drinks are working. Others have said limiting customers to just one drink would create a larger profit margin and I would agree.
1 Like
Tom should keep the fridge! I really liked the idea of adding the tables back together to view both years at the same time. While I could have found the answer with separate ones (which I did initially) I enjoyed the extra practice with a simple join and union.
LittleChickenCase.yxmd (17.1 KB)
1 Like
This challenge required some creativity. After looking at everybody else’s solution, it’s clear that Alteryx is just like any other program, there is no one right way of solving a problem. I had some trouble with the Union but then I realized you can join based on position, not just column name. It’s too bad I figured it out after I changed it so it worked.
LittleChicken.yxmd (15.1 KB)
Fun challenge! Thanks for providing instruction about the multi-field formula - I wouldn’t have got that otherwise
I tried to optimize having the fewest operations possible, you might be able to do this in less but I couldn’t think of another way.
Was fun!
2 Likes
