Dorcas_Akinnibosun.xlsxOpen to work · Lagos · Remote, home page
Data analyst · Lagos, Nigeria

I clean, model and chart your data until the answer is obvious.

I'm a data analyst who has worked hands-on with data since 2023. I clean messy data, model it, and build interactive Excel and Power BI dashboards that a team can click through to see what is happening and what to do next.

Dorcas Akinnibosun, data analyst
Picture 1 · Dorcas Akinnibosun
Working with data since
Projects completed
Rows analysed
Dashboard pages built
Case studies

Selected work. Five industries.

Banking, retail, product, HR and hiring, each built from raw files to recommendations. Sort or filter the table, hover a row to preview it.

Tool ▾
ProjectIndustryToolHeadline numberLink
1MetroBank Customer InsightsA 5-page Excel intelligence report on who MetroBank serves, where its money moves, which branches lose money and why customers complain.Banking & financeExcel.xlsx57,100$212M+ balances & deposits analysed
2Maven Electronics Sales PerformanceA 4-page Power BI report for a global electronics retailer: what sells, who buys, which stores carry the business and where revenue is slipping.Retail & salesPower BILive426,300$55.8M revenue, +12.1% year on year
3HeartSync Product AnalyticsA 5-page Power BI product report for a global dating app, following the user journey from sign-up to match, subscription and safety reports.Product & usersPower BILive530,00030K users across 3 continents
4Nexa Workforce AnalyticsA 3-page Excel HR report that showed an ageing workforce, middling engagement and a $1.59M training budget that wasn't paying off.HR & workforceExcel.xlsx32,8452,845 employees analysed
5Finance Job Market IntelligenceA live Power BI report on the finance job market: who's hiring, what they pay, which skills keep coming up and how fast recruiters hire.Labour marketPower BILive42,300467.6K applicants across 2.3K postings
Total 5 shown2168,545

All case studies · + 7 Python & ML notebooks

Live dashboards

Don't take a screenshot's word for it.

Most portfolios stop at pictures. Every dashboard here is interactive: 3 are published live in Power BI below, and the Excel ones ship as workbooks with working slicers. Load one and use it the way a manager would.

Live · Power BI
Open full screen (opens Power BI in a new tab) ↗

Real Power BI reports, published from my workspace. Nothing here is a mock-up: filter, drill and cross-highlight like a stakeholder would.

Role fit

Hiring for a data role? Check the match first.

An honest lookup: every skill shows how it's proven, with links to the work. Nothing is rounded up.

=XLOOKUP(, Dorcas[Skills])

Pick the role you're filling, then tick or untick what the job really needs.

Tools
Methods
Ways of working
Match—=AVERAGE(weights)
Choose a roleProven work counts most: shipped in a case study = 1, used in an internship or notebook = 0.75, growing = 0.5.
SkillLevelProof
Method

The same applied steps, every time.

Shown on the MetroBank complaints data. Click through the steps on the left.

Query settings MetroBank · complaints
Applied steps
fx= Csv.Document(File.Contents("complaints_raw.csv"))

1. Source. Pull every file together and list what is wrong with it before changing a single cell.

idbranchchannelopenedstatusdays
C-0412 br012 POS03/02/2024Resolved12
C-0412 br012 POS03/02/2024Resolved12
C-0415BR001online2024-02-05openN/A
C-0419Br17ATM5 Feb 24In progress41
C-0423BR012Branch2024/02/07RESOLVED9

1 duplicate4 date formatsmixed casing"N/A" in a number column

About

An engineer’s habits, applied to data.

Full background →
Comment · Dorcas Akinnibosun

Curiosity about how things work led me to study Mechanical Engineering at the Federal University, Oye-Ekiti. Engineering taught me to break a problem into parts, question every assumption and work with precision.

Data analysis uses the same habits on a different kind of machine. A business is a system too: inputs, processes and outputs, with weak points you can measure. I find them in the data, then design the dashboard so the answer is obvious to whoever reads it.

Writing is part of the job for me. Every project ends with clear findings and recommendations, so technical and non-technical readers leave with the same message.

WhenWhat
Jan 2023 – Mar 2023Junior Machine Learning Collaborator
Omdena · Remote
Jan 2023 – Apr 2023Data Science Intern
Hamoye AI · Remote
2025B.Eng., Mechanical Engineering
Federal University, Oye-Ekiti
CertsData Analysis with Excel · Exploratory Data Analysis with Python · Machine Learning Collaboration · Data Science Internship
Blog

Notes from the work.

All posts →
Power BIModelling $55.8M of sales in Power BI with a star schemaHow five raw tables became a four-page Power BI report for a global electronics retailer: the star schema, the DAX comparisons and what the model revealed.2 min
Market insightWhat 2,300 finance job postings say about the marketExcel still tops the skills list, 81% of roles want a certification and only about 2.7% of applicants get hired. Findings from my live Power BI report.2 min
How I workWhy every dashboard I build is interactiveA static chart answers one question. An interactive dashboard lets each person ask their own. How I design reports people can click through.2 min
FAQ

Questions people ask first.

1What kind of roles are you looking for?

Data analyst, BI, reporting and analytics roles where dashboards and clear recommendations matter, plus freelance dashboard and reporting projects. I'm based in Lagos and work remotely with teams in any time zone, full-time, contract or freelance.

2Which tools do you work in?

Excel (Power Query, pivot tables, slicers), Power BI (DAX, data modelling, time intelligence) and Python (pandas, NumPy, Matplotlib, scikit-learn). I use SQL for querying and joining data and I'm deepening it.

3Are these real companies?

The datasets are realistic case-study data from training programmes and cohorts, and each case study credits its source. The work is mine from start to finish: cleaning, modelling, dashboard design, insights and recommendations.

4Can I click through the dashboards?

Yes, and I'd encourage it. Every dashboard I build is interactive. Maven Electronics, HeartSync and the Finance Job Market report are published live in Power BI: load them on this site and use the slicers, page navigation and cross-filtering. MetroBank and Nexa are Excel workbooks with working slicers that you can download from GitHub.

5Why interactive dashboards instead of static reports?

A static chart answers one question. An interactive dashboard lets each person ask their own: a branch manager filters to their branch, a director compares regions. I design every report so the slicers, KPI cards and charts update together, and the pages follow the order people actually ask questions in.

6How does mechanical engineering help a data analyst?

Engineering trains you to think in systems: break the problem down, measure everything and check your assumptions before you trust a result. I bring that discipline to messy business data.

7Can you work with a remote team?

Yes. I've worked fully remotely since 2023, including with Omdena's global team and at Hamoye AI, delivering to deadlines across time zones.

Contact

=IF(you_have_data, "let's look at it together", "say hello anyway")

Whether it's a role, a messy spreadsheet or a question about one of the case studies, messages come straight to my inbox.

Open to data analyst and BI work: full-time, contract or freelance, remote or on-site