Real-World Excel Data Analytics Project
Work like a data analyst: understand sales data, calculate business metrics, investigate patterns, summarize performance and communicate evidence-based findings.
Lesson progress
Complete the activity and related MCQ to unlock the next concept.
Your role
You Are the Data Analyst
An electronics company has provided sales transactions. Management wants to understand revenue performance across products, regions and salespeople. Your job is to analyze the evidence—not to guess or make unsupported personal judgments.
Dataset
Sales Transactions
Assume this table is stored in an Excel worksheet named SalesData. Column order is A:H as shown below.
| Order ID | Region | Product | Salesperson | Units (E) | Price (F) | Cost/Unit (G) | Revenue (H) |
|---|---|---|---|---|---|---|---|
| O1001 | North | Laptop | Amit | 5 | ₹50,000 | ₹40,000 | ₹2,50,000 |
| O1002 | South | Monitor | Neha | 8 | ₹15,000 | ₹11,000 | ₹1,20,000 |
| O1003 | East | Laptop | Rahul | 3 | ₹50,000 | ₹40,000 | ₹1,50,000 |
| O1004 | West | Keyboard | Priya | 20 | ₹2,000 | ₹1,200 | ₹40,000 |
| O1005 | North | Monitor | Karan | 10 | ₹15,000 | ₹11,000 | ₹1,50,000 |
| O1006 | South | Laptop | Sonia | 4 | ₹50,000 | ₹40,000 | ₹2,00,000 |
| O1007 | East | Mouse | Vikas | 25 | ₹1,000 | ₹600 | ₹25,000 |
| O1008 | West | Laptop | Riya | 2 | ₹50,000 | ₹40,000 | ₹1,00,000 |
Formula alignment note: Revenue uses Units in column E × Price in column F. Profit uses Revenue in H − (Units in E × Cost/Unit in G).
01 · UNDERSTAND THE DATA
Start With the Raw Dataset
A real analyst begins by understanding what each column represents before calculating anything. The same dataset structure is used throughout this capstone.
Visual / worked example
Read the fields before the figures
Analyst's checkpoint
Use only what the displayed data supports. If a result looks unusual, investigate it before drawing a conclusion.
Interactive activity
Dataset literacy