Dark Mode
Gearsparks Emporium Transaction Data
Product Reviews & Feedback
Tags and Keywords
Trusted By
"No reviews yet"
Free
About
This data product simulates shop sales activity within Baldur's Gate city, specifically transactions recorded by "Gearspark's Emporium for Adventurers". The underlying database aims to provide detailed sales records that allow analysts to extract insights crucial for optimising product offerings and enhancing customer satisfaction. The data includes information about products purchased, detailed customer demographics such as race, age, and class, and correlated encounter data, offering a unique look into adventurer spending habits. This vendor simulates common sales, as very rare and legendary items have been intentionally excluded from the records.
Columns
The dataset is structured across several tables linked by IDs, providing attributes such as:
- sale_id: Unique identification for each sale transaction.
- date: The date the sale occurred.
- customer_id: Unique identification for the purchasing customer.
- product_id: Unique identification for the item sold.
- price: The price of the product sold.
- product_name: The descriptive name of the item.
- name (Customer): The customer's assigned name.
- sex: The customer's gender.
- race: The customer’s race, noting that age ranges vary widely based on this attribute.
- age: The customer’s age.
- class: The customer’s adventurer class.
- type: The product type, referencing specific details tables (e.g., 'weapon').
- damage: The amount of damage a weapon can inflict.
- ac: Armor Class, representing defences against monster attacks.
- weight: The item's weight.
- requirements: Any specific requirements needed to use the item.
- stealth: Indicates if the item affects the customer's stealth abilities.
- dc: Difficulty Class, the threshold score needed for a successful dice roll.
- properties: Special attributes or properties of the item.
- rarity: The rarity of the item (excluding Very Rare and Legendary).
- category: The item's defined category.
- enc_id: Unique identification for an encounter record.
- encounter_date: Date of the recorded encounter.
- monster: The type of monster involved in the encounter.
- encounter_type: The classification of the recorded encounter.
Distribution
The data simulates records originating from a database structure, featuring clear relationships between sales, customer, product details, and encounters tables. The currency system used includes Copper (cp), Silver (sp), Electrum (ep), Gold (gp), and Platinum (pp), with precise conversion rates provided (e.g., 1 Gold Piece equals 100 Copper Pieces). The exact number of rows or records is not specified, but the data simulates transactions over a defined timeline.
Usage
This data is perfectly suited for practicing advanced Data Analysis techniques. Ideal applications include identifying key data patterns related to item sales performance and understanding factors that contribute to customer satisfaction. It can be used to analyse correlations between purchases (weapons, armour, items) and subsequent customer attributes or recorded encounter types. The dataset is excellent for honing skills in database querying and structured analytical reporting.
Coverage
Geographic Scope: All sales are recorded from Gearspark's Emporium, situated within Baldur's Gate.
Time Range: The simulated sales calendar is anchored to the start date of Baldur's Gate 3 production, extending up to the present day.
Demographic Scope: Detailed customer demographics are provided, including race, class, gender, and age. Note that age calculation is relative, accommodating the long lifespans of specific fantasy races.
Product Scope: Restricted to items commonly sold by a general vendor, explicitly excluding those of Very Rare and Legendary status.
License
Attribution-NonCommercial-NoDerivatives 4.0 International
Who Can Use It
- Data Analysts: For simulation exercises and practicing analytical prowess on detailed, structured sales records.
- Game Developers/Designers: To study virtual economy dynamics and inventory balancing in a fantasy setting.
- Academics: For research into simulated consumer behaviour and demographic purchasing patterns.
Dataset Name Suggestions
Baldur's Gate Adventurer Sales Log
Gearspark's Emporium Transaction Data
Simulated Faerûn Retail Analytics
BG3 Vendor Sales Database
Attributes
Original Data Source: Gearsparks Emporium Transaction Data
QUALITY