Sales analysis

I need a detailed sales analysis for our e-commerce in Excel. The database contains the following columns: Sale Date, Product, Category, Unit Price, Quantity Sold, Total Revenue, Region, and Payment Method. Please apply the following analyses:**

  1. Monthly summary: Generate a monthly sales chart totaling the Total Revenue for each month.
  2. Analysis by product category: Create a pivot table showing Total Revenue and Quantity Sold by Category.
  3. Top 10 products: Generate a list of the top 10 best-selling products (by quantity) and their corresponding Total Revenue.
  4. Regional analysis: Display a pie chart showing the percentage of Total Revenue by Region.
  5. Most used payment method: Show the percentage of each Payment Method used in total sales.
  6. Price trends: Perform an analysis to check if there is a correlation between Unit Price and Quantity Sold, applying a correlation formula.
  7. Sales forecast: Use the Excel trend forecast function to estimate sales growth for the next three months based on historical data.

Rating: 1 out of 5.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *