How avinaash-02/de-mini-project-db works
This repository is a notebook-based data analytics pipeline, organized around bronze ingestion, silver cleaning, and gold modeling and analysis. Its domain outputs include customer, date, geography, product, and seller dimensions; order, payment, and review facts; curated tables and a cube; and business KPIs. The tree indicates an orchestration configuration, but no README or source excerpts were provided. Accordingly, workflow links are shown as unverified, and the graph does not assert particular inputs, storage systems, or execution behavior.
Main entry points: nb_curated_table.ipynb Curated tables · nb_gold_schema_creation.ipynb Gold schema · nb_data_cleaning_silver.ipynb Data cleaning · Dim_Table_Notebook Dimension tables
Components 32
Bronze ingestion
- Data ingestion
01_bronze/nb_data_ingestion_bronze.ipynb
Silver cleaning
- Data cleaning
02_silver/nb_data_cleaning_silver.ipynb
Gold data model
- Gold schema
03_gold/nb_gold_schema_creation.ipynb - Dimension tables
03_gold/Dim_Table_Notebook - Customer dimension
03_gold/Dim_Table_Notebook/nb_dim_customer.ipynb - Date dimension
03_gold/Dim_Table_Notebook/nb_dim_date.ipynb - Geography dimension
03_gold/Dim_Table_Notebook/nb_dim_geography.ipynb - Product dimension
03_gold/Dim_Table_Notebook/nb_dim_products.ipynb - Seller dimension
03_gold/Dim_Table_Notebook/nb_dim_sellers.ipynb - Fact tables
03_gold/Fact_Table_Notebook - Order item facts
03_gold/Fact_Table_Notebook/nb_fact_order_items.ipynb - Order facts
03_gold/Fact_Table_Notebook/nb_fact_orders.ipynb - Payment facts
03_gold/Fact_Table_Notebook/nb_fact_payments.ipynb - Review facts
03_gold/Fact_Table_Notebook/nb_fact_reviews.ipynb
Gold analytics
- Curated tables
03_gold/curated_table_notebook/nb_curated_table.ipynb - Analytics cube
03_gold/cube_notebook/nb_cube_notebook.ipynb - Average order value
03_gold/kpi_notebook/nb_kpi_aov.ipynb - Delivery metrics
03_gold/kpi_notebook/nb_kpi_avg_delivery_dates.ipynb - Customer lifetime value
03_gold/kpi_notebook/nb_kpi_clv.ipynb - Late deliveries
03_gold/kpi_notebook/nb_kpi_late_delivery.ipynb - Low ratings
03_gold/kpi_notebook/nb_kpi_low_rating.ipynb - Customer segments
03_gold/kpi_notebook/nb_kpi_new_returning_customers.ipynb - Order fulfilment
03_gold/kpi_notebook/nb_kpi_order_fulfilment.ipynb - Orders by location
03_gold/kpi_notebook/nb_kpi_orderby_city_state.ipynb - Payment distribution
03_gold/kpi_notebook/nb_kpi_payment_distribution.ipynb - Monthly revenue
03_gold/kpi_notebook/nb_kpi_revenue_by_month.ipynb - Product revenue
03_gold/kpi_notebook/nb_kpi_revenue_by_products.ipynb - Seller revenue
03_gold/kpi_notebook/nb_kpi_revenue_by_sellers.ipynb - Top products
03_gold/kpi_notebook/nb_kpi_top_products.ipynb - Top sellers
03_gold/kpi_notebook/nb_kpi_top_sellers.ipynb - Combined KPIs
03_gold/kpis_notebook/nb_all_kpis.ipynb
Orchestration
- Pipeline config
04_orchestration/orchestration_pipeline.yaml
Connections 8
- Data ingestion → Data cleaning: feeds forward
- Data cleaning → Gold schema: feeds forward
- Gold schema → Dimension tables: supports modeling
- Gold schema → Fact tables: supports modeling
- Dimension tables → Curated tables: may inform
- Fact tables → Curated tables: may inform
- Curated tables → Analytics cube: may feed
- Curated tables → Combined KPIs: may feed