Open to Data Analyst roles & internships

Shobule

Data Analyst based in Lagos, Nigeria. I turn messy operational data into dashboards people actually use — built on years of reading the floor first, in logistics, hospitality, and manufacturing.

View Projects → Get in Touch
0
Dashboards Built
0
Core Tools
0
Rows Cleaned
₦74M+
Revenue Analyzed
Career Path
Machine Operator
Production & process discipline
Bartender
Fast, people-facing decisions
Logistics
Operations & supply chain data
Data Analyst
Self-taught, portfolio-driven
About

From the floor to the spreadsheet

I didn't start in data. I spent years in logistics, bartending, and machine operation — jobs where you learn fast that decisions are only as good as the numbers behind them. That's what pulled me into analytics: I wanted to be the person building the numbers, not just reacting to them.

I'm now a self-taught, entry-level Data Analyst based in Lagos, building a portfolio project by project — from raw, messy data to Power Query cleaning, pivot tables, and dashboards that hold up to scrutiny. I'm comfortable in advanced Excel and MySQL, and currently expanding into Power BI.

I'm actively looking for a Data Analyst internship or entry-level role where I can keep learning fast and shipping real, useful work.

Location
Lagos, Nigeria
Focus
Excel Dashboards · SQL · Data Cleaning
Background
Logistics, Hospitality, Manufacturing
Currently
Building portfolio, applying for internships
Learning
Power BI
Skills

Toolkit

Tool
Category
Proficiency
Excel (Advanced)
Analysis
Power Query
Data Cleaning / ETL
Pivot Tables & Dashboards
Reporting
XLOOKUP / INDEX-MATCH
Formulas
MySQL / MySQL Workbench
SQL & Databases
Power BI
Visualization
Projects

Selected work

Sales Analytics Dashboard

Full Excel dashboard built from a raw Orders dataset (Naira currency). Power Query cleaning, KPI cards for revenue, orders, AOV, profit margin, and return rate, with pivot tables broken out by product, region, salesperson, time, and customer.

Power Query Pivot Tables PivotCharts
5 KPI Cards
Power BI Sales Dashboard

End-to-end Power BI dashboard covering sales, profit, order volume, and customer/employee performance, with a relational data model connecting sales, customer, product, and employee tables.

Power BI DAX Data Modeling
₦483K profit tracked
Nigerian Retail Sales Dashboard

Superstore-style retail dataset (~1,200 rows). XLOOKUP-based customer segmentation, return rate calculations, and a slicer-connected pivot chart dashboard. Beverages led as top category, Walk-in as top channel.

XLOOKUP Slicers Segmentation
₦74M+ Revenue
MySQL-to-Excel Reporting Pipeline

Connected Excel to a MySQL database, loaded and cleaned CSV data (currency symbols, date formats), ran analytical queries in MySQL Workbench, and exported clean results back into Excel for reporting.

MySQL SQL Queries Data Cleaning
End-to-End ETL
Employee Data Management Workbook

HR-style workbook with XLOOKUP-based bonus rates, DATEDIF tenure calculations, conditional formatting, SUMIF/COUNTIF summaries, and a quarterly performance chart.

XLOOKUP DATEDIF Conditional Formatting
Portfolio-Rated
Contact

Let's work together

Open to Data Analyst internships and entry-level roles — remote or Lagos-based.

✉ shobulesegun1@gmail.com in LinkedIn ⌘ GitHub