Hi, I'm John Ubi
Data Analyst
Turning data into clear insights and better decisions.
I clean, analyze, and visualize data with Power BI, SQL, and Excel to help teams track KPIs, spot trends, and make confident decisions.
About Me
I’m a Data Analyst passionate about transforming data into actionable insights that support informed, data driven decisions. I have hands on experience using SQL, Power BI, Excel, and Power Query to analyze datasets, uncover trends, and build interactive dashboards that communicate findings clearly.
Through my projects and internship experience at Decodelabs, I’ve worked with real world datasets to explore sales performance, customer behaviour, and business trends. My work involves cleaning and analyzing data, developing dashboards, and translating findings into clear insights that support better understanding and decision making.
Skills
Tools I use to make sense of data
A practical toolkit for cleaning, analyzing, visualizing, and communicating data.
Power BI
Interactive dashboards, data visualization, KPI tracking, and reporting.
Excel
Formulas, pivot tables, data organization, analysis, and reporting.
SQL
Querying, filtering, joining, aggregating, and working with structured data.
Power Query
Data cleaning, transformation, merging, and preparing datasets for analysis.
Data Cleaning
Preparing raw datasets by handling inconsistencies, duplicates, and formatting issues.
Data Analysis
Identifying trends, patterns, and insights from business data.
Data Visualization
Presenting data through clear and meaningful charts, reports, and dashboards.
KPI Tracking
Creating and monitoring key metrics to understand business performance.
My Work
Featured Projects
Dashboards and analyses built to drive decisions.
Logistics Operations Performance Dashboard
An interactive dashboard designed to analyze logistics operations, fleet performance, financial performance, safety, and delivery performance.
View ProjectOnline Food Ordering Report
An analysis of customer demographics, ordering behaviour, feedback, and customer characteristics to uncover patterns in how people use an online food ordering service.
View ProjectE-commerce Sales Performance Dashboard
The goal of this project is to explore sales performance across revenue, orders, products, customers, and referral sources, with a focus on identifying trends and performance patterns.
View ProjectExperience
Where I've applied my analytics skills
Data Analyst Intern
Decodelabs
Completed a practical data analytics internship focused on working with data, developing analytical skills, and translating findings into clear business insights.
Worked with Power BI, Excel, Power Query, and SQL to clean, analyze, visualize, and communicate data.
Developed interactive dashboards and strengthened my ability to present data in a clear and decision-focused way.
Education
Academic background
Federal University Oye Ekiti
B.Sc. Accounting
Bachelor’s degree with a foundation in accounting, financial information, business processes, and numerical analysis, complemented by practical development in data analytics and business intelligence.
Certifications
Credentials backing up the skill set
Data Analytics Certification
Tech Sphere Academy
Completed training focused on data analysis, visualization, business intelligence, and practical analytical techniques.
Contact
Let's talk about your data
Have a role, project, or dataset you'd like a second set of eyes on? I'd love to hear from you.
Send me a message
Have a question, opportunity, or project in mind? Send me a message and I’ll get back to you.