Dark Mode
Simulated Expense Transaction Data
Data Science and Analytics
Tags and Keywords
Trusted By
"No reviews yet"
Free
About
Simulated procurement transactions document the purchasing activities of a mid-sized organisation throughout the year 2024. This synthetic data captures purchases across multiple classifications, including electronics, furniture, and stationery, involving various suppliers and internal buyers. It is designed specifically to support descriptive analytics, detailed spend analysis, evaluation of supplier performance, and initiatives aimed at cost optimisation.
Columns
- TransactionID: A unique identifier assigned to each purchasing event (e.g., TXN001).
- ItemName: The specific name of the item acquired (e.g., Stapler, Laptop Bag).
- Category: The classification under which the item falls, such as Electronics or Furniture.
- Quantity: The number of units purchased in the transaction, with values observed between 1 and 20.
- UnitPrice: The cost per individual unit, recorded in USD, ranging from 1.06 up to 9.91 thousand.
- TotalCost: The overall cost of the transaction, calculated by multiplying Quantity by UnitPrice, with costs ranging from 1.56 to 18.5 thousand.
- PurchaseDate: The calendar date of the purchase, provided in YYYY-MM-DD format.
- Supplier: The name of the external vendor or provider (e.g., TechMart Inc., QuickDeliver Ltd.).
- Buyer: The name of the employee or department within the organisation responsible for initiating the purchase.
Distribution
The data file, named spend_analysis_dataset.csv, contains 500 rows and 9 distinct columns. All 500 records are valid with no mismatched or missing entries across any field. The item categories are varied, with Electronics accounting for 29% of transactions and Furniture making up 20%. The data includes 10 unique item names and involves 5 distinct suppliers.
Usage
Ideal applications for this product include detailed Spend Analytics to trace spending patterns, evaluating Supplier Performance based on transaction history, and executing Cost Optimisation studies. It is excellent practice material for mastering descriptive analytics techniques.
Coverage
The temporal scope spans 2024, covering transactions from 1 January through 30 December. The data is synthetic, modelling the procurement environment of a mid-sized business.
License
CC0: Public Domain
Who Can Use It
- Finance professionals seeking insights into corporate spending habits.
- Supply Chain analysts interested in vendor management and purchase patterns.
- Data scientists needing clean, structured data for developing basic descriptive models.
Dataset Name Suggestions
- Corporate Procurement Spend 2024
- Mid-Sized Organization Purchasing Log
- Simulated Expense Transaction Data
Attributes
Original Data Source: Simulated Expense Transaction Data
QUALITYLoading...