Datasets by tool

Power BI Practice Datasets

A good Power BI practice file has three things: a date column for time intelligence, a few categories worth slicing by, and measures worth summing. Every dataset here has all three, and each comes from a business question, so your report has something to say rather than a chart of noise. Open any dataset to see its sample rows and columns, then download it as Excel or CSV and load it with Get Data.

Sales and retail dashboards

Transaction-level sales you can build a classic sales report on: revenue by store, product category and payment method, promotions against a control group, returns by reason, and footfall by day of week with holidays flagged. Good first files for DAX measures like total sales, average order value and year-to-date.

Other18 cols · 200 rows

Small Retailer Sales Transactions

This dataset provides detailed transaction-level sales data from small local retailers, including product, payment, and retailer information. It enables comprehensive analysis of sales trends, business performance, and consumer behavior, supporting decision-making for retail operations and market research.

retailer_nameproduct_nameproduct_category
SuperMart DowntownOrganic Milk GallonGrocery
ElectroHubBluetooth HeadphonesElectronics
FashionistaSummer DressApparel
transaction_idtransaction_dateretailer_id+12 more
Marketing18 cols · 200 rows

Synthetic Retail Promotion Uplift

This dataset provides granular sales transaction records enriched with detailed promotion and campaign information, enabling precise uplift analysis for retail marketing teams. It supports measurement of promotional effectiveness across products, stores, channels, and customer segments, making it ideal for optimizing campaign strategies and maximizing ROI.

store_regionproduct_categorypromotion_type
PacificElectronics–
SouthGroceriesdiscount
CentralClothing–
transaction_idtransaction_datestore_id+12 more
E-commerce22 cols · 200 rows

Online Retail Product Return Analytics

This dataset provides detailed, flat records of e-commerce product returns, including transaction details, customer demographics, product information, and reasons for return. It is designed for supply chain optimization, quality improvement, and customer experience analysis, enabling granular insights into return patterns and drivers across products and customer segments.

product_namereturn_reasonrefund_amount
UltraHD Smart TV 55indefective449.99
Womens Summer Dress Lsize issue39.99
Modern Floor Lamp Blacknot as described125
time_to_return_daysreturn_methodcustomer_country+16 more
Other15 cols · 200 rows

Retail In-Store Foot Traffic Counts

This dataset provides anonymized, daily foot traffic counts for physical retail locations, enriched with store details, holiday indicators, weather conditions, and special event annotations. It enables robust sales forecasting, staffing optimization, and marketing campaign impact analysis by correlating footfall with external factors and store attributes.

store_nameday_of_weekis_holiday
FreshMart DowntownFridayfalse
MegaMart UptownSaturdayfalse
Boutique ParisienneFridaytrue
foot_traffic_idstore_idstore_street_address+9 more

Operations: inventory, defects and downtime

Operational data where the interesting question is where things go wrong. Defect rates by line and shift, downtime by cause and equipment type, and warehouse stock movements by type. Try a matrix visual with conditional formatting, or a decomposition tree on defect_count.

Manufacturing18 cols · 200 rows

Manufacturing Production Defect Rates

This dataset provides detailed records of defect rates in manufacturing production, including batch-level information on plant, production line, product, inspection methods, and defect types. It enables quality managers and process engineers to monitor, analyze, and optimize production quality, identify trends, and address recurring issues for improved operational efficiency.

plant_nameproduction_line_nameproduct_name
Midwest Assembly PlantConveyor Assembly LineGearBox X
Pacific Tech PlantPrecision SMD LineChipster V2
Eastern Components FacilityMechanical Drive LineWidget Mini
record_idproduction_dateplant_id+12 more
Manufacturing9 cols · 200 rows

Manufacturing Line Defect Counts

This dataset provides detailed, shift-level defect counts for each product type and manufacturing line, enabling granular quality control analysis and predictive modeling. With fields for defect categories, production volumes, and calculated defect rates, it supports both operational monitoring and advanced AI-driven analytics to improve manufacturing processes.

shiftdefect_typedefect_rate
MorningSurface0.01
AfternoonMechanical0
NightElectrical0.12632
production_lineproduct_typetotal_units_produced+3 more
Manufacturing17 cols · 200 rows

Industrial Equipment Downtime Logs

This dataset contains detailed logs of downtime events for critical manufacturing equipment, including timestamps, causes, maintenance actions, and impact metrics such as cost and production loss. It enables reliability analysis, maintenance optimization, and cost reduction strategies for manufacturing operations. The dataset is structured for easy integration with analytics platforms and supports granular tracking of equipment performance.

equipment_nameequipment_typedowntime_category
CNC Lathe A1CNC machineplanned
Conveyor Belt B2conveyorunplanned
Hydraulic Press C3pressemergency
downtime_idequipment_idlocation+11 more
Logistics23 cols · 200 rows

Warehouse Inventory Flow Dataset

This dataset provides detailed records of goods movement into, out of, and between warehouses, including product details, quantities, movement types, and timestamps. It enables comprehensive tracking for inventory optimization, order fulfillment, and operational analysis in logistics and supply chain management. The structure supports audit trails, loss prevention, and process improvement.

warehouse_nameproduct_namemovement_type
Central DistributionElectric Drill 500Winbound
North HubHeavy Duty Hammeroutbound
East StorageSafety Gloves Largetransfer
inventory_flow_idwarehouse_idwarehouse_street_address+17 more

Finance, HR and service reports

Accounts receivable with aging buckets, branch performance by reporting period, employee attrition with tenure and satisfaction, and IT tickets with priorities and SLA due dates. These make good one-page executive reports with KPI cards across the top.

Finance16 cols · 100 rows

Accounts Receivable and Aging Analysis

This dataset provides a comprehensive view of accounts receivable balances, aging buckets, collection rates, bad debt, write-offs, and AR days, enabling organizations to monitor financial performance and optimize collection strategies. It supports granular analysis by payer and invoice, facilitating prioritization of collection efforts and risk assessment for outstanding receivables.

payer_namepayer_typeaging_bucket
Springfield Health Insuranceinsurance1-30
Green Valley MedicalcustomerCurrent
MetroCare Partnersinsurance61-90
ar_record_idpayer_idinvoice_id+10 more
Finance19 cols · 200 rows

Bank Branch Performance Metrics

This dataset provides comprehensive performance metrics for individual bank branches, including account activity, transaction volumes, and customer feedback scores over specific reporting periods. It enables detailed analysis of operational efficiency, customer satisfaction, and issue resolution, supporting data-driven management decisions and branch benchmarking.

branch_nameaddress_countryaccounts_opened
Downtown FinancialUSA400
Bayview BranchUSA380
Lakeshore CenterUSA305
branch_idbranch_manageraddress_street+13 more
Human Resources26 cols · 200 rows

Employee Attrition Prediction Dataset

This dataset provides detailed HR records for employees, including demographics, job history, satisfaction, performance, and attrition status. It is ideal for building predictive models to identify turnover risks, analyze workforce trends, and inform retention strategies. Rich features enable advanced analytics for HR decision-making and organizational planning.

first_namelast_namemarital_status
RiyaPatelMarried
CarlosDominguezSingle
AishaOkaforWidowed
employee_idgenderdate_of_birth+20 more
Technology20 cols · 200 rows

IT Service Ticket Classification

This dataset contains detailed records of IT service tickets, combining structured metadata (such as priority, category, and assignment) with rich ticket descriptions suitable for natural language processing. It enables automated ticket triage, prioritization, and advanced analytics for IT support operations, making it ideal for machine learning and process optimization.

ticket_subjectcategorypriority
Laptop battery fails to chargehardwaremedium
Cannot print from office printerhardwarehigh
Server room temperature alerthardwarecritical
departmentstatusurgency+14 more

Every dataset in this collection

14 datasets

Other18 cols · 200 rows

Small Retailer Sales Transactions

This dataset provides detailed transaction-level sales data from small local retailers, including product, payment, and retailer information. It enables comprehensive analysis of sales trends, business performance, and consumer behavior, supporting decision-making for retail operations and market research.

retailer_nameproduct_nameproduct_category
SuperMart DowntownOrganic Milk GallonGrocery
ElectroHubBluetooth HeadphonesElectronics
FashionistaSummer DressApparel
transaction_idtransaction_dateretailer_id+12 more
Marketing18 cols · 200 rows

Synthetic Retail Promotion Uplift

This dataset provides granular sales transaction records enriched with detailed promotion and campaign information, enabling precise uplift analysis for retail marketing teams. It supports measurement of promotional effectiveness across products, stores, channels, and customer segments, making it ideal for optimizing campaign strategies and maximizing ROI.

store_regionproduct_categorypromotion_type
PacificElectronics–
SouthGroceriesdiscount
CentralClothing–
transaction_idtransaction_datestore_id+12 more
E-commerce22 cols · 200 rows

Online Retail Product Return Analytics

This dataset provides detailed, flat records of e-commerce product returns, including transaction details, customer demographics, product information, and reasons for return. It is designed for supply chain optimization, quality improvement, and customer experience analysis, enabling granular insights into return patterns and drivers across products and customer segments.

product_namereturn_reasonrefund_amount
UltraHD Smart TV 55indefective449.99
Womens Summer Dress Lsize issue39.99
Modern Floor Lamp Blacknot as described125
time_to_return_daysreturn_methodcustomer_country+16 more
Other15 cols · 200 rows

Retail In-Store Foot Traffic Counts

This dataset provides anonymized, daily foot traffic counts for physical retail locations, enriched with store details, holiday indicators, weather conditions, and special event annotations. It enables robust sales forecasting, staffing optimization, and marketing campaign impact analysis by correlating footfall with external factors and store attributes.

store_nameday_of_weekis_holiday
FreshMart DowntownFridayfalse
MegaMart UptownSaturdayfalse
Boutique ParisienneFridaytrue
foot_traffic_idstore_idstore_street_address+9 more
Manufacturing18 cols · 200 rows

Manufacturing Production Defect Rates

This dataset provides detailed records of defect rates in manufacturing production, including batch-level information on plant, production line, product, inspection methods, and defect types. It enables quality managers and process engineers to monitor, analyze, and optimize production quality, identify trends, and address recurring issues for improved operational efficiency.

plant_nameproduction_line_nameproduct_name
Midwest Assembly PlantConveyor Assembly LineGearBox X
Pacific Tech PlantPrecision SMD LineChipster V2
Eastern Components FacilityMechanical Drive LineWidget Mini
record_idproduction_dateplant_id+12 more
Manufacturing9 cols · 200 rows

Manufacturing Line Defect Counts

This dataset provides detailed, shift-level defect counts for each product type and manufacturing line, enabling granular quality control analysis and predictive modeling. With fields for defect categories, production volumes, and calculated defect rates, it supports both operational monitoring and advanced AI-driven analytics to improve manufacturing processes.

shiftdefect_typedefect_rate
MorningSurface0.01
AfternoonMechanical0
NightElectrical0.12632
production_lineproduct_typetotal_units_produced+3 more
Manufacturing17 cols · 200 rows

Industrial Equipment Downtime Logs

This dataset contains detailed logs of downtime events for critical manufacturing equipment, including timestamps, causes, maintenance actions, and impact metrics such as cost and production loss. It enables reliability analysis, maintenance optimization, and cost reduction strategies for manufacturing operations. The dataset is structured for easy integration with analytics platforms and supports granular tracking of equipment performance.

equipment_nameequipment_typedowntime_category
CNC Lathe A1CNC machineplanned
Conveyor Belt B2conveyorunplanned
Hydraulic Press C3pressemergency
downtime_idequipment_idlocation+11 more
Logistics23 cols · 200 rows

Warehouse Inventory Flow Dataset

This dataset provides detailed records of goods movement into, out of, and between warehouses, including product details, quantities, movement types, and timestamps. It enables comprehensive tracking for inventory optimization, order fulfillment, and operational analysis in logistics and supply chain management. The structure supports audit trails, loss prevention, and process improvement.

warehouse_nameproduct_namemovement_type
Central DistributionElectric Drill 500Winbound
North HubHeavy Duty Hammeroutbound
East StorageSafety Gloves Largetransfer
inventory_flow_idwarehouse_idwarehouse_street_address+17 more
Finance16 cols · 100 rows

Accounts Receivable and Aging Analysis

This dataset provides a comprehensive view of accounts receivable balances, aging buckets, collection rates, bad debt, write-offs, and AR days, enabling organizations to monitor financial performance and optimize collection strategies. It supports granular analysis by payer and invoice, facilitating prioritization of collection efforts and risk assessment for outstanding receivables.

payer_namepayer_typeaging_bucket
Springfield Health Insuranceinsurance1-30
Green Valley MedicalcustomerCurrent
MetroCare Partnersinsurance61-90
ar_record_idpayer_idinvoice_id+10 more
Finance19 cols · 200 rows

Bank Branch Performance Metrics

This dataset provides comprehensive performance metrics for individual bank branches, including account activity, transaction volumes, and customer feedback scores over specific reporting periods. It enables detailed analysis of operational efficiency, customer satisfaction, and issue resolution, supporting data-driven management decisions and branch benchmarking.

branch_nameaddress_countryaccounts_opened
Downtown FinancialUSA400
Bayview BranchUSA380
Lakeshore CenterUSA305
branch_idbranch_manageraddress_street+13 more
Human Resources26 cols · 200 rows

Employee Attrition Prediction Dataset

This dataset provides detailed HR records for employees, including demographics, job history, satisfaction, performance, and attrition status. It is ideal for building predictive models to identify turnover risks, analyze workforce trends, and inform retention strategies. Rich features enable advanced analytics for HR decision-making and organizational planning.

first_namelast_namemarital_status
RiyaPatelMarried
CarlosDominguezSingle
AishaOkaforWidowed
employee_idgenderdate_of_birth+20 more
Technology20 cols · 200 rows

IT Service Ticket Classification

This dataset contains detailed records of IT service tickets, combining structured metadata (such as priority, category, and assignment) with rich ticket descriptions suitable for natural language processing. It enables automated ticket triage, prioritization, and advanced analytics for IT support operations, making it ideal for machine learning and process optimization.

ticket_subjectcategorypriority
Laptop battery fails to chargehardwaremedium
Cannot print from office printerhardwarehigh
Server room temperature alerthardwarecritical
departmentstatusurgency+14 more
Human Resources22 cols · 200 rows

Retail Workforce Shift Optimization

This dataset provides comprehensive records of retail staff shifts, availability, and labor costs across multiple store locations. It enables detailed analysis and optimization of workforce scheduling, helping retailers reduce labor costs, improve coverage, and ensure compliance with employee availability. The dataset is ideal for workforce analytics, scheduling automation, and operational efficiency improvements.

employee_namestore_nameshift_status
Maria BennettSuperMart Downtownscheduled
Jeffrey WangSuperMart Eastcompleted
Olivia PatelSuperMart Northscheduled
shift_idemployee_idrole+16 more
Healthcare20 cols · 200 rows

Pharmacy Inventory Sales Forecast

This dataset provides detailed historical sales and inventory records for top pharmacy products, including batch-level expiration and restock information, store locations, and transaction details. It enables precise inventory optimization, demand forecasting, and proactive management of product expirations across multiple pharmacy locations.

product_namecategorystore_name
Ibuprofen 200mganalgesicHealthFirst Pharmacy
Amoxicillin 500mgantibioticCare Max
Vitamin D3 1000IUsupplementPharmaTrust
sale_idproduct_idmanufacturer+14 more

Questions

Which format should I download for Power BI?
Excel or CSV. Both load straight into Power BI Desktop with Get Data. Every dataset also comes as JSON, Parquet, JSONL, SQL, TSV and XML.
Are these datasets big enough for a Power BI project?
Each ready-made dataset has a few hundred rows, which is plenty to build and test a report. If you want more history or more rows, open the dataset in GoMask Data Factory and generate up to a million rows with the same columns.
Can I use these in a portfolio or client demo?
Yes. The data is synthetic, so there is no personal or customer data in it, and the licence allows commercial use.

What should your data show?

Preview 20 rows free
No signup. No card.