Orherime Betty Ejakpovi

Data Analyst | Financial & Operational Analytics

Data Analyst with 10+ years of experience across finance, project management and business operations in Nigeria — including a CFO role — now applying that judgment to Excel, SQL and Power BI. I turn messy data into dashboards and recommendations that leadership actually acts on. My flagship analytics projects examine anaemia among Nigerian women and children using 2018 Demographic and Health Survey (NDHS) data.

10+years in finance and operations
4,415anaemia cases analysed from 33,924 survey records
100%on-time project delivery at Swiftdorf
5relational SQL tables designed

Projects

Anaemia Among Women in Nigeria: Public Health Analysis

Power BIExcelData CleaningData VisualizationHealthcare AnalyticsNDHS 2018

Problem. Anaemia affects women's health and maternal outcomes, but cases are not spread evenly across communities. Which groups carry the most cases, and where are the gaps in iron supplementation?

What I did

  • Prepared a 33,924-row survey extract in Excel (17 variables: wealth, education, residence, births, haemoglobin, iron intake) and trimmed it to 12 analysis columns.
  • Removed non-anaemic and blank records, leaving 4,415 respondents with mild, moderate or severe anaemia.
  • Built an interactive Power BI dashboard and presented findings in a 10-slide case study deck.

What I found

  • Moderate anaemia was the most common level (2,358 of 4,415 cases, 53%).
  • The poorest wealth group had the most cases; the richest had the fewest.
  • Rural respondents had more cases than urban respondents.
  • 57% had their first birth between ages 12 and 19. Average haemoglobin: 104.08 g/L.
  • 81% were not taking iron pills, sprinkles or syrup, and iron use rose with wealth: 10.8% in the poorest group against 28.5% in the richest.
Power BI dashboard page The Pattern: anaemia level by age, respondents by wealth index, education level and place of residence
Page 2, The Pattern: who the 4,415 cases are, by age, wealth, education and residence.
Power BI dashboard page The Gap: age at first birth, haemoglobin by recent births, and tables by wealth index
Page 3, The Gap: age at first birth, haemoglobin by recent births, and iron-pill use by wealth index.

Recommendation. Focus screening, iron-supplement awareness, and nutrition education on poorer and rural communities, and build anaemia education into existing maternal and child-health programmes, with a focus on women in their 20s and early 30s.

View the project on GitHub

Children's Anemia in Nigeria: Case Study

Power BIExcelData CleaningHealthcare AnalyticsNDHS 2018

Problem. Which children are most affected by anemia, and where can prevention reach them?

What I did

  • Separated the child's anemia results from the mother's in the 2018 NDHS file (33,924 records).
  • Kept 7,003 children with mild, moderate or severe anemia and built a Power BI dashboard.
  • Wrote a 10-slide case study: problem, data, method, insights, recommendations and impact.

What I found

  • 56% had moderate anemia and 61% moderate or severe. Average hemoglobin was 93.7.
  • 65% lived in rural homes, and the poorest group had the most cases (1,624 against 917 in the richest).
  • 80% were not taking iron pills, with use of 10.6% in the poorest group and 30.1% in the richest.

View the project on GitHub

Supermarket Sales Dashboard (Power BI)

Power BIData VisualizationKPI ReportingSales Analytics

Goal. Show where supermarket revenue comes from across cities, customer types, product lines and gender. This is the same dataset as my Excel dashboard, rebuilt in Power BI.

Power BI supermarket sales dashboard
Revenue by city, customer type, product line and gender.

What I did

  • Built KPI cards for revenue with and without tax, and a branch slicer.
  • Added charts by city, customer type, product line and gender.

What I found

  • Sales before tax were 307.59K. The recorded tax (43.9K) had 117 entry errors, so revenue including tax is overstated.
  • Naypyitaw led the cities (34.24%) and members made up 50.85% of revenue.
  • Food and beverages earned the most, and men spent more than women on Health and beauty.

View the project on GitHub

Retail Sales Performance Dashboard

ExcelPivot TablesDashboard DesignKPI ReportingSales Analytics

Goal. Show management where revenue comes from across branches, cities, product lines, gender and customer type.

What I did

  • Built an interactive Excel dashboard on 1,000 transactions (unit price, quantity, tax, sales, revenue).
  • Summarised performance with pivot tables and charts by city, product line and customer segment.

What I found

  • Sales of about $308K (before tax) across 5,510 units sold.
  • Naypyitaw led cities at about $105K, and Food and beverages led product lines at about $53K.
  • Female customers contributed about $160K versus $148K from male customers.
  • Data check: the Tax column has 117 entry errors, so these figures use sales before tax.

View the project on GitHub

Sales Performance Dashboard (Power BI)

Power BIDAXData ModellingData VisualizationSales Analytics

Goal. Find out who and what drives sales, how profitable it is, and when sales peak.

Built on a practice (sample) dataset.

What I did

  • Built a star-schema data model (Fact_Orders, Dim_Customers, Dim_Products) in Power BI.
  • Wrote DAX measures for Total Sales and Profit Margin %.
  • Designed a 3-page report: Overview, Details and Insights, with date, category and country slicers.

What I found

  • One customer, John, generated about 55% of total sales (3.6K of 6.51K).
  • Monitors outsold Accessories, about 4K against 2.4K.
  • Profit margin was only 6.05%, so profit per sale is thin.
  • January was the biggest sales month (2,396), followed by November (1,491).
Power BI Sales Performance Dashboard overview page with KPI cards, sales by customer and sales by category
Overview page: KPI cards, sales by customer and by category.
Power BI Sales Performance Dashboard details page with monthly sales by year and sales by country
Details page: monthly sales by year and sales by country.

View the project on GitHub

Market Database Design and SQL Queries

SQLMySQLRelational DatabaseDatabase DesignPrimary and Foreign KeysCRUD

Goal. Model a Nigerian electronics market: customers, products, suppliers, orders and order line items.

What I did

  • Designed 5 linked tables: Customer, Products, Suppliers, Orders, Order_Items.
  • Populated them with INSERT statements using realistic Naira pricing and Lagos and Abuja customers.
  • Retrieved records with SELECT queries to verify each table.

Concepts applied

  • One-to-many relationships between customers, orders and items.
  • Normalisation: order line items separated from order headers.
  • Data types for IDs, text, dates and decimal prices.

View the project on GitHub

Data Cleaning: 7 Types of Dirty Data

Data CleaningExcelData QualityData ValidationData Wrangling

Worked through a deliberately messy sales dataset and fixed each issue category: duplicates, outliers (age 150, a ₦3,000,000 unit price), inconsistent text and gender entries, missing values, wrong data types, irrelevant columns, and business-logic errors (negative quantities, 150% discounts, delivery before order date).

Tools: TRIM, PROPER, UPPER, VALUE, DATEVALUE, COUNTIFS, Remove Duplicates, conditional formatting, Data Validation dropdowns. Principle I follow: flag and investigate before deleting.

Excel Functions Toolkit

Excel FormulasLogical FunctionsText FunctionsStatistical Functions

Reference workbook covering arithmetic, logical (IF, AND, OR, NOT), comparison, text (TRIM, PROPER, LEFT, RIGHT, MID, LEN, CONCATENATE) and statistical functions (SUM, MIN, MAX, COUNT, AVERAGE, MEDIAN, ROUND).

Professional Experience

Acquisition Associate

Autochek Africa, Nigeria · Remote · Apr 2025 – Present

  • Clean, aggregate and analyse operational and acquisition data in Microsoft Excel to support daily business activities and reporting.
  • Manage acquisition records so datasets stay accurate, complete and structured for operational use.
  • Prepare periodic business reports that monitor performance metrics, identify data gaps and support management decisions.
  • Filter, transform and present raw business data in clear, decision-focused summary formats.

Operations Project Manager

Swiftdorf Nigeria Limited · Feb 2020 – Apr 2025

  • Built KPI monitoring systems and performance dashboards to track project timelines, budget burn rates and resource use.
  • Analysed historical execution bottlenecks to put in place proactive risk mitigation, achieving 100% on-time delivery across concurrent projects.
  • Translated technical and project metrics into clear visuals and summary reports for senior executives.

Operations Manager / Chief Finance Officer

Bokan Oil & Gas Limited · Sep 2017 – Jan 2020

  • Led financial modelling, cash-flow analysis and annual budgeting to direct corporate strategy.
  • Ran expense variance analysis to find operational redundancies and put in place targeted cost controls that improved margins.

Business Development Manager

Omo-Gaye Enterprise · Mar 2013 – Aug 2017

  • Analysed industry sales trends and consumer demographics to identify untapped market opportunities and set data-backed sales targets.

Skills

Tools

Microsoft Excel (Power Query, pivot tables, complex formulas), SQL / MySQL, Microsoft Power BI (DAX, data modelling), Microsoft Azure fundamentals, Office 365, Google Workspace

Analysis

Data cleaning, data wrangling, exploratory data analysis (EDA), trend analysis, KPI tracking, dashboard design, data visualization

Financial & Operational

Financial reporting, variance analysis, budgeting and forecasting, expense reconciliation, process optimization, inventory analytics

Education & certifications

B.Sc. EconomicsDelta State University, Abraka · 2012
EntrepreneurshipNational Open University of Nigeria (NOUN), Abuja
Data Analytics & AI Programme, Ihifix Scholarship ProgrammeCompleted 2026
Mastering Data Analysis Using Microsoft Excel, AlisonCompleted August 2026
Introduction to Microsoft Azure Cloud Services, Coursera

I like questions where the answer changes what someone does — where to send a health outreach team, which product line to stock, or where a budget is quietly leaking. After a decade in finance and operations, I'm building that same judgment into Excel, SQL and Power BI. I'm looking for a Data Analyst or Business Intelligence role where I can bring both.