HNG i13 Finalist · Top 450 of 12,362

Mubarak Lawal

Your data has answers. I find them.

I'm a

Your data has answers. I find them. I transform complex datasets into clear, actionable insights, building dashboards and BI solutions that drive smarter business decisions and reveal opportunities others miss.

Mubarak Lawal - Data Analyst
Profile Image

Mubarak Lawal

Data Analyst | HNG i13 Finalist

Get to Know Me

From 12,362 to 450. I Made the Cut. Here's Why.

I recently completed the HNG Internship 13 Data Analytics track, an intensive program where over 12,000 people started, and only 450 made it to the end. I was one of them, ranking 2nd out of 46 finalists in the palm oil investment profitability analysis.

But credentials aside, what I actually do is find the stories hiding in your data. I bridge the gap between raw numbers and strategic action, building dashboards and reports that don't just look good, but drive real business decisions.

15+
Projects Delivered
Top 3.6%
HNG i13 Finalist
2nd
Palm Oil Analysis Rank
Specialization Data Analysis & Business Intelligence
Availability Immediately Available
Education Certified AAT, ICAN B.Sc Economics, OAU (First Class Track)
Languages English, Yoruba, Arabic

Top 450 of 12,362 (HNG)

Projects & Dashboards

HNG Stages Completed

Certifications

Skills

I work across the full data lifecycle, from extracting and cleaning messy datasets to building interactive dashboards that executives actually use. Here's my toolkit.

Data Analysis & Visualization

Power BI & DAX

Interactive dashboards, complex DAX measures, data modeling, Power BI Service deployment. Built dashboards analyzing 150+ years of data.

Excel & Power Query

Advanced formulas, pivot tables, Power Query ETL, automated reporting, financial modeling.

Data Storytelling

Translating complex findings into clear narratives for stakeholders. Presented insights to mentors under live Q&A pressure.

Exploratory Data Analysis

Statistical summaries, trend identification, outlier detection, pattern recognition.

Data Engineering & Scripting

SQL (PostgreSQL, MySQL)

CTEs, window functions, complex JOINs, subqueries, data aggregation. Wrote 8 complex business queries for HNG Ride analysis.

Python (Pandas, NumPy, Matplotlib)

Data cleaning, transformation, analysis, visualization, and basic ML modeling in Jupyter Notebooks.

ETL & Data Cleaning

Extract, Transform, Load processes. Cleaned datasets with 10,000+ records, handling duplicates, missing values, and inconsistent formats.

Git & Version Control

Repository management, collaborative workflows, code versioning on GitHub.

Resume

From intensive internship programs to real-world business analysis. Here's my journey in data analytics.

Profile

Professional Summary

Data Analyst and HNG Internship 13 Finalist with proven ability to deliver insights under pressure. I ranked 2nd out of 46 finalists in investment profitability analysis and completed 10 intensive stages covering SQL, Python, Power BI, machine learning, and live presentations. I transform messy data into clear business decisions.

Contact

Core Tools

SQL
Power BI
Excel & Power Query
Python

Soft Skills

Data Storytelling
Business Acumen
Problem Solving
Communication

Experience

Data Analyst Intern

October 2025 - December 2025

HNG Internship 13 (Remote)

  • Completed 10 intensive stages of data analysis, finishing in the Top 450 out of 12,362 participants (Top 3.6%).
  • Ranked 2nd out of 46 finalists in palm oil investment profitability analysis, recommended a 300-350 hectare plantation in Edo State with projected annual profits exceeding ₦1 billion.
  • Built interactive Power BI dashboard analyzing 150+ years of international football matches (1872-2025), tracking team performance, home advantage trends, and match patterns across 40,000+ games.
  • Performed SQL business analysis on ride-sharing dataset (10,000+ records), writing 8 complex queries to identify top drivers, calculate retention rates, compare quarterly revenue, and determine bonus eligibility.
  • Conducted geospatial outlier detection on Nigerian election data using proximity-based algorithms to flag polling units with statistically anomalous voting patterns.
  • Performed network analysis on large-scale MOOC dataset using Python (NetworkX), developing 6 research questions and uncovering insights about user engagement patterns.
  • Built machine learning model from HNG Slack workspace data, extracting insights and deploying interactive dashboard for stakeholder review.
  • Defended analyses in live presentations with mentors, adapting to unexpected questions and demonstrating deep understanding of methodology.

Data Analyst, Job Simulation

September 2024 - January 2025

Accenture North America (Virtual)

  • Analyzed 7 social media datasets for a client engagement project, identifying user behavioral trends and content performance patterns.
  • Used Excel and SQL to clean, model, and aggregate data from multiple sources, creating a unified dataset for strategic analysis.
  • Developed data narrative and presented actionable recommendations through professional PowerPoint deck and video presentation.

Data Analyst Fellow

February 2024 - August 2024

3MTT Nigeria (Federal Government Initiative)

  • Completed 6-month intensive training program in data analysis and visualization as part of Nigeria's 3 Million Technical Talent initiative.
  • Developed proficiency in SQL, Power BI, Excel, and Python through hands-on projects and assessments.
  • Built multiple portfolio projects demonstrating end-to-end data analysis workflow from data cleaning to insight presentation.

Education

Bachelor of Science in Economics

2022 - 2026 (Expected)

Obafemi Awolowo University, Ile-Ife

Currently maintaining First Class standing.Specializing in Econometrics and Statistical Theory with focus on quantitative analysis and data-driven decision making.

Associate Accounting Technician (AAT)

2022 - 2024

Institute of Chartered Accountants of Nigeria (ICAN)

Certified in accounting fundamentals, financial reporting, and business analysis. This provides a strong foundation..

Certifications

HNG Internship 13 Finalist, Data Analytics Track

December 2025

Top 450 of 12,362 participants. Completed 10 stages covering SQL, Python, Power BI, machine learning, and business presentations.

Data Analysis & Visualization, 3MTT Nigeria

August 2024

Data Analytics Job Simulation, Accenture North America

January 2025

Certified Data Analyst, DataCamp

September 2024

Portfolio

Here's a selection of my work, from interactive Power BI dashboards to SQL analysis and Python projects. Each project demonstrates how I turn raw data into actionable insights.

  • All Projects
  • Power BI
  • Excel
  • SQL
  • Python
Retail Analytics Dashboard
Power BI

Retail Analytics Dashboard

Bike Purchase Analysis
Excel

Bike Purchase Analysis

ShopSmart SQL Analysis
SQL

ShopSmart SQL Analysis

AgriSense Python Dashboard
Python

AgriSense Analytics

Sales Performance Dashboard
Power BI

Sales Performance Dashboard

Crime Activity Analysis
Excel

Crime Activity Analysis

Let's Work Together

Ready to turn your data into decisions? I'm available for freelance projects, contract work, and full-time remote opportunities.

Contact Info

I collaborate with teams across time zones to deliver actionable, business-ready analytics. Let's talk about your data challenges.

Location

Remote | Lagos, Nigeria

Open To

Freelance · Contract · Part-time · Full-time Remote

Response Time

Usually within 24 hours

Email

Show email

Send a Message

Tell me about your project or opportunity. I'll get back to you within 24 hours.

Thanks! Your message has been sent. I'll get back to you within 24 hours.
Something went wrong. Please try again or email me directly.