Data Analyst with 2 years of hands-on experience in SQL, Excel, and BI tools, delivering actionable insights that improve operational efficiency, reduce costs, and support strategic decision-making. Skilled in cleaning, analyzing, and visualizing complex datasets, with a proven ability to translate data into clear business recommendations. Experienced in managing cross-functional projects and aligning analytics with organizational goals.
<aside> 📊
Want to work together?
Send me an email 👇
DM me on X: @jonathan_ify
DM me on LinkedIn: @jonathan ogaziechi
</aside>
$$ \begin {aligned} I've~worked~for: \end {aligned} $$
<aside> 📙
Table of Content
This project focuses on cleaning and analysing housing data using SQL. The primary objective is to prepare the dataset for insightful analysis by addressing inconsistencies, handling missing values, and standardizing data formats. I cleaned the data using DB Browser (SQLite) as well as employed different data cleaning strategies to identify and clean up inconsistencies and anomaly in the dataset that could potentially skew results of analysis.
Photo by Marcus Lenk on Unsplash
Photo by Fusion Medical Animation on Unsplash
Explored COVID-19 dataset https://covid-19.nyc3.digitaloceanspaces.com/ to identify patterns and trends influencing public policy decisions.
Skills:
SQL, Data Cleaning, Insight Reporting
Report
.png)
This project was built entirely in Excel and focused on cleaning, transforming, and analysing bike sales data to answer certain stakeholder questions. I used pivot tables to dig into trends and patterns, then pulled everything together into a clean dashboard. The visualizations were designed to be simple but insightful, making it easy to spot key takeaways and support better business decisions.
This project explores customer behaviour using a telecom dataset to identify key factors driving churn. Through data cleaning, visualization, and segmentation, I uncovered patterns tied to contract types, tenure, pricing, and demographics. The insights informed actionable retention strategies and were presented in a business-ready format tailored for non-technical stakeholders.
Dataset | Jupyter notebook | Slide presentation
This project explored the relationship between video gaming habits and academic performance among Nigerian students. Using survey data from 380 kids, I analysed how screen time affects grades, not to prove gaming is 'good' or 'bad,' but to see what the numbers actually say. I cleaned and visualized the data with Python, then tested common assumptions with statistics. The goal? To move beyond stereotypes and find practical insights for parents and educators navigating screen time decisions.
