Beginner Tutorial: Sales Data Analysis(EXCEL)

🔹 Introduction

In this tutorial, you will learn how to analyze the Superstore Sales dataset step-by-step using Microsoft Excel.
This guide is designed for beginners, so no prior experience is required.
By the end of this tutorial, you will understand how to clean data, perform basic analysis, and create simple visualizations.

🔹 Dataset Used

This tutorial uses the Super Store Sales Dataset provided in the Practice section.
You can download the dataset and follow along step-by-step.

🔹 Step 1: Open the Dataset

Download and open the dataset using Microsoft Excel.
Take a few minutes to observe the columns:
  • Order Id
  • Product Name
  • Product Id
  • Sales
  • Profit
  • Discount
  • Sub-Category
  • Category
  • Quantity
  • Segment
 

🔹 Step 2: Understand the Data

Each row represents a single sales transaction.
Try to understand what each column means before performing any analysis.
 

🔹 Step 3 Columns to Observe

  • Order ID → Unique identifier for each order
  • Order Date → Date the order was placed
  • Ship Date → Date the order was shipped
  • Category → Product category (e.g., Furniture, Technology)
  • Sub-Category → Specific product type
  • Sales → Amount generated from the sale
  • Quantity → Number of items sold
  • Discount → Discount applied to the order
  • Profit → Profit or loss made from the sale
 

🔹 IMPORTANT NOTE

Note: Each row represents a product within an order, not the entire order.
This means a single order can appear multiple times if multiple products were purchased.

🔹 Step 4: Clean the Data

Before analyzing any dataset, it is important to clean the data to ensure accuracy.
Follow these steps:
  1. Check for empty cells
      • Scroll through the dataset
      • Ensure there are no blank rows or missing values
  1. Ensure correct data types
      • Dates should be in date format
      • Numbers should not be stored as text
  1. Remove duplicates (if any)
      • Select your dataset
      • Go to Data → Remove Duplicates
  1. Check column headers
      • Make sure each column has a clear name
      • Avoid empty or unclear headings
      Cleaning data ensures that your analysis is accurate and reliable.
      Poor data quality leads to incorrect insights.

🔹 Step 4: Calculate Total Sales

In Excel:
  • Select the Sales column
  • Use the SUM function
This will give you the total Sales generated.

🔹 Step 4: Calculate Total Quantity

  1. Scroll to the bottom of the Quantity column
  1. Click on an empty cell below the numbers
  1. Type:
    =SUM(
  1. Now click and drag to select all the values in the Quantity column
  1. Type:
    )
  1. Press Enter

🔹 Explanation

The SUM function is used to add numbers together.
In this case, Excel adds all the revenue values to give you the total revenue.

🔹 Step 5: Find Top Products

  1. Click anywhere inside your dataset
  1. Go to the "Insert" tab at the top
  1. Click on "PivotTable"
  1. Click "OK"
  1. In the PivotTable panel:
      • Drag "Product" to Rows
      • Drag "Sales" to Values

🔹 Step 6: Analyze Category Performance

In the PivotTable panel:
  • Remove Product
  • Drag "Category" to Rows
  • Keep "Sales" in Values
This shows total revenue by category.

🔹 Step 7: Create a Chart

  1. Click on your PivotTable
  1. Go to "Insert"
  1. Select a Chart (e.g., Column Chart)
This will help you visualize your data.

🔹 Step 8: Generate Insights

Ask yourself:
  • Which product generates the most revenue?
  • Which category performs best?
  • What patterns do you notice?
Write down your findings.

🔹 Final Task

Using what you have learned:
  • Calculate total revenue generated
  • Identify top products
  • Analyze category performance
  • Create a simple chart
Then summarize your insights.