MISSION: Complex Sales Analysis

Business Scenario:

Imagine you are a data analyst working for a multinational retail company. The provided sales data represents monthly sales for various products across different regions.

Task Clarifications:

  1. Calculate the total sales for each product across all months.
  2. Identify the product with the highest total sales.
  3. Calculate the average monthly sales for each product.(rounded to 2 digits after the decimal point).
  4. Generate a comprehensive report with the results.

Output Format:

  Total Sales for product1: [calculated_value1]
  Total Sales for product2: [calculated_value2]
  Total Sales for product3: [calculated_value3]
  
  Product with the Highest Sales: [product_with_highest_sales]
  
  Average Monthly Sales:
  - product1: [average_value1]
  - product2: [average_value2]
  - product3: [average_value3]
Mission Status: Started