It was cool using the concepts of primary and foreign keys that we learned earlier in the semester in an Alteryx problem!
Smarty School.yxmd (1.6 KB)
This was a great challenge to remind me about third normal form! I also really liked learning those things about excel spreadsheets. Very helpful!
WeeklyChallengeX_Smartys_School_Supplies.yxzp (22.9 KB)
TechHubChallenge86.yxmd (22.3 KB)
The first part of the problem is pretty straightforward, although I personally think it’s easier to do in excel. The second part of the problem I needed extra help with, and ended up just following along with the video. Because of that, I just included my solution to the first part of the problem. Exporting all of the solutions to a single excel sheet is super interesting, and just takes some specific steps in the output. All in all a fun challenge!
Techhub1.yxmd (23.6 KB)
Pretty tough one, needed some help figuring it out
Cool challenge! Had some issues with part 2 but was able to figure out part 1! Relied on the video a bit for some guidance.
SmartysSchoolSuppliesPt.1.yxmd (23.0 KB)
1 Like
Wow, this one was definitely more challenging than the others I’ve done but what a good practice trying to configure all of these.
Smarty’sFile.yxmd (23.0 KB)
smarty.yxmd (23.4 KB)
This was challenging but it was great to learn new tools!
Smartys_School_Supplies.yxmd (29.1 KB)
This challenge was honestly fun to complete. It was nice seeing how simple data cleaning and sorting techniques can make these tables look professional.
I used lots of tools to get rid of null data, find only unique functions, and sort the data so it looks presentable.
1 Like
challenge86sol.yxmd (20.9 KB)
I’ll admit I was surprised to see the final output excel sheet working. Great challenge! It is rewarding to see the principles of 3NF we have learned come full circle in an applied manner.
FinalOutput.xlsx (6.8 KB)
WeeklyChallengeX_Smartys_School_Supplies.yxzp (23.6 KB)
Contanier.yxmd (22.6 KB)