This folder contains a collection of SQL and Data projects.
BankSQL: This project demonstrates the process of transforming a CSV file into a Looker Dashboard and SQL database. We can run queries on the data, and visualize these queries using Seaborn and Looker.
Additionally, the project generates an HTML file with the Looker dashboard embedded, which can be placed in an AWS S3 bucket for easy access and sharing.
Software: SQL,Seaborn, Python 3.11, VS Code, Jupyter Notebook
Languages: SQL, Python
Modules: Seaborn, Pandas, SQLite3, Matplotlib, Faker
ManhattanRE:This project aims to analyze and visualize Manhattan Rolling Sales Data from November 2022 to October 2023 using Python and Plotly.
Software: SQL,Plotly, Python 3.11, Tableau, VS Code, Jupyter Notebook
Languages: SQL, Python
Modules: Plotly, Pandas, SQLite3
SQL Zillow: Here we analyze Zillow Housing Data to check for highest cost locations, market trends and other patterns.
We will analyze Zillow's Top Tier Home Price Index and look for patterns and analyze data.
Software: SQL,Google Looker, Streamlit, GoogleSheets, Python 3.11, VS Code, Jupyter Notebook
Languages: SQL, Python
Modules: Seaborn, Pandas, SQLite3, Matplotlib
SQL Salary Data:This project is interesting in that it combines Python and SQL while generating fictional data using the Faker module.
We will generate information for a fictional survey which details salaries, survey questions, age and other data to then analyze and look for patterns in the data.
Software: SQL,Seaborn, Python 3.11, VS Code, Jupyter Notebook
Languages: SQL, Python
Modules: Seaborn, Pandas, SQLite3, Matplotlib, Faker