Challenge #427: Bookstore Sales Analysis

[AYXAcademy]

Hi Maveryx,

A solution to last week’s challenge can be found here.

This challenge was submitted by Ramesh Neelamana and has been modified to align with our learning objectives. Thank you, Ramesh, for contributing to this excellent challenge!

A bookstore wants to analyze book sales over a specified period to determine whether sales are increasing, decreasing, or remaining stable.

Your task is to investigate book sales for each 6-month period ending in March, April, and May of 2024. For example, when analyzing March, include the sales for March plus the preceding 5 months. The March 2024 analysis should include sales from October 1, 2023, to March 31, 2024, and similarly for April and May.

Calculate the total number of books sold for each analyzed period and identify the most popular book sold during that period.

For this task, you are provided with two datasets: one containing book sales data from 2021 to 2024, and the other containing the specific periods of time that require analysis.

Need a refresher? Review these lessons in Academy to gear up:

• Joining Data
• Writing Conditional Statements

Good luck!

[Flo_P]

My solution:

Spoiler

[Luke_C]

Spoiler

[nSpire]

Spoiler

 

[PhilipMannering]

Solution attached,

Spoiler

[mmontgomery]

c427

Spoiler

[Kenda]

Spoiler

[alexnajm]

Probably could've been done faster, but coffee needs to kick in ☕

Spoiler

[ahsanaali]

Spoiler

 

[alexgibson]

Spoiler

Fun solution. I tried two different ways of completing it as it's good to expanding my way of thinking.

Solution 2:

Spoiler