**These datasets are for educational purposes only. All generated data is fictional and has no real-world validity.
Contains details about sales transactions, including product, quantity, revenue, and payment method.
| Order ID | Product | Category | Quantity Sold | Revenue ($) | Discount (%) | Salesperson | Region | Date of Sale | Payment Method |
|---|---|---|---|---|---|---|---|---|---|
| ORD1023 | Bluetooth Speaker | Electronics | 3 | 149.97 | 10 | Jane Cooper | West | 2025-03-15 | Credit Card |
Contains details about employees, including department, position, salary, and performance rating.
| Employee ID | Name | Age | Gender | Department | Position | Salary ($) | Hire Date | Performance Rating |
|---|---|---|---|---|---|---|---|---|
| EMP567 | Michael Scott | 45 | Male | Sales | Regional Manager | 75000 | 2015-04-01 | 4.2 |
Contains details about products, including stock availability, pricing, and supplier details.
| Product ID | Product Name | Category | Stock | Price ($) | Supplier | Launch Date | Rating (out of 5) |
|---|---|---|---|---|---|---|---|
| PRD9988 | Smart LED TV | Electronics | 80 | 499.99 | VisionTech | 2024-11-20 | 4.7 |
Contains details about inventory levels, reorder thresholds, and warehouse locations.
| Inventory ID | Product | Category | Quantity Available | Reorder Level | Location | Last Restocked | Stock Value ($) |
|---|---|---|---|---|---|---|---|
| INV345 | Office Chair | Furniture | 120 | 50 | Warehouse B | 2025-03-01 | 9600.00 |
Contains details about customers, including purchase history, total spend, and preferred payment methods.
| Customer ID | Name | Age | Gender | Phone Number | Purchase History (count) | Average Purchase Amount ($) | Total Spend ($) | Region | Preferred Payment Method | |
|---|---|---|---|---|---|---|---|---|---|---|
| CUST2001 | Emily Clark | 34 | Female | emily.clark@email.com | +1-202-555-0147 | 15 | 75.20 | 1128.00 | North | PayPal |
Contains details about marketing campaigns, including budget, target audience, and platform.
| Campaign ID | Campaign Name | Start Date | End Date | Budget | Target Audience | Platform | Conversions | ROI (%) |
|---|---|---|---|---|---|---|---|---|
| CAM987 | Spring Promo 2025 | 2025-03-01 | 2025-03-31 | 10000 | 18–35 Urban | 450 | 32.5 |
Contains details about shipments, including carrier, origin, destination, and delivery status.
| Shipment ID | Carrier | Origin | Destination | Shipment Date | Delivery Date | Weight (kg) | Cost ($) | Status |
|---|---|---|---|---|---|---|---|---|
| SHP1029 | FedEx | New York | Los Angeles | 2025-03-20 | 2025-03-25 | 18.5 | 72.50 | Delivered |
Contains details about financial transactions, including account numbers, transaction types, and amounts.
| Transaction ID | Account Number | Transaction Date | Transaction Type | Amount ($) | Currency | Status | Merchant |
|---|---|---|---|---|---|---|---|
| TXN8890 | AC234908 | 2025-04-01 | Purchase | 250.00 | USD | Completed | Amazon |
Contains details about employee attendance, including check-in and check-out times.
| Employee ID | Employee Name | Date | Check-In Time | Check-Out Time | Hours Worked | Department | Work Location |
|---|---|---|---|---|---|---|---|
| EMP1203 | Angela Martin | 2025-04-06 | 09:00 | 17:30 | 8.5 | Accounting | HQ |
Contains customer feedback, including product reviews, ratings, and resolution status.
| Feedback ID | Customer Name | Product | Feedback | Rating (out of 5) | Date | Resolution Status |
|---|---|---|---|---|---|---|
| FDBK1005 | David Lee | Laptop Backpack | Excellent build quality, worth the price. | 5 | 2025-04-02 | Resolved |
Contains details about patients, including diagnosis, medications, and last visit date.
| Patient ID | Name | Age | Gender | Diagnosis | Medications | Last Visit |
|---|---|---|---|---|---|---|
| PT9345 | Linda Gomez | 52 | Female | Type 2 Diabetes | Metformin | 2025-03-28 |
Contains details about eCommerce orders, including customer details, products, and order status.
| Order ID | Customer Name | Order Date | Shipping Address | Product | Quantity | Price per Unit ($) | Total Cost ($) | Order Status |
|---|---|---|---|---|---|---|---|---|
| ECOM3201 | Robert Downey | 2025-04-05 | 221B Baker Street, London | Smartwatch | 1 | 199.99 | 199.99 | Shipped |
Contains details about inventory, including product information, stock levels, reorder thresholds, and supplier details.
| Inventory ID | Product Name | Category | Stock Available | Reorder Level | Supplier | Warehouse Location | Last Restocked |
|---|---|---|---|---|---|---|---|
| INV2025 | Printer Ink Cartridge | Office Supplies | 300 | 100 | InkFlow | Warehouse C | 2025-03-18 |
With sales data, you can create dashboards that show:
Power BI can be used to visualize:
Product and inventory datasets help track:
Power BI dashboards allow you to segment customers by demographics, purchase behavior, or satisfaction scores. You can also visualize sentiment trends from feedback over time.
Marketing data in Power BI can reveal:
Logistics datasets can be visualized to track:
Financial transactions can be analyzed to show:
E-commerce datasets allow you to track:
Absolutely. Each dataset is designed to mimic real-world scenarios and works well with Power BI visuals like bar charts, line graphs, slicers, KPIs, and interactive drilldowns.
Yes. You can use Power Query in Power BI to clean, merge, pivot, and filter these Excel files before visualizing them, which enhances your data wrangling skills.
Amazon Products Datasets | Automotive Datasets | Business Intelligence Datasets | Call Center Datasets | Cancer Datasets | CRM Datasets | Customer Segmentation Datasets | Demand Datasets | Diabetes Datasets | Healthcare Datasets | Heart Disease Datasets | HR Datasets | Lending Club Datasets | Oil Price Datasets | Purchase Datasets | Retail Datasets | Sales Datasets for Analysis