Case Study 01
Sales Performance Dashboard
for a Hotel & Resturant
for a Hotel & Resturant
Hospitality · Lagos, Nigeria
90%
Reduction in manual reporting time
3days
Reporting cycle cut to under 30 minutes
1wk
Time to full dashboard deployment
The Problem
The client had no visibility into their monthly sales performance across rooms, food and drinks categories. Decisions were being made on intuition, not data, leading to overstocking and missed revenue opportunities.
The Approach
Audited all existing data sources, built a centralized database on Airtable to consolidate sales records, and designed a real-time Looker dashboard tracking revenue, service performance, and seasonal trends.
The Outcome
The client identified their best-seller category within the first month, reduced reporting time from 3 days to under 30 minutes, and made their first data-driven restocking decision within weeks.
Tools
SQL
Power BI
Excel
Data Modeling
Case Study 02
Financial Reporting Automation
for a Book Publishing
for a Book Publishing
Book Publishing · Nigeria
60%
Faster monthly close process
100%
Data accuracy improvement
4hrs
Saved per week on manual entry
The Problem
A growing book publishing company was managing finances across multiple spreadsheets, resulting in errors, duplicated data, and a month-end close process that took over a week and drained the team.
The Approach
Reconstructed the spreadsheet connecting all financial inputs into a single source of truth, automated recurring reports, and built an executive dashboard for real-time profit and loss visibility.
The Outcome
Month-end close dropped from 8 days to 3 days. Leadership gained instant access to financial KPIs for the first time, enabling faster decisions and early identification of cash flow risks.
Tools
Power BI
SQL
Excel
Report Automation
Case Study 03
Customer Analytics & Growth Strategy
for an E-commerce Brand
for an E-commerce Brand
E-commerce · Remote Engagement
35%
Increase in repeat purchase rate
5segs
Customer segments identified & activated
2x
Return on marketing spend
The Problem
The brand was spending heavily on customer acquisition but had no data on who their best customers were, why they returned, or which products drove the most lifetime value.
The Approach
Conducted a full customer data audit, built a segmentation model using purchase history, identified high-value customer profiles, and created a data strategy roadmap for targeted retention campaigns.
The Outcome
The brand shifted marketing budget toward their top two customer segments, saw a 35% improvement in repeat purchases within 90 days, and reduced wasted ad spend by clearly defining who not to target.
Tools
SQL
Power BI
Customer Segmentation
Data Strategy