# shorya22/data-analytics-projects architecture

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

- Interactive diagram: https://gitdiagram.com/shorya22/data-analytics-projects
- Repository: https://github.com/shorya22/data-analytics-projects

## Overview

##### Main Components
- Data Sources – For example, the Amazon Sales Analysis project uses CSV files (“Amazon Sales data.csv”) while the Danny’s Diner case study includes an SQL script (“Case Study #1 - Danny's Diner.sql”) which indicates the data is being extracted from a database.
- Data Processing/Analysis Layers – Both projects utilize Jupyter notebooks (”.ipynb”) and Python scripts for performing data cleaning, transformation, and analysis. These are your ETL/Data Processing engines.
- Visualization & Reporting Layers – Each project produces outputs via Power BI reports (files with .pbix extensions), HTML exports, and PDF reports. These represent the final dashboards or static reports for business insights.
- Intermediate and Supporting Artifacts – Include documentation (the README, PDF project reports) that provide context, and additional deliverable files which attest to various stages of the analysis processes.

##### Relationships and Interactions
- From the Data Processing components, show directional flows going into the Reporting/Visualization components, which include Power BI and exported reports (pdf, html).
- Optionally, illustrate that documentation and project reports provide feedback and validation loops for the analytics process.

##### Architectural Patterns and Technologies
- The separation of concerns is evident – raw data ingestion, processing/analytics, and final reporting.
- Technologies: SQL (for data extraction/manipulation), Python (for processing and automation in Jupyter notebooks), and Power BI (for advanced visualizations). Emphasize this multi-tool integration.
- It reflects an end-to-end analytics pipeline where each project follows a similar modular workflow.

##### Essential Architectural Elements
- Processing step (start-to-finish pipeline) so that it’s clear how raw data is transformed into business insights.
- To include labels that clearly indicate the type of file or tool (e.g., “CSV” for data file, “Jupyter Notebook” for scripts, “Power BI Report” for visualizations).

## Diagram (Mermaid)

```mermaid
flowchart TD
    %% Amazon Sales Data Pipeline
    subgraph "Amazon Sales Data Pipeline"
        amazonDataSource["Amazon Sales data.csv"]:::datasrc
        amazonProcessing["Analyzing Amazon Sales data.ipynb"]:::processing
        amazonProcessingSupporting1["Amazon Sales data_Python.pdf"]:::processing
        amazonProcessingSupporting2["Project 1_Analyzing Amazon Sales data.pdf"]:::processing
        amazonReportingPBIX["Amazon Sales data.pbix"]:::reporting
        amazonReportingHTML["Analyzing Amazon Sales data.html"]:::reporting
        amazonReportingOutput1["Amazon Sales Analysis Final Project.pdf"]:::reporting
        amazonReportingOutput2["Amazon Sales data_Power BI.pdf"]:::reporting
    end

    %% Danny's Diner Pipeline
    subgraph "Danny's Diner Pipeline"
        dannyDataSource["Case Study #1 - Danny's Diner.sql"]:::datasrc
        dannyProcessing["Case Study #1 - Danny's Diner.ipynb"]:::processing
        dannyProcessingSupporting1["Danny's Dinner Python Ananlyis.pdf"]:::processing
        dannyProcessingSupporting2["Danny's Dinner SQL Challenge.pdf"]:::processing
        dannyReportingPBIX["Danny's Dinner Power BI Report.pbix"]:::reporting
        dannyReportingSupporting["Danny's Dinner Power BI Report.pdf"]:::reporting
    end

    %% Documentation
    readme["README.md"]:::doc

    %% Data Flow for Amazon Sales Pipeline
    amazonDataSource -->|"flows_to"| amazonProcessing
    amazonProcessing -->|"supports"| amazonProcessingSupporting1
    amazonProcessing -->|"supports"| amazonProcessingSupporting2
    amazonProcessing -->|"generates"| amazonReportingPBIX
    amazonProcessing -->|"generates"| amazonReportingHTML
    amazonReportingPBIX -->|"accompanies"| amazonReportingOutput1
    amazonReportingPBIX -->|"accompanies"| amazonReportingOutput2
    amazonProcessing -->|"documented_in"| readme

    %% Data Flow for Danny's Diner Pipeline
    dannyDataSource -->|"flows_to"| dannyProcessing
    dannyProcessing -->|"supports"| dannyProcessingSupporting1
    dannyProcessing -->|"supports"| dannyProcessingSupporting2
    dannyProcessing -->|"generates"| dannyReportingPBIX
    dannyReportingPBIX -->|"accompanies"| dannyReportingSupporting
    dannyProcessing -->|"documented_in"| readme

    %% Click Events for Amazon Sales Data Pipeline
    click amazonDataSource "https://github.com/shorya22/data-analytics-projects/blob/main/Analyzing Amazon Sales data/Amazon Sales data.csv"
    click amazonProcessing "https://github.com/shorya22/data-analytics-projects/blob/main/Analyzing Amazon Sales data/Analyzing Amazon Sales data.ipynb"
    click amazonProcessingSupporting1 "https://github.com/shorya22/data-analytics-projects/blob/main/Analyzing Amazon Sales data/Amazon Sales data_Python.pdf"
    click amazonProcessingSupporting2 "https://github.com/shorya22/data-analytics-projects/blob/main/Analyzing Amazon Sales data/Project 1_Analyzing Amazon Sales data.pdf"
    click amazonReportingPBIX "https://github.com/shorya22/data-analytics-projects/blob/main/Analyzing Amazon Sales data/Amazon Sales data.pbix"
    click amazonReportingHTML "https://github.com/shorya22/data-analytics-projects/blob/main/Analyzing Amazon Sales data/Analyzing Amazon Sales data.html"
    click amazonReportingOutput1 "https://github.com/shorya22/data-analytics-projects/blob/main/Analyzing Amazon Sales data/Amazon Sales Analysis Final Project.pdf"
    click amazonReportingOutput2 "https://github.com/shorya22/data-analytics-projects/blob/main/Analyzing Amazon Sales data/Amazon Sales data_Power BI.pdf"

    %% Click Events for Danny's Diner Pipeline
    click dannyDataSource "https://github.com/shorya22/data-analytics-projects/blob/main/Case Study #1 - Danny's Diner/Case Study #1 - Danny's Diner.sql"
    click dannyProcessing "https://github.com/shorya22/data-analytics-projects/blob/main/Case Study #1 - Danny's Diner/Case Study #1 - Danny's Diner.ipynb"
    click dannyProcessingSupporting1 "https://github.com/shorya22/data-analytics-projects/blob/main/Case Study #1 - Danny's Diner/Danny's Dinner Python Ananlyis.pdf"
    click dannyProcessingSupporting2 "https://github.com/shorya22/data-analytics-projects/blob/main/Case Study #1 - Danny's Diner/Danny's Dinner SQL Challenge.pdf"
    click dannyReportingPBIX "https://github.com/shorya22/data-analytics-projects/blob/main/Case Study #1 - Danny's Diner/Danny's Dinner Power BI Report.pbix"
    click dannyReportingSupporting "https://github.com/shorya22/data-analytics-projects/blob/main/Case Study #1 - Danny's Diner/Danny's Dinner Power BI Report.pdf"

    %% Click Event for Documentation
    click readme "https://github.com/shorya22/data-analytics-projects/blob/main/README.md"

    %% Styles
    classDef datasrc fill:#ADD8E6,stroke:#000,stroke-width:1px;
    classDef processing fill:#90EE90,stroke:#000,stroke-width:1px;
    classDef reporting fill:#FFA500,stroke:#000,stroke-width:1px;
    classDef doc fill:#D3D3D3,stroke:#000,stroke-width:1px;
```
