# rodrigosilva1936/olist-retail-sales-analytics architecture

> Architecture diagram of the GitHub repository rodrigosilva1936/olist-retail-sales-analytics, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-16). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/rodrigosilva1936/olist-retail-sales-analytics
- Repository: https://github.com/rodrigosilva1936/olist-retail-sales-analytics

## Overview

The repository appears to be an Olist retail data-warehouse ETL project: SSIS packages are organized around customer, geography, order, product, seller, and related datasets, alongside SQL for staging and warehouse dimensions. The likely outcome is prepared data for analytics, but the README and source excerpts are absent, so execution order, data movement, and package-to-SQL relationships cannot be verified. Components below reflect the tree only; no relationships are asserted.

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_ssis["SSIS Loads"]
  node_customers["Customers Load"]
  node_dim_customer["Customer Dimension Load"]
  node_geolocation["Geolocation Load"]
  node_order_items["Order Items Load"]
  node_order_payments["Order Payments Load"]
  node_order_reviews["Order Reviews Load"]
  node_orders["Orders Load<br/>[Load_Orders.dtsx]"]
  node_category_translation["Category Translation Load"]
  node_products["Products Load<br/>[Load_Products.dtsx]"]
  node_sellers["Sellers Load<br/>[Load_Sellers.dtsx]"]
end

subgraph group_staging["Staging SQL"]
  node_staging_schema["Staging Schema<br/>[Create_staging.sql]"]
  node_quality_checks["Data Quality Checks"]
end

subgraph group_warehouse["Warehouse SQL"]
  node_dimensions["Warehouse Dimensions"]
end

click node_customers "https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/ssis/OlistReatilETL/Load_Customers.dtsx"
click node_dim_customer "https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/ssis/OlistReatilETL/Load_DimCustomer.dtsx"
click node_geolocation "https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/ssis/OlistReatilETL/Load_GeoLocation.dtsx"
click node_order_items "https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/ssis/OlistReatilETL/Load_OrderItems.dtsx"
click node_order_payments "https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/ssis/OlistReatilETL/Load_OrderPayments.dtsx"
click node_order_reviews "https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/ssis/OlistReatilETL/Load_OrderReviews.dtsx"
click node_orders "https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/ssis/OlistReatilETL/Load_Orders.dtsx"
click node_category_translation "https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/ssis/OlistReatilETL/Load_Product_Category_Translation.dtsx"
click node_products "https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/ssis/OlistReatilETL/Load_Products.dtsx"
click node_sellers "https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/ssis/OlistReatilETL/Load_Sellers.dtsx"
click node_staging_schema "https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/sql/staging/Create_staging.sql"
click node_quality_checks "https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/sql/staging/Data_quality_checks.sql"
click node_dimensions "https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/sql/warehouse/create_dimensions.sql"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_customers,node_dim_customer,node_geolocation,node_order_items,node_order_payments,node_order_reviews,node_orders,node_category_translation,node_products,node_sellers toneBlue
class node_staging_schema,node_quality_checks toneAmber
class node_dimensions toneMint
```

## Components

### SSIS Loads

- [Customers Load](https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/ssis/OlistReatilETL/Load_Customers.dtsx): `ssis/OlistReatilETL/Load_Customers.dtsx`
- [Customer Dimension Load](https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/ssis/OlistReatilETL/Load_DimCustomer.dtsx): `ssis/OlistReatilETL/Load_DimCustomer.dtsx`
- [Geolocation Load](https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/ssis/OlistReatilETL/Load_GeoLocation.dtsx): `ssis/OlistReatilETL/Load_GeoLocation.dtsx`
- [Order Items Load](https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/ssis/OlistReatilETL/Load_OrderItems.dtsx): `ssis/OlistReatilETL/Load_OrderItems.dtsx`
- [Order Payments Load](https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/ssis/OlistReatilETL/Load_OrderPayments.dtsx): `ssis/OlistReatilETL/Load_OrderPayments.dtsx`
- [Order Reviews Load](https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/ssis/OlistReatilETL/Load_OrderReviews.dtsx): `ssis/OlistReatilETL/Load_OrderReviews.dtsx`
- [Orders Load](https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/ssis/OlistReatilETL/Load_Orders.dtsx): `ssis/OlistReatilETL/Load_Orders.dtsx`
- [Category Translation Load](https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/ssis/OlistReatilETL/Load_Product_Category_Translation.dtsx): `ssis/OlistReatilETL/Load_Product_Category_Translation.dtsx`
- [Products Load](https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/ssis/OlistReatilETL/Load_Products.dtsx): `ssis/OlistReatilETL/Load_Products.dtsx`
- [Sellers Load](https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/ssis/OlistReatilETL/Load_Sellers.dtsx): `ssis/OlistReatilETL/Load_Sellers.dtsx`

### Staging SQL

- [Staging Schema](https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/sql/staging/Create_staging.sql): `sql/staging/Create_staging.sql`
- [Data Quality Checks](https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/sql/staging/Data_quality_checks.sql): `sql/staging/Data_quality_checks.sql`

### Warehouse SQL

- [Warehouse Dimensions](https://github.com/rodrigosilva1936/olist-retail-sales-analytics/blob/main/sql/warehouse/create_dimensions.sql): `sql/warehouse/create_dimensions.sql`
