How bunghasan/ecommerce-data-warehouse-bi works
This repository is a small e-commerce data-warehouse and business-intelligence project: a Python script generates transactional source data, transforms it into a dimensional data mart, and can load that mart into DuckDB for analysis. The CSV mart and SQL query files represent the analytical deliverables. The README is empty, and only partial generator excerpts were supplied, so links for query execution and some generated outputs are limited to what the tree and excerpts support.
Main entry points: generate_dataset.py Dataset generator · data_mart Dimensional mart · data Raw sources · ecommerce_dwbi.duckdb DuckDB warehouse
Components 8
Data generation
- Dataset generator
TUGAS_DWBI_Ahmad Hasanuddin/scripts/generate_dataset.py - Raw sources
TUGAS_DWBI_Ahmad Hasanuddin/data
Warehouse
- Dimensional mart
TUGAS_DWBI_Ahmad Hasanuddin/data_mart - DuckDB warehouse
TUGAS_DWBI_Ahmad Hasanuddin/database/ecommerce_dwbi.duckdb - PostgreSQL schema
TUGAS_DWBI_Ahmad Hasanuddin/scripts/create_datamart_postgresql.sql
Analytics
- Analytical queries
TUGAS_DWBI_Ahmad Hasanuddin/scripts/analytic_queries.sql - Query results
TUGAS_DWBI_Ahmad Hasanuddin/result
Other components
- Project operator
Connections 6
- Project operator → Dataset generator: runs
- Dataset generator → Raw sources: generates
- Dataset generator → Dimensional mart: builds
- Dimensional mart → Dataset generator: reads for loading
- Dataset generator → DuckDB warehouse: loads tables
- Dataset generator → PostgreSQL schema: writes schema