Coffee Shop Sales Dataset preview Free

Coffee Shop Sales Dataset

Sales Beginner CSVXLSX
CategorySales
DifficultyBeginner
Rows149K (1,49,116)
Columns8
File Size5.5 MB
FormatsCSV, XLSX
LicenseFree for commercial & personal use
Downloads25,980+
Last Updated20 Jul 2026
CreatorDataVix

About this dataset

The Coffee Shop Sales Dataset contains transaction-level cafe sales across multiple stores: product, category, unit price, quantity, transaction time and store location. Small, clean and intuitive, it’s a perfect first project — analyse peak hours, best-selling products, store comparison and daily revenue trends in Excel or Power BI.

#coffee#retail#sales#time-analysis#beginner

Dataset Contents

The tables included in this dataset and what each one holds.

TableDescriptionRows
Transactions One row per item sold with time, store and amount. 149K
Products Product master with category and unit price. 80
Stores Store locations and opening details. 3

Columns Included

Key columns with their datatypes and meaning.

ColumnDatatypeDescription
transaction_id INT Unique transaction line id.
transaction_date DATE Date of sale.
transaction_time TIME Time of sale.
store_location VARCHAR Store the sale occurred at.
product_category VARCHAR Coffee, Tea, Bakery…
product_type VARCHAR Specific product.
unit_price DECIMAL Price per unit.
quantity INT Units sold in the line.

Skills You Can Practice

Excel Analysis
Power BI Dashboard
SQL Queries
Python Pandas
Data Cleaning
KPIs
Time Analysis
Sales Analysis
Store Comparison
Pivot Tables

Recommended Projects

01 Cafe Sales Dashboard
02 Peak Hours Analysis
03 Best Selling Products
04 Store Comparison Report
05 Daily Revenue Trend
06 Category Mix Analysis

Preview

Click any image to enlarge.

Related Datasets

Ecommerce Sales Dataset
IntermediateSales

Ecommerce Sales Dataset

Orders, customers, products, payments, shipping & returns from an online store — a full relational sales model.

 Superstore Retail Dataset
BeginnerRetail

Superstore Retail Dataset

The iconic Superstore orders with region, segment, category, sales and profit — perfect for a first dashboard.

 Netflix Movies & TV Shows
BeginnerMarketing

Netflix Movies & TV Shows

Full Netflix catalog: titles, genres, cast, countries, ratings and release years for content analytics.

Frequently Asked Questions

Is this dataset free to download?
Yes. Every dataset on DataVix is 100% free to download — no signup, no paywall, no hidden cost. Just click “Download Dataset”.
How do I download the files?
Click the green “Download Dataset” button. Your download starts instantly as a single package containing all included file formats (CSV, XLSX).
Can I use this dataset for commercial projects?
Free for commercial & personal use. You’re free to use it in your portfolio, client work, YouTube tutorials, blog posts and courses — attribution to DataVix is appreciated but not required.
Which tools does this dataset work with?
It’s ready for Excel, Power BI, SQL, Python. The CSV/XLSX files import directly into Excel, Power BI, Python (pandas) and any SQL database.
Is this real or synthetic data?
It’s realistic, analysis-ready practice data modelled on real-world business scenarios and cleaned for learning — safe to share publicly with no personal or confidential information.