Retail Sales Dataset Practice

🔹 Dataset Overview

This dataset contains 300 records of retail sales transactions designed for beginners to practice real-world data analysis.
It includes product, category, pricing, and revenue data, making it suitable for exploring business performance and trends.
 

🔹 Dataset Source

Source: Created for learning purposes
This dataset is designed to simulate real-world real estate data for analysis practice.
 

🔹 Learning Objectives

By working with this dataset, you will learn how to:
  • Calculate total revenue and total sales
  • Analyze product and category performance
  • Identify sales trends over time
  • Perform basic data cleaning and preparation
  • Build simple dashboards to visualize insights
  • Interpret data to support business decision-making
 

🔹 Tools You Can Use

You can analyze this dataset using:
  • Microsoft Excel (for beginners)
  • Power BI (for dashboards and visualization)
  • Google Sheets (for quick analysis)
  • SQL (for advanced querying and filtering)
 

🔹 Download Dataset

 

🔹 Practice Tasks

Try the following tasks:
  1. Calculate the total revenue generated
  1. Identify the top 5 best-performing products
  1. Determine which category generates the highest revenue
  1. Analyze sales trends by date
  1. Find the day with the highest total sales
  1. Calculate average revenue per transaction
  1. Create a summary table showing category performance
  1. Build a simple dashboard to visualize your findings
 

🔹 Challenge

Using this dataset, build a dashboard that:
  • Shows total revenue and sales trends over time
  • Highlights top-performing products and categories
  • Identifies patterns or trends in sales
  • Provides at least 3 key business insights
  • Includes 2–3 actionable recommendations for improving sales performance