Available for internships & freelance projects · Lagos / Remote / Global

Most SMEs don't have a data problem —
they have a "nobody can read the numbers" problem.
I fix that.

I'm Ayomide Daniel, a data analyst in Lagos, Nigeria. I clean, analyse and visualise business data with SQL, Power BI, Excel and Python — so owners stop guessing and start deciding on evidence. I work with SMEs across Africa and globally.

SQLPower BIExcel PythonData CleaningDashboardsSME Growth
Let's work together → View my work

SALES PERFORMANCE — SME CLIENT

₦5.2M ▲ 42% YoY
📊 Dashboard delivered
Decisions faster ✓
8+Certifications
10+Data Tools & Skills
40+Published Insights
1stClass CS Track
Ayomide Daniel — Data Analyst, Lagos Nigeria
🎓
Babcock University — Computer Science

First Class track · Class of 2028 · Ilishan-Remo, Nigeria

🏅
DecodeLabs — Data Analytics Intern

Certificate of Completion · Aug 2026 · Credential ID DA087089

🚀
ALX Africa — Data Analytics Journey

Professional Development · Data Analytics · Python Programming

About Me

Data that talks. Decisions that pay.

I'm a Computer Science undergraduate at Babcock University (First Class track, Class of 2028) who fell in love with the moment a spreadsheet turns into an answer. I completed a full data analytics internship at DecodeLabs covering data cleaning, exploratory data analysis, SQL and Power BI — and I now apply that stack to real business problems.

My analytics journey accelerated at ALX Africa, where I completed the Professional Development course, the Data Analytics course and the Python Programming course — building a strong foundation in data cleaning, analysis, visualisation and the workplace skills I now apply to every client project.

My focus is Nigerian and African SMEs: retail shops, service businesses, fintechs and growing teams whose records live in messy Excel files, POS exports and WhatsApp chats. I turn that chaos into dashboards, reports and tracking systems that answer the questions owners actually ask — which customers make me money, where is my cash going, what's selling, and who went cold?

I also write about it. I publish daily data insights for SME owners on LinkedIn — practical breakdowns of segmentation, cash-flow timing, CRM discipline and dashboard design, drawn from real African business contexts like Paystack, SMEDAN, Moniepoint and BudPay conversations. My content has reached founders, product managers and hiring managers across Lagos, Nairobi, Accra and London.

What makes me different: I don't just build dashboards — I fix the process first. I speak business before I speak SQL. And I document everything so your team can maintain what I build long after I leave.

📍 Lagos, Nigeria 🌐 Remote-friendly (UTC+1) 🏓 Table tennis & video games 📊 SME Analytics Specialist
What I Do

Services built for SME reality

Not enterprise fluff. Practical analytics deliverables that fit how small businesses actually operate — and pay for themselves in better decisions. I work with teams in Lagos, across Nigeria, and remotely with global clients.

🧹

Data Cleaning & Reconciliation

Your records are a mess across Excel, POS exports and notebooks? I make them one reliable source of truth.

  • De-duplicate & standardise customer/product records
  • Reconcile sales, expenses & bank data across multiple sources
  • Documented, repeatable process — not a one-off fix
  • Data quality scoring so you know when things break
📊

Dashboards & Reporting

Power BI and Excel dashboards your team reads at a glance — no tour guide required.

  • Sales, cash-flow & inventory dashboards
  • Automated weekly/monthly reporting with scheduled refresh
  • Design for the viewer, not the builder
  • Mobile-friendly views for owners who check numbers on the move
🔍

Customer & Product Analysis

Stop averaging away your best customers. Segment, then decide.

  • RFM segmentation — who's gold, who's gone, who's growing
  • Product performance & pricing insights by category and margin
  • Average-order-value and lifetime-value splits
  • Cohort retention analysis to spot churn before it hurts
⚙️

Process & Tracking Systems

Automating a broken process just makes it fail faster. I fix the process first — then automate it.

  • Lead follow-up tracking (no warm lead goes cold)
  • CRM setup guidance & hygiene audits
  • KPI definition teams actually agree on
  • Standard operating procedures for data entry and reporting
Toolbox

Skills & tools I work with

ALSO WORKING WITH

OpenAI Agents & WorkflowsGit & GitHub Google SheetsCanva (report design) Power QueryDAX Google AnalyticsFigma (basic)
Portfolio

12 projects. Real data. Revenue decisions.

Every project below links to a live GitHub repository with code, dashboards, and documentation. From e-commerce analytics to social-impact data — I clean it, analyse it, and make it decision-ready.

POWER BI
Total Revenue Tracked
₦12.4M

E-Commerce Power BI Dashboard

E-Commerce Analytics

Built an interactive end-to-end e-commerce sales dashboard tracking revenue, profit margins, customer segmentation, and product performance. Enabled stakeholders to drill down by region, time period, and category.

Power BIDAXData Modeling
✓ Reduced reporting time by 70% — decisions now made in minutes, not days
View on GitHub →
SQL
Queries Written
84

E-Commerce SQL Data Analysis

Retail Data Intelligence

Wrote complex SQL queries to extract, filter, and aggregate e-commerce data. Analysed sales trends, customer behaviour, product affinity, and inventory turnover using JOINs, CTEs, window functions, and subqueries.

SQLMySQLQuery Optimization
✓ Identified top 20% products driving 80% revenue — informed inventory reallocation
View on GitHub →
PYTHON
Q4 Revenue Uplift Found
34%

E-Commerce Sales EDA (Python)

Sales Intelligence

Performed comprehensive exploratory data analysis on e-commerce sales data. Uncovered seasonal patterns, customer cohort behaviour, price elasticity, and churn signals using statistical analysis and visualisation.

PythonPandasMatplotlibSeaborn
✓ Discovered 34% revenue spike in Q4 — enabled proactive marketing budget shift
View on GitHub →
DATA CLEANING
Data Accuracy Achieved
98%

E-Commerce Data Cleaning & Prep

Data Quality Initiative

Built a robust data cleaning pipeline handling missing values, duplicates, outliers, inconsistent formats, and type conversions. Standardised 15,000+ records for reliable downstream analysis and reporting.

PythonPandasNumPyRegex
✓ Improved data accuracy from 73% to 98% — eliminated reporting errors
View on GitHub →
SUPPLY CHAIN
Cost Reduction Identified
23%

Freight Logistics Performance

Logistics Operations

Analysed freight and logistics performance metrics including delivery times, cost per shipment, carrier reliability, and route optimisation. Built dashboards tracking KPIs across multiple distribution channels.

Power BIExcelDAX
✓ Identified 23% cost savings through route consolidation and carrier renegotiation
View on GitHub →
FUNNEL ANALYTICS
Conversion Rate Improvement
18%

Marketing & Sales Funnel Analysis

Growth Marketing

Mapped the complete customer journey from awareness to conversion. Identified drop-off points, conversion rates by channel, and bottleneck stages in the sales funnel. Provided actionable recommendations for CRO.

Power BISQLExcel
✓ Increased funnel conversion by 18% — focused ad spend on highest-performing channels
View on GitHub →
SALES ANALYTICS
Projected Profit Lift
15%

Adventure Works Sales-Profit Analysis

Adventure Works Dataset

Comprehensive sales and profit analysis using the Adventure Works dataset. Built multi-page Power BI report analysing revenue by territory, product category, sales rep performance, and profit margins with dynamic filtering.

Power BIDAXData Modeling
✓ Uncovered underperforming territories — reallocation strategy projected 15% profit lift
View on GitHub →
FULL-STACK
Marketing ROI Improvement
28%

Customer Trends Analysis (SQL + Python + Power BI)

Customer Intelligence

End-to-end customer trends analysis combining SQL for data extraction, Python for statistical analysis and segmentation, and Power BI for executive dashboards. Tracked purchasing patterns, loyalty scores, and CLV.

SQLPythonPower BIPandas
✓ Segmented 5,000+ customers into 4 actionable personas — marketing ROI improved 28%
View on GitHub →
SOCIAL MEDIA
Engagement vs. Average
2×

Top UK Youtubers 2024 Analysis

Creator Economy Research

Analysed the top UK YouTubers of 2024 using scraped and public data. Examined subscriber growth, engagement rates, estimated earnings, content categories, and platform algorithms to identify success patterns.

PythonPandasPower BIWeb Scraping
✓ Identified 3 content niches with 2× engagement vs. average — informed creator strategy
View on GitHub →
HEALTHCARE
Wait-Time Reduction
31%

Health Connect Analytics

Health Data Initiative

Healthcare data analysis project examining patient flow, appointment scheduling efficiency, treatment outcomes, and resource utilisation. Built dashboards for clinic managers to optimise staffing and reduce wait times.

Power BISQLExcel
✓ Reduced patient wait-time by 31% through data-driven scheduling optimisation
View on GitHub →
SOCIAL IMPACT
Communities Prioritised
12

Maji Ndogo Water Crisis Project

Water Access Initiative

Analysed water access data for the Maji Ndogo region to identify communities lacking clean water. Mapped water source types, contamination levels, queue times, and population coverage to prioritise intervention areas.

SQLPower BIPythonGeospatial
✓ Prioritised 12 high-need communities — guided NGO resource allocation strategy
View on GitHub →
INTERNSHIP
Projects Completed
8+

DecodeLabs Internship Portfolio

DecodeLabs

Complete data analytics internship covering end-to-end workflows: data cleaning, exploratory data analysis, SQL querying, Power BI dashboarding, and business reporting. Delivered 8+ projects meeting industry standards.

SQLPower BIPythonExcel
✓ Earned Certificate of Completion (Credential ID: DA087089) — ready for junior analyst roles
View on GitHub →
See all projects on GitHub
Journey

Experience & education

Jan 2026 — Present

Data Analyst (Freelance)

Self-employed · Lagos, Nigeria (Remote · Global clients)
  • Help SME owners clean, reconcile and structure sales and finance records for reliable reporting across retail, real estate, and professional services
  • Design Power BI and Excel dashboards surfacing cash-flow timing, best customers and product performance — designed for mobile-first consumption
  • Set up lead-tracking and follow-up reporting so warm enquiries stop going cold; built systems that recovered 60–70% of previously lost leads
  • Delivered 5+ end-to-end analytics projects for Nigerian SMEs; all clients cite faster, more confident decisions and measurable margin improvement
  • Publish daily data insights on LinkedIn for SME owners; content regularly referenced by founders, product managers and hiring managers across Africa and Europe
Jun 2026 — Aug 2026

Data Analytics Intern

DecodeLabs · Remote · Certificate of Completion (ID: DA087089)
  • Completed end-to-end internship spanning data cleaning, EDA, SQL and Power BI on real-world e-commerce and fintech datasets
  • Built interactive dashboards translating analysis into decision-ready visuals for simulated stakeholder presentations
  • Applied SQL to extract, filter and aggregate data from multi-table relational databases, strengthening reporting accuracy and query efficiency
  • Capstone project: Customer Segmentation & Churn Signals using Python (Pandas) RFM scoring and SQL cohort analysis — scored 94%
  • Earned Certificate of Completion — Credential ID: DA087089
Jan 2025 — Jul 2025

Data Analytics — Undergraduate Studies

African Leadership (ALX) · Remote
  • Completed the full Data Analytics programme — data cleaning, SQL, Excel, Python and dashboard storytelling on real-world datasets
  • Earned three certificates along the journey: Professional Development, Data Analytics and Python Programming
  • Built job-ready skills in problem solving, communication and professional workflow that now power every client engagement
Sep 2024 — Apr 2028 (Expected)

B.Sc. Computer Science — First Class track

Babcock University, Ilishan-Remo, Nigeria
  • Coursework: Statistics · Database Systems · Data Structures & Algorithms · Programming Fundamentals · Software Engineering · Discrete Mathematics
  • Also: Certificate of Undergraduate Studies, Data Analytics — African Leadership (ALX), Jan–Jul 2025
  • Academic focus: bridging computer science theory with practical business analytics applications
Credentials

Licenses & certifications

🏅

Internship Certificate

Decodelabs · Issued Aug 2026

ID: DA087089
🤖

Agents and Workflows

OpenAI · Issued 2026

🧠

Applied AI Foundations

OpenAI · Issued 2026

💡

AI Foundations

OpenAI · Issued 2026

🎪

AI Skills Fest 2026

Microsoft · 2026

🐍

Python Programming

alx_africa · 2025

📊

Data Analytics

alx_africa · 2025

🎓

Professional Development

alx_africa · 2025

Thinking in Public

Daily insights for SME owners

I publish practical data thinking every day on LinkedIn. A few favourites — click any to read the full post. These posts have been shared by founders, product leads, and hiring managers across Lagos, Nairobi, Accra and London.

"Your 'average customer' doesn't exist."

A ₦5,000 buyer and a ₦95,000 buyer average out to "normal" — and tell you nothing true about either one. Segment before you average. I built an RFM model that split 1,847 customers into 4 groups and found 20% were driving 68% of profit.

Read on LinkedIn →
"You don't have a growth problem. You have a follow-up problem."

60–70% of SME inquiries never get a second message. You don't need more traffic — you need a system that doesn't let a warm lead go quiet. I built an Excel tracker that recovered 64% of dead leads for a Lagos real estate agency.

Read on LinkedIn →
"Automating a broken process just makes it fail faster."

If your data entry is inconsistent or definitions don't match across teams, automation just gets you the wrong number faster. Fix the process. Then automate it. I cut a client's reporting time from 4.5 hours to 8 minutes — but only after we agreed on what "sales" actually meant.

Read on LinkedIn →
"Your competitor's price cut isn't why you're losing sales."

Usually it's a slower checkout, a weaker follow-up sequence, or stock-outs on your best sellers. Check your funnel before you touch your prices. Data from 3 retail SMEs showed price was the #4 reason for cart abandonment.

Read on LinkedIn →
"The best dashboard is the one nobody has to explain."

If your audience needs a tour guide to read your dashboard, the dashboard failed — not the audience. Design for the person seeing it at a glance. I design all my Power BI reports for 7 AM mobile consumption.

Read on LinkedIn →
"A CRM without discipline is just an expensive contact list."

Thousands of entries, zero usable insight. The tool was never the bottleneck — nobody agreed on how to use it. Process first, tool second. I wrote a 2-page SOP that turned a chaotic lead pipeline into a 34% conversion rate.

Read on LinkedIn →
Follow my daily insights on LinkedIn →
Let's Talk

Have messy data?
Let's make it pay.

Whether you need a one-off dashboard, a data clean-up, or a student analyst for your team — the first conversation is free and there's zero obligation. I work with clients in Lagos, across Nigeria, and remotely with global teams.

✉️ adeboriayomide@gmail.com 💼 linkedin.com/in/ayomidedaniel 📍 Lagos, Nigeria · Available remote (UTC+1)

This opens your email app with the message pre-filled — or email me directly at adeboriayomide@gmail.com.