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:


  


  
  

  
  

    
    
  


  
  


  
  
Mission Status: Started