OLABODE PRECIOUS
PORTFOLIO

Data analyst skilled Excel,SQL and Tableu @Bodetheanalyst

data cleaning in SQL

Project Overview
Raw data is rarely ready for analysis, In this project, I took a messy dataset of housing market transactions and transformed it into a structured, reliable format. The goal was to ensure data integrity and make the dataset analysis-ready by resolving common issues like inconsistent formatting, missing values, and duplicate entries.

DATA EXPLORATION IN SQL

Public health data, while abundant, is often fragmented and inconsistent across different jurisdictions. In this project, I cleaned and prepared a comprehensive COVID-19 dataset (tracking deaths and vaccinations) for analysis. My primary objective was to transform raw, daily-reported figures into a high-integrity database suitable for global trend modeling and comparative study.

TABLEU PROJECT

King County Housing Market Analysis An end-to-end data visualization project using Tableau Public to track and analyze residential real estate trends in King County, WA. I transformed raw housing data into actionable insights, featuring a dynamic calendar view for price fluctuations and a condition-based heatmap to evaluate property value drivers.

EXCEL PROJECT

In this project, I processed a dataset of over 1,000 customer records for a bike retail business. The raw data contained several inconsistencies and noisy attributes that hindered accurate reporting. I performed a comprehensive cleanup to ensure the data was structured for high-level pivot table analysis and executive dashboarding.

TABLEU PROJECT

This dashboard provides a high-level view of the global pandemic impact, focusing on mortality rates and infection trends across continents. The project demonstrates my ability to manage large-scale datasets and present critical public health information clearly.

Location

Fct-Abuja

Phone

(+234) 07068599659

Email

olabodeprecious@gmail.com

Social