In this project I clean housing data from Nashville, TN in PostgreSQL. By clicking either the title, picture, or button below, you may view my project. The data is now just a little more useful for analysis or visualizations and may be a later project.
In this project, I used PostgreSQL to explore and gather queries on a Covid-19 dataset. Skills used include but are not limited to: Selection, population, updating tables, cleaning columns by seperation, formatting, and common table expressions. The data used is from 2020 to July 2022. The queries were then used and ran in Tableau for visualization purposes(See here).
All Dashboards made with Tableau are housed here.
In this project, I analyze a movie dataset for correlation. Mainly, I was looking for different variables to be correlated strongly with gross income from the movie production. There was a bit of cleaning needed beforehand, which is also included in the Jupyter script.