Oduoryharon/KRD-generator

The scripts inside here are generating synthetic dataset for retail data in kenya from 2020-2025 # KRD-generator The scripts inside here are generating synthetic dataset for retail data in kenya from 2020-2025 # Overview The Kenyan Retail Dataset Generator is a Python-based synthetic data generation project designed to simulate realistic retail operations within a Kenyan retail environment. The project generates interconnected master and transactional datasets representing customers, products, suppliers, stores, inventory, sales, payments, and returns. The generated data can be used for: - Data analytics - SQL practice - Data cleaning - ETL pipelines - Data warehousing - Dashboard development - Business intelligence - Data quality testing - Portfolio projects # Project Objectives The main objective of this project is to create a realistic synthetic retail dataset that can be used to practice end-to-end data workflows. The project focuses on generating: - Structured master data - Transactional retail data - Referential relationships between datasets - Realistic business rules - Clean datasets - Raw datasets containing controlled data quality issues # Dataset Architecture The dataset is divided into three main layers: ### master data Master data contains relatively stable business entities; This include: > categories > suppliers > stores customers products inventory ### Transaction data Transaction datasets represent retail activities: > Sales Sales details payment returns # Raw Data Raw datasets contain controlled data quality issues designed for data cleaning and ETL practice. Examples include: - Missing values - Duplicate values - Inconsistent text casing - Extra spaces - Phone number formatting differences - Email formatting errors - Location name variations - Invalid inventory quantities - Inconsistent stock status values # Data Relationship ``` Categories │ └──── Products │ ├──── Inventory │ └──── Sales Details │ Customers ───── Sales ───── Payments │ └──── Returns Suppliers ───── Products Stores ───── Inventory │ └──── Sales ``` # Data G …