# nayankumar746/pizza-sales-analysis architecture

> Architecture diagram of the GitHub repository nayankumar746/pizza-sales-analysis, 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/nayankumar746/pizza-sales-analysis
- Repository: https://github.com/nayankumar746/pizza-sales-analysis

## Overview

This repository documents a 2015 pizza-sales analysis: sales data is checked and analyzed with SQL, then presented in an interactive Power BI dashboard for decisions about demand, staffing, and menu performance. The README identifies the dataset, SQL documentation, and dashboard, and describes their relationship; no source excerpts were available to verify implementation details beyond that documentation.

Main entry points: [`pizza_dasboard.pbix`](https://github.com/nayankumar746/pizza-sales-analysis/blob/main/pizza_dasboard.pbix) (Two-Page Dashboard), [`Pizza_Sales_SQL_Qurries.doc`](https://github.com/nayankumar746/pizza-sales-analysis/blob/main/Pizza_Sales_SQL_Qurries.doc) (KPI and Trend Queries), [`pizza_sales_excel_file.xlsx`](https://github.com/nayankumar746/pizza-sales-analysis/blob/main/pizza_sales_excel_file.xlsx) (2015 Sales Dataset)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Sales Data"]
  node_sales_data["2015 Sales Dataset"]
end

subgraph group_analysis["SQL Analysis"]
  node_sql_analysis["KPI and Trend Queries"]
end

subgraph group_reporting["Interactive Reporting"]
  node_dashboard["Two-Page Dashboard"]
end

node_owner(("Restaurant Owner"))
node_decisions["Business Decisions"]

node_sales_data -->|"analyzes"| node_sql_analysis
node_sql_analysis -->|"provides KPIs"| node_dashboard
node_owner -->|"explores"| node_dashboard
node_dashboard -->|"informs"| node_decisions

click node_sales_data "https://github.com/nayankumar746/pizza-sales-analysis/blob/main/pizza_sales_excel_file.xlsx"
click node_sql_analysis "https://github.com/nayankumar746/pizza-sales-analysis/blob/main/Pizza_Sales_SQL_Qurries.doc"
click node_dashboard "https://github.com/nayankumar746/pizza-sales-analysis/blob/main/pizza_dasboard.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_sales_data toneBlue
class node_sql_analysis toneAmber
class node_dashboard toneMint
class node_owner,node_decisions toneIndigo
```

## Components

### Sales Data

- [2015 Sales Dataset](https://github.com/nayankumar746/pizza-sales-analysis/blob/main/pizza_sales_excel_file.xlsx): `pizza_sales_excel_file.xlsx`

### SQL Analysis

- [KPI and Trend Queries](https://github.com/nayankumar746/pizza-sales-analysis/blob/main/Pizza_Sales_SQL_Qurries.doc): `Pizza_Sales_SQL_Qurries.doc`

### Interactive Reporting

- [Two-Page Dashboard](https://github.com/nayankumar746/pizza-sales-analysis/blob/main/pizza_dasboard.pbix): `pizza_dasboard.pbix`

### Other components

- **Restaurant Owner**
- **Business Decisions**

## Connections

- 2015 Sales Dataset → KPI and Trend Queries: analyzes
- KPI and Trend Queries → Two-Page Dashboard: provides KPIs
- Restaurant Owner → Two-Page Dashboard: explores
- Two-Page Dashboard → Business Decisions: informs