Sales Analysis: Top Products, Categories, and Regions

Jun 24, 2025, 7:23 PM

final data proj.xlsx

Missing file

Using the Final data attached which is Part 2, I need to create a 20-slide PPT addressing the following Part 3.

Part 3 - Data Analysis Report (in MS PowerPoint)
Prepare a Power Point presentation (in MS PowerPoint) based on the data and your analysis in
Excel file.
• Title slide with the Title, your full name, and Date
• The 2nd slide should contain the executive summary of the report (no more than 120
words).
• The content slides should contain visuals, charts, graphs, tables, and any verbiage to
assist in demonstrating a full data analysis.
 Present separately in 2018, 2019 and the comparison between 2018 & 2019 on:
• Monthly Sales Overview
• Top 10 Customers
• Top 10 Products
• 8 Product Categories
• Top 10 Regions
• The final slide(s) should contain your recommendations/suggestions based on the data
analysis
It seems there was an error while trying to read the Excel file. Let's try loading the file again using a different method to handle the encoding issue. I'll attempt to load the file using pandas with the openpyxl engine for Excel files.
The data has been successfully loaded. Now, let's proceed to create a PowerPoint presentation based on the data analysis requirements you provided. We'll address each point step-by-step:
  1. Title Slide: This will include the title, your full name, and the date.
  2. Executive Summary: A brief summary of the report.
  3. Content Slides: These will include visuals, charts, graphs, and tables for:
    • Monthly Sales Overview for 2018 and 2019
    • Top 10 Customers
    • Top 10 Products
    • 8 Product Categories
    • Top 10 Regions
  4. Final Slide: Recommendations and suggestions based on the data analysis.
Let's start by preparing the data for analysis and visualization.
The Monthly Sales Overview for 2018 and 2019 has been visualized in the bar charts above. Each chart represents the total sales for each month within the respective year.
Next, we will analyze and visualize the following:
  • Top 10 Customers
  • Top 10 Products
  • 8 Product Categories
  • Top 10 Regions
Let's proceed with these analyses.
The Top 10 Customers by total order price have been visualized in the bar chart above. This chart highlights the customers who have contributed the most to the total sales.
Next, let's analyze and visualize the Top 10 Products based on their sales.
The Top 10 Products by total order price have been visualized in the bar chart above. This chart shows the products that have generated the highest sales.
Next, let's analyze and visualize the 8 Product Categories based on their sales.
The Product Categories by total order price have been visualized in the pie chart above. This chart provides a breakdown of sales across different product categories.
Finally, let's analyze and visualize the Top 10 Regions based on their sales.

What are your recommendations based on this data?

Based on the data analysis and visualizations, here are some recommendations:
  1. Focus on Top Customers: The top 10 customers contribute significantly to the total sales. Consider offering them loyalty programs or exclusive deals to maintain and increase their engagement.
  2. Promote Best-Selling Products: The top 10 products have generated the highest sales. Focus marketing efforts on these products and explore opportunities to expand their market reach.
  3. Diversify Product Categories: While some product categories are performing well, there may be opportunities to diversify and introduce new products in underperforming categories to capture a broader market.
  4. Regional Sales Strategy: Analyze the top-performing regions and tailor marketing strategies to leverage regional strengths. Consider expanding operations or increasing marketing efforts in regions with high sales potential.
  5. Seasonal Promotions: The monthly sales overview indicates potential seasonal trends. Consider implementing targeted promotions during peak sales months to maximize revenue.
These recommendations aim to enhance sales performance and customer satisfaction based on the insights derived from the data.

Provide [LINE CHART: 2018 Monthly Sales Trends] and [LINE CHART: 2019 Monthly Sales Trends]

Get started with Vizly