Omid - Challenge 17

data-challenges
advanced-exercises
🔰 A B Question: Sales Data Date Product Quantity Challenge 17
Published

March 24, 2026

Illustration for Omid - Challenge 17

Challenge Description

🔰 A B Question: Sales Data Date Product Quantity Challenge 17

Solutions

CH-017
Puzzle was about visualizing data and this is kind of puzzles I will skip. 
In case of data transformation, we are proving that we can achieve something in several tools.
However graphical capabilities are IMHO not comparable.
Thanks.

  • Logic:

    • Applies the workbook rule directly and returns the expected output shape

  • Strengths:

    • The R solution stays close to the workbook rule and keeps the transformation compact.

  • Areas for Improvement:

    • The code assumes the sheet structure and source ranges remain stable.

  • Gem:

    • The strongest part of the solution is choosing the right intermediate representation before shaping the final output.

No Python file is included for this challenge because the original task is non-analytical and was explicitly described in the source as visibility/dashboard work rather than a data-transformation puzzle.

  • Logic:

    • The source material itself treats this challenge as outside the scope of a meaningful analytical code translation.

  • Strengths:

    • Avoids forcing an artificial Python solution where the task is primarily visual or interface-driven.

  • Areas for Improvement:

    • If the business rule is later formalized into data logic, a real Python solution can be added.

  • Gem:

    • This is one of the rare cases where the correct engineering choice is to not pretend the problem is a standard dataframe transformation.

Difficulty Level

This task is moderate:

  • The business rule is readable, but the workbook still requires careful implementation to reach the expected layout.