# alextheanalyst/portfolioprojects architecture

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

- Interactive diagram: https://gitdiagram.com/alextheanalyst/portfolioprojects
- Repository: https://github.com/alextheanalyst/portfolioprojects

## Overview

This repository is a portfolio of independent data-analysis projects, not one integrated application. Its artifacts span SQL explorations, notebook analyses, datasets, and a US housing dashboard. A user can select a state and date range in the Shiny dashboard to view housing prices, inventory, and new listings as charts or tables. The README describes the portfolio broadly but does not document links among projects; aside from the dashboard interaction, the graph therefore shows no inferred data or execution flows.

Main entry points: [`app.py`](https://github.com/alextheanalyst/portfolioprojects/blob/main/app.py) (Housing dashboard)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_dashboards["Interactive dashboard"]
  node_housing_app["Housing dashboard<br/>[app.py]"]
  node_app_starter["Dashboard starter"]
end

subgraph group_sql["SQL projects"]
  node_covid_sql["COVID exploration"]
  node_cleaning_sql["Data cleaning"]
  node_tableau_sql["Tableau queries"]
end

subgraph group_notebooks["Notebook projects"]
  node_amazon_notebook["Amazon scraper"]
  node_api_notebook["API extraction"]
  node_movie_notebook["Movie analysis"]
end

subgraph group_data["Project data"]
  node_covid_deaths["COVID deaths<br/>[CovidDeaths.xlsx]"]
  node_covid_vaccinations["COVID vaccinations"]
  node_youtube_stats["YouTube statistics"]
  node_nashville_data["Nashville housing data"]
  node_nashville_data_copy["Nashville data copy"]
  node_tableau_data["Tableau joins data"]
  node_housing_archive["Housing app archive<br/>[us-housing-app.zip]"]
end

node_user(("Portfolio user"))

node_user -->|"uses controls"| node_housing_app

click node_housing_app "https://github.com/alextheanalyst/portfolioprojects/blob/main/app.py"
click node_app_starter "https://github.com/alextheanalyst/portfolioprojects/blob/main/app_starting_code.py"
click node_covid_sql "https://github.com/alextheanalyst/portfolioprojects/blob/main/COVID%20Portfolio%20Project%20-%20Data%20Exploration.sql"
click node_cleaning_sql "https://github.com/alextheanalyst/portfolioprojects/blob/main/Data%20Cleaning%20Portfolio%20Project%20Queries.sql"
click node_tableau_sql "https://github.com/alextheanalyst/portfolioprojects/blob/main/Tableau%20Portfolio%20Project%20SQL%20Queries.sql"
click node_amazon_notebook "https://github.com/alextheanalyst/portfolioprojects/blob/main/Amazon%20Web%20Scraper%20Project.ipynb"
click node_api_notebook "https://github.com/alextheanalyst/portfolioprojects/blob/main/Automate%20API%20Extraction%20%2B%20Appending%20Data%20%2B%20Extra%20--%20Project.ipynb"
click node_movie_notebook "https://github.com/alextheanalyst/portfolioprojects/blob/main/Movie%20Portfolio%20Project.ipynb"
click node_covid_deaths "https://github.com/alextheanalyst/portfolioprojects/blob/main/CovidDeaths.xlsx"
click node_covid_vaccinations "https://github.com/alextheanalyst/portfolioprojects/blob/main/CovidVaccinations.xlsx"
click node_youtube_stats "https://github.com/alextheanalyst/portfolioprojects/blob/main/Global%20YouTube%20Statistics.csv"
click node_nashville_data "https://github.com/alextheanalyst/portfolioprojects/blob/main/Nashville%20Housing%20Data%20for%20Data%20Cleaning.xlsx"
click node_nashville_data_copy "https://github.com/alextheanalyst/portfolioprojects/blob/main/Nashville%20Housing%20Data%20for%20Data%20Cleaning%20(reuploaded).xlsx"
click node_tableau_data "https://github.com/alextheanalyst/portfolioprojects/blob/main/Tableau%20Joins%20File.xlsx"
click node_housing_archive "https://github.com/alextheanalyst/portfolioprojects/blob/main/us-housing-app.zip"

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_housing_app,node_app_starter,node_user toneBlue
class node_covid_sql,node_cleaning_sql,node_tableau_sql toneAmber
class node_amazon_notebook,node_api_notebook,node_movie_notebook toneMint
class node_covid_deaths,node_covid_vaccinations,node_youtube_stats,node_nashville_data,node_nashville_data_copy,node_tableau_data,node_housing_archive toneRose
```

## Components

### Interactive dashboard

- [Housing dashboard](https://github.com/alextheanalyst/portfolioprojects/blob/main/app.py): `app.py`
- [Dashboard starter](https://github.com/alextheanalyst/portfolioprojects/blob/main/app_starting_code.py): `app_starting_code.py`

### SQL projects

- [COVID exploration](https://github.com/alextheanalyst/portfolioprojects/blob/main/COVID%20Portfolio%20Project%20-%20Data%20Exploration.sql): `COVID Portfolio Project - Data Exploration.sql`
- [Data cleaning](https://github.com/alextheanalyst/portfolioprojects/blob/main/Data%20Cleaning%20Portfolio%20Project%20Queries.sql): `Data Cleaning Portfolio Project Queries.sql`
- [Tableau queries](https://github.com/alextheanalyst/portfolioprojects/blob/main/Tableau%20Portfolio%20Project%20SQL%20Queries.sql): `Tableau Portfolio Project SQL Queries.sql`

### Notebook projects

- [Amazon scraper](https://github.com/alextheanalyst/portfolioprojects/blob/main/Amazon%20Web%20Scraper%20Project.ipynb): `Amazon Web Scraper Project.ipynb`
- [API extraction](https://github.com/alextheanalyst/portfolioprojects/blob/main/Automate%20API%20Extraction%20%2B%20Appending%20Data%20%2B%20Extra%20--%20Project.ipynb): `Automate API Extraction + Appending Data + Extra -- Project.ipynb`
- [Movie analysis](https://github.com/alextheanalyst/portfolioprojects/blob/main/Movie%20Portfolio%20Project.ipynb): `Movie Portfolio Project.ipynb`

### Project data

- [COVID deaths](https://github.com/alextheanalyst/portfolioprojects/blob/main/CovidDeaths.xlsx): `CovidDeaths.xlsx`
- [COVID vaccinations](https://github.com/alextheanalyst/portfolioprojects/blob/main/CovidVaccinations.xlsx): `CovidVaccinations.xlsx`
- [YouTube statistics](https://github.com/alextheanalyst/portfolioprojects/blob/main/Global%20YouTube%20Statistics.csv): `Global YouTube Statistics.csv`
- [Nashville housing data](https://github.com/alextheanalyst/portfolioprojects/blob/main/Nashville%20Housing%20Data%20for%20Data%20Cleaning.xlsx): `Nashville Housing Data for Data Cleaning.xlsx`
- [Nashville data copy](https://github.com/alextheanalyst/portfolioprojects/blob/main/Nashville%20Housing%20Data%20for%20Data%20Cleaning%20(reuploaded).xlsx): `Nashville Housing Data for Data Cleaning (reuploaded).xlsx`
- [Tableau joins data](https://github.com/alextheanalyst/portfolioprojects/blob/main/Tableau%20Joins%20File.xlsx): `Tableau Joins File.xlsx`
- [Housing app archive](https://github.com/alextheanalyst/portfolioprojects/blob/main/us-housing-app.zip): `us-housing-app.zip`

### Other components

- **Portfolio user**

## Connections

- Portfolio user → Housing dashboard: uses controls (evidence: `app.py`)