Data Analytics Using Excel Project
Report
Ajeenkya DY Patil University
Student: Roshan Rathod
Roll No.: B25B020212
Course: BBA IB
Semester: 1
Objective
To analyze a sales dataset using Microsoft Excel by cleaning data, applying formulas,
creating Pivot Tables and charts, and performing statistical analysis.
Dataset Description
Dataset contains 100 sales records with columns: Order ID, Product Name, Category,
Region, Sales Amount, Quantity, and Order Date.
Data Cleaning
Removed duplicate records, checked missing values, sorted Sales Amount in
descending order, filtered sales above ₹1000, and created a Category drop-down list
using Data Validation.
Excel Functions Used
SUM, AVERAGE, MAX, MIN, IF, and VLOOKUP/INDEX-MATCH (if lookup table is
available).
Pivot Tables
Category-wise total sales and Region-wise average sales were created using Pivot
Tables.
Charts
Prepared Column Chart (Sales by Category), Pie Chart (Sales Distribution), and Line
Chart (Monthly Sales Trend).
Statistical Analysis
Calculated Mean, Median, Mode, and Standard Deviation for Sales Amount to
understand the distribution and variability of sales.
Observations
Electronics generated the highest sales. North region showed strong average sales.
High-value sales contributed significantly to total revenue.
Conclusion
Microsoft Excel is an effective tool for cleaning, analyzing, visualizing, and
summarizing sales data for business decision-making.