# gauravi152/final-data-analytics-project architecture

> Architecture diagram of the GitHub repository gauravi152/final-data-analytics-project, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-27). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/gauravi152/final-data-analytics-project
- Repository: https://github.com/gauravi152/final-data-analytics-project

## Overview

This is an end-to-end data analytics project using Olist datasets, analysis notebooks, a Power BI dashboard, and a final report. The README documents preparation, exploratory analysis, visualization, dashboard development, insights, and recommendations, but the available evidence does not map specific files to stages or establish which files read or produce others. The graph therefore shows the project artifacts and documented capabilities without asserting unsupported data-flow links.

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Source data"]
  node_customers["Customers data"]
  node_items["Order items data"]
  node_payments["Payments data"]
  node_reviews["Reviews data"]
  node_orders["Orders data"]
  node_products["Products data"]
  node_sellers["Sellers data"]
  node_translation["Category translation"]
end

subgraph group_analysis["Analysis"]
  node_task3["Analysis notebook 3"]
  node_task4["Analysis notebook 4"]
  node_task5["Analysis notebook 5"]
end

subgraph group_deliverables["Deliverables"]
  node_dashboard["Power BI dashboard"]
  node_report["Project report"]
end

click node_customers "https://github.com/gauravi152/final-data-analytics-project/blob/main/olist_customers_dataset.csv"
click node_items "https://github.com/gauravi152/final-data-analytics-project/blob/main/olist_order_items_dataset.csv"
click node_payments "https://github.com/gauravi152/final-data-analytics-project/blob/main/olist_order_payments_dataset.csv"
click node_reviews "https://github.com/gauravi152/final-data-analytics-project/blob/main/olist_order_reviews_dataset.csv"
click node_orders "https://github.com/gauravi152/final-data-analytics-project/blob/main/olist_orders_dataset.csv"
click node_products "https://github.com/gauravi152/final-data-analytics-project/blob/main/olist_products_dataset.csv"
click node_sellers "https://github.com/gauravi152/final-data-analytics-project/blob/main/olist_sellers_dataset.csv"
click node_translation "https://github.com/gauravi152/final-data-analytics-project/blob/main/product_category_name_translation.csv"
click node_task3 "https://github.com/gauravi152/final-data-analytics-project/blob/main/Final_Analysis_task3.ipynb"
click node_task4 "https://github.com/gauravi152/final-data-analytics-project/blob/main/Final_Analysis_task4.ipynb"
click node_task5 "https://github.com/gauravi152/final-data-analytics-project/blob/main/Final_Analysis_task5.ipynb"
click node_dashboard "https://github.com/gauravi152/final-data-analytics-project/blob/main/Final_Data_Analytics_Project.pbix"
click node_report "https://github.com/gauravi152/final-data-analytics-project/blob/main/Final_Project_Report.docx"

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_items,node_payments,node_reviews,node_orders,node_products,node_sellers,node_translation toneBlue
class node_task3,node_task4,node_task5 toneAmber
class node_dashboard,node_report toneMint
```

## Components

### Source data

- [Customers data](https://github.com/gauravi152/final-data-analytics-project/blob/main/olist_customers_dataset.csv): `olist_customers_dataset.csv`
- [Order items data](https://github.com/gauravi152/final-data-analytics-project/blob/main/olist_order_items_dataset.csv): `olist_order_items_dataset.csv`
- [Payments data](https://github.com/gauravi152/final-data-analytics-project/blob/main/olist_order_payments_dataset.csv): `olist_order_payments_dataset.csv`
- [Reviews data](https://github.com/gauravi152/final-data-analytics-project/blob/main/olist_order_reviews_dataset.csv): `olist_order_reviews_dataset.csv`
- [Orders data](https://github.com/gauravi152/final-data-analytics-project/blob/main/olist_orders_dataset.csv): `olist_orders_dataset.csv`
- [Products data](https://github.com/gauravi152/final-data-analytics-project/blob/main/olist_products_dataset.csv): `olist_products_dataset.csv`
- [Sellers data](https://github.com/gauravi152/final-data-analytics-project/blob/main/olist_sellers_dataset.csv): `olist_sellers_dataset.csv`
- [Category translation](https://github.com/gauravi152/final-data-analytics-project/blob/main/product_category_name_translation.csv): `product_category_name_translation.csv`

### Analysis

- [Analysis notebook 3](https://github.com/gauravi152/final-data-analytics-project/blob/main/Final_Analysis_task3.ipynb): `Final_Analysis_task3.ipynb`
- [Analysis notebook 4](https://github.com/gauravi152/final-data-analytics-project/blob/main/Final_Analysis_task4.ipynb): `Final_Analysis_task4.ipynb`
- [Analysis notebook 5](https://github.com/gauravi152/final-data-analytics-project/blob/main/Final_Analysis_task5.ipynb): `Final_Analysis_task5.ipynb`

### Deliverables

- [Power BI dashboard](https://github.com/gauravi152/final-data-analytics-project/blob/main/Final_Data_Analytics_Project.pbix): `Final_Data_Analytics_Project.pbix`
- [Project report](https://github.com/gauravi152/final-data-analytics-project/blob/main/Final_Project_Report.docx): `Final_Project_Report.docx`