Choosing the optimal combination

I used Pandas to choose the combination of treats. The function I wrote utilizes the brute force method* to check every possible combination of three treats and ensures that all the properties are present within it at least once. This operation results in more than one potentially winning combination - to choose one of them I considered three scenarios:

• a combination with the best overall winning percentage,
• a combination with the lowest possible sugar percentage,
• a combination with the lowest possible price percentage.

This approach helps to choose not only from the most popular sweets, but also considers lowering the sugar intake and maximizing cost-effectiveness.

Having these combinations chosen, I exported the data to visualize them in Power BI.

• For larger datasets it could become too slow, but in case of such a small dataset it worked very well.

Visualizing the data

After selecting three combinations of three treats each I ended up with a rather small dataset that did not offer much potential for data visualization. Given the light-hearted theme of this project I took an unusual approach, adding a short story and creating a visual narrative that incorporates some decision-making. I'm sure the idea can be developed further to create a data-driven adventure game inside Power BI!

Note: the background pictures are AI-generated using Bing Image Generator. All other elements - the idea, the story, the execution, are entirely my work.