All data projects
-
Description: The dataset contains bike sales data of a bike shop. The project involved data cleaning and visualization. The project provided insights on bike sales overview by customer demographics - does customer commute distance impact bike purchases? Does customer salaries, educational background influence purchases? What region had the most sales.
-
Skills: Excel - Removing duplicates, Find and Replace to standardize column values, age bracket categorization using nested IF function, Pivot Table, Pivot Chart, Slicers
-
Tool: Microsoft Excel
-
Description: The dataset contains records of COVID-19 cases, deaths and vaccine records by country in 2020-2021. The project involved data loading, data cleaning and preprocessing, and EDA (exploratory data analysis). The EDA provided insights on infection and death rates.
-
Skills: SQL - Joins, CTE's, Temp Tables, Windows Functions, Aggregate Functions, Creating Views, Converting Data Types
-
Tool: Microsoft SQL Server
-
Description: The dataset contains a list of houses sold in Nashville between 2013 and 2019. The project involved data loading, data cleaning and preprocessing.
-
Skills: SQL - Removing duplicates with CTE, populating nulls, splitting columns, standardizing date formats.
-
Tool: Microsoft SQL Server