Vizly: AI-powered data analysis

Try for yourself

Analysis of Total Sales by Category in the Dataset

Total sales by category?

Total Sales by Category

  • Furniture: $414,288.71
  • Office Supplies: $430,037.16
  • Technology: $498,095.00

Top selling products in each category?

Top Selling Products in Each Category

Here are the top-selling products in each category based on total sales:
  • Furniture: HON 5400 Series Task Chairs for Big and Tall ($11,846.56)
  • Office Supplies: GBC Ibimaster 500 Manual ProClick Binding System ($13,621.54)
  • Technology: Canon imageCLASS 2200 Advanced Copier ($61,599.82)
These products have the highest sales figures in their respective categories.

Profit analysis by region

Profit Analysis by Region

Here's the summary of profits by each region:
  • Central: $27,450.01
  • East: $53,372.16
  • South: $26,551.72
  • West: $67,860.56
The West region has the highest profit, followed by the East, Central, and South regions respectively.

Visualize profit distribution

We have successfully visualized the profit distribution by region using a bar chart. The chart displays the profit for each region, allowing for an easy comparison of profitability across different areas.

Explore sales trends over time

We analyzed the sales trends over time from the data provided. Here's a summary of what we learned:
  • We converted the 'Order Date' to a datetime format for accurate time series analysis.
  • We grouped the sales data by month and calculated the total sales for each month.
  • A line chart was created to visually represent the sales trends, showing fluctuations over the months across the years 2016 and 2017.

Visualize this for me

Continue the analysis

Further Analysis on Sales Trends

To continue the analysis, we can explore additional aspects such as seasonal trends, the impact of holidays on sales, or compare yearly performance. Let's dive deeper into these areas to gain more insights into the sales data.

Investigate seasonal sales trends

Seasonal Sales Trends Summary

  • Sales peak significantly in November and December, suggesting a strong holiday shopping season.
  • Another notable increase occurs in March, which might be influenced by end of fiscal year purchases or spring promotions.
  • The lowest sales are observed in February, indicating a potential slowdown after the holiday season.
This analysis helps in understanding the best and worst performing months, which can guide inventory and marketing strategies.
We'll analyze the sales trends over time by plotting them. This will help us see how sales have changed on a monthly basis over the years.

Explore product category sales distribution

Analyzing Product Category Sales Distribution

Next, let's explore the distribution of sales across different product categories to identify which categories contribute most to the revenue.

Summary of Product Category Sales Distribution

  • Technology leads in sales, contributing the highest to the revenue.
  • Office Supplies and Furniture also show significant contributions but are slightly lower than Technology.
  • The pie chart visually represents the distribution, making it clear how each category contributes to the overall sales.
We'll analyze the sales trends over time by plotting them. This will help us see how sales have changed on a monthly basis over the years.
To visualize the sales distribution across different product categories, we'll create a pie chart. This will help us see which categories contribute the most to overall sales.

Vizly

AI-powered data analysis

Try for yourself