Analyzing Monthly Sales
Now that we’ve explored our ice cream data, let’s turn our attention to the monthly sales data. We’ll answer several questions about sales performance across regions, flavors, and time periods.
10. Which region had the highest sales?
Exercise 4.1: Highest Sales by Region
Let’s calculate the total sales for each region and find the one with the highest sales:
11. Which ice cream flavor had the highest sales?
Exercise 4.2: Highest Sales by Flavor
Now, let’s find out which ice cream flavor had the highest total sales:
12. Which month had the highest sales?
Exercise 4.3: Highest Sales by Month
Let’s determine which month had the highest total sales:
These exercises have given us valuable insights into our sales data. In the next section, we’ll create some visualizations to better understand these sales patterns.