Projects

Analysis that starts with a business question

Each case study covers the problem, the data, the analysis and what it meant for decisions.

3 projects shown

The Credit Analysis Level 1 Power BI report, showing total loans, total exposure, default rate, PAR 30, PAR 90 and NPL rate, with exposure by product type and by state, and NPL rate by product type and by credit score band

Power BI · Data Analysis

Credit analysis, Level 1: loan portfolio health check

A first look at the health of a loan portfolio: how much risk there is, where it is concentrated and which segments need attention first.

  • Power BI
View case study
The Maji Ndogo Water national survey report in Power BI, with a province map, headline figures for budget and access, population by water source, and improvements and budget by province

Power BI · Business Intelligence

Maji Ndogo: water access, queues and safety

Who has safe, reachable water, how long do people wait for it, and what does it cost them in safety? A Power BI report on a national water survey, with a recommendation for where to act first.

  • Power BI
  • Excel
View case study
The Executive Overview page of the NaijaStock Power BI report, with revenue, quantity, profit and order totals, a revenue trend, category contribution and top products

Power BI · Business Intelligence

NaijaStock sales and distribution dashboard

Give a distribution company's executives and its product, warehouse and procurement teams one consistent view of sales performance.

  • Power BI
  • DAX
  • Excel
  • Data modelling
View case study

Want to explore the work yourself? Open the interactive reports.