[ patterned.by.adrianne ]
A collection of my data projects, from cleaning and visualization to full capstone case studies.
Solved a theft case using SQL by filtering suspects and using joins to validate the culprit through interview data.
Solved a fictional murder case using SQL queries, joins, filters, and evidence-based reasoning across multiple relational tables.
Data analysis of smart device usage trends for Bellabeat using R, RStudio, tidyverse (dplyr, ggplot2), and public Kaggle dataset.
Data visualization using Tableau.
Performed cleaning and normalization on an automotive dataset from 1985 using SQL queries.
Processed messy hotel bookings dataset using the R language and RStudio/Posit Cloud.
Data cleaning using the spreadsheet method.