This repository contains the data analysis, visualization and price modelling of the Nashville AirBnB dataset to gain valuable insights and create a better understanding of the AirBnB ecosystem in Nashville, Tennessee for all stakeholders involved.

Honoring the legacy of Nashville public access star Joey Bowker.

🚍🗺 Bus tracking for Nashville's WeGo Public Transit

⚡️🗺 Get reported power outages in Nashville.

📰🤖 Top local news from Nashville media outlet RSS feeds

This project focuses on cleaning and standardizing a real-world dataset on Nashville housing transactions. The key steps include standardizing date formats, filling in missing values, breaking out addresses into individual components, standardizing categorical data, removing duplicates, and dropping unused columns.

Web app to view cemetery information for Nashville, Tennessee.

Website for the Bikeshed.

Data Analysis Projects of Covid19 and Nashville Housing, using SQL, EXCEL, Tablau.

The SQL Data Cleaning Project focuses on enhancing the quality and structure of the Nashville Housing dataset stored in the Portfolio Project database. The project involves a series of SQL queries and updates to address data inconsistencies, standardize formats, and enrich the dataset's completeness.

In this SQL file, I perform the cleaning of the data on the housing in Nashville, Tennessee, such as populating empty rows with info from identical ones, breaking down address into more usable format (city, state), deleting duplicates, etc.

Nashville visitors' guide

This is the class website for the Full-Stack Cohort #44 of Nashville Software School.

The website for Renters Union Nashville

Sown was developed for my Front End Capstone at Nashville Software School. It enables users to catalog his or her own seed collection, seed information, and organize said seeds into collections of their own creation.

BikeShed Dashboards

Skills used: Joins, CTE's, Aggregate Functions, Creating Views, Converting Data Types using MS SQL Server Management Studio

NSS Midcourse Project

Project within data analysis intertwined to housing market in Nashville. Data cleaning with Microsoft SQL Server.

MUSic ThEory for MIdi