# faisalkhan-7/supplier-reporting-insights-olist-data- architecture

> Architecture diagram of the GitHub repository faisalkhan-7/supplier-reporting-insights-olist-data-, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-21). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/faisalkhan-7/supplier-reporting-insights-olist-data-
- Repository: https://github.com/faisalkhan-7/supplier-reporting-insights-olist-data-
- Video tour (about a minute): https://gitdiagram.com/faisalkhan-7/supplier-reporting-insights-olist-data-/video

## Overview

This is a BigQuery- and Power BI-based supplier scorecard built on Olist marketplace data. The workflow loads CSVs into BigQuery, cleans them into SQL views, and imports governed data into a Power BI report for category managers. The report covers supplier ranking, assortment performance, and product-listing quality. The graph reflects the README’s documented architecture and capabilities; source excerpts were not available to verify implementation details beyond those statements.

Main entry points: [`power-bi/Supplier Performance Report.pbix`](https://github.com/faisalkhan-7/supplier-reporting-insights-olist-data-/blob/main/power-bi/Supplier%20Performance%20Report.pbix) (Power BI report), [`warehouse/load_to_bigquery.sh`](https://github.com/faisalkhan-7/supplier-reporting-insights-olist-data-/blob/main/warehouse/load_to_bigquery.sh) (BigQuery loader), [`sql/data cleaning 01.sql`](https://github.com/faisalkhan-7/supplier-reporting-insights-olist-data-/blob/main/sql/data%20cleaning%2001.sql) (Cleaning views), [`warehouse/data`](https://github.com/faisalkhan-7/supplier-reporting-insights-olist-data-/tree/main/warehouse/data) (Olist CSVs)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Source Data"]
  node_olist_data["Olist CSVs"]
end

subgraph group_warehouse["Warehouse"]
  node_loader["BigQuery loader"]
  node_bigquery[("BigQuery raw tables")]
  node_cleaning["Cleaning views"]
end

subgraph group_reporting["Reporting"]
  node_powerbi_report["Power BI report"]
  node_scorecard["Supplier scorecard"]
  node_assortment["Assortment analysis"]
  node_data_quality["Product data quality"]
end

node_manager(("Category manager"))

node_olist_data -->|"loads from"| node_loader
node_loader -->|"loads tables"| node_bigquery
node_bigquery -->|"cleans into views"| node_cleaning
node_cleaning -->|"imports data"| node_powerbi_report
node_powerbi_report -->|"presents"| node_scorecard
node_powerbi_report -->|"presents"| node_assortment
node_powerbi_report -->|"presents"| node_data_quality
node_manager -->|"uses"| node_powerbi_report

click node_olist_data "https://github.com/faisalkhan-7/supplier-reporting-insights-olist-data-/tree/main/warehouse/data"
click node_loader "https://github.com/faisalkhan-7/supplier-reporting-insights-olist-data-/blob/main/warehouse/load_to_bigquery.sh"
click node_cleaning "https://github.com/faisalkhan-7/supplier-reporting-insights-olist-data-/blob/main/sql/data%20cleaning%2001.sql"
click node_powerbi_report "https://github.com/faisalkhan-7/supplier-reporting-insights-olist-data-/blob/main/power-bi/Supplier%20Performance%20Report.pbix"
click node_scorecard "https://github.com/faisalkhan-7/supplier-reporting-insights-olist-data-/blob/main/power-bi/Supplier%20Performance%20Report.pbix"
click node_assortment "https://github.com/faisalkhan-7/supplier-reporting-insights-olist-data-/blob/main/power-bi/Supplier%20Performance%20Report.pbix"
click node_data_quality "https://github.com/faisalkhan-7/supplier-reporting-insights-olist-data-/blob/main/power-bi/Supplier%20Performance%20Report.pbix"

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_olist_data toneBlue
class node_loader,node_bigquery,node_cleaning toneAmber
class node_powerbi_report,node_scorecard,node_assortment,node_data_quality toneMint
class node_manager toneIndigo
```

## Components

### Source Data

- [Olist CSVs](https://github.com/faisalkhan-7/supplier-reporting-insights-olist-data-/tree/main/warehouse/data): `warehouse/data`

### Warehouse

- [BigQuery loader](https://github.com/faisalkhan-7/supplier-reporting-insights-olist-data-/blob/main/warehouse/load_to_bigquery.sh): `warehouse/load_to_bigquery.sh`
- **BigQuery raw tables**
- [Cleaning views](https://github.com/faisalkhan-7/supplier-reporting-insights-olist-data-/blob/main/sql/data%20cleaning%2001.sql): `sql/data cleaning 01.sql`

### Reporting

- [Power BI report](https://github.com/faisalkhan-7/supplier-reporting-insights-olist-data-/blob/main/power-bi/Supplier%20Performance%20Report.pbix): `power-bi/Supplier Performance Report.pbix`
- [Supplier scorecard](https://github.com/faisalkhan-7/supplier-reporting-insights-olist-data-/blob/main/power-bi/Supplier%20Performance%20Report.pbix): `power-bi/Supplier Performance Report.pbix`
- [Assortment analysis](https://github.com/faisalkhan-7/supplier-reporting-insights-olist-data-/blob/main/power-bi/Supplier%20Performance%20Report.pbix): `power-bi/Supplier Performance Report.pbix`
- [Product data quality](https://github.com/faisalkhan-7/supplier-reporting-insights-olist-data-/blob/main/power-bi/Supplier%20Performance%20Report.pbix): `power-bi/Supplier Performance Report.pbix`

### Other components

- **Category manager**

## Connections

- Olist CSVs → BigQuery loader: loads from (evidence: `README.md`)
- BigQuery loader → BigQuery raw tables: loads tables (evidence: `README.md`)
- BigQuery raw tables → Cleaning views: cleans into views (evidence: `README.md`)
- Cleaning views → Power BI report: imports data (evidence: `README.md`)
- Power BI report → Supplier scorecard: presents (evidence: `README.md`)
- Power BI report → Assortment analysis: presents (evidence: `README.md`)
- Power BI report → Product data quality: presents (evidence: `README.md`)
- Category manager → Power BI report: uses (evidence: `README.md`)
