Excel Dataset Showcase

Explore the raw and cleaned versions of the sales dataset used in this project.

Raw Dataset

Raw Dataset Preview

Initial unprocessed version

Cleaned Dataset

Cleaned Dataset Preview

Ready for analysis

About This Dataset

This dataset captures detailed retail transactions including customer demographics, product preferences, and purchase behaviors. It enables in-depth analysis of sales trends and customer insights.

  • 🧑‍💼 Customer Details: ID, Name, Email, Phone, Address, City, State, Zip, Country
  • 📊 Demographics: Age, Gender, Income, Customer Segment
  • 📅 Transactions: Last Purchase Date, Total Purchases, Amount Spent
  • 📦 Product Information: Category, Brand, Type
  • 💬 Customer Feedback, 🚚 Shipping & 💳 Payment Method, 🏷️ Order Status

The raw dataset was cleaned using Excel and Python:

  • Removal of missing or duplicate records
  • Standardization of formats (e.g., dates, currency)
  • Correction of typos and inconsistent values
  • Structured transformation for analysis readiness
Back to Home