How alextheanalyst/portfolioprojects works
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 Housing dashboard
Components 16
Interactive dashboard
- Housing dashboard
app.py - Dashboard starter
app_starting_code.py
SQL projects
- COVID exploration
COVID Portfolio Project - Data Exploration.sql - Data cleaning
Data Cleaning Portfolio Project Queries.sql - Tableau queries
Tableau Portfolio Project SQL Queries.sql
Notebook projects
- Amazon scraper
Amazon Web Scraper Project.ipynb - API extraction
Automate API Extraction + Appending Data + Extra -- Project.ipynb - Movie analysis
Movie Portfolio Project.ipynb
Project data
- COVID deaths
CovidDeaths.xlsx - COVID vaccinations
CovidVaccinations.xlsx - YouTube statistics
Global YouTube Statistics.csv - Nashville housing data
Nashville Housing Data for Data Cleaning.xlsx - Nashville data copy
Nashville Housing Data for Data Cleaning (reuploaded).xlsx - Tableau joins data
Tableau Joins File.xlsx - Housing app archive
us-housing-app.zip
Other components
- Portfolio user
Connections 1
- Portfolio user → Housing dashboard: uses controls
app.py