WhatsApp us
BA Pro SolutionsAnalytics & Automation Book free consultation

Selected work

Featured projects

Client names are withheld under NDA. Metrics below are the actual outcomes reported after handover.

REVENUERM 4.82M MARGIN31.4% VS TARGET+12.6%

Power BI · E-commerce retailer

Sales performance dashboard

Six spreadsheets consolidated into one model with daily refresh. Regional managers now open one report instead of waiting for a Monday email.

6 hrssaved weekly
1 dayfaster close
45active users
Power BIDAXPower QuerySQL Server
Logistics operations — on-time performance 96.2% OTD OTD TREND · 7 WEEKS BY HUB EXCEPTIONS38 AVG TAT2.4d

Power BI · Logistics provider

Logistics operations dashboard

Shipment tracking, hub performance and exception monitoring in one operational view, with drill-through to individual consignments.

+3.1 ptson-time delivery
4hubs covered
Hourlyrefresh
Power BIDataflowsExcelPower Query
Financial KPI scorecard GROSS MARGINOPEX RATIOCASH CYCLEDSO 31.4%18.2%42 days38 days ▲ 2.1▼ 1.4▲ 5.0▼ 3.2

Power BI · SME manufacturer

Financial KPI dashboard

A monthly scorecard with variance to budget, cash cycle tracking and automated commentary fields for the finance lead.

3 dayscut from reporting
12KPIs tracked
2data sources
Power BIDAXExcel
Executive summary — FY view REVENUE4.82M EBITDA18.6% HEADCOUNT214 NPS+42 QUARTERLY PERFORMANCE BY DIVISION

Power BI · Corporate department

Executive reporting dashboard

A one-screen board pack replacing a 24-slide monthly deck, with mobile layout so leadership can check numbers before the meeting.

24 → 1slides to screen
8 hrssaved monthly
Mobileoptimised
Power BIRow-level securityPower BI Service
CURRENT STATE — 9 STEPS · 3.5 DAYS Email request Manual entry Wait forapproval Excel merge Re-checkerrors Send report FUTURE STATE — 4 STEPS · 4 HOURS Microsoft Formssubmission Automatedapproval flow Central datasource (single) Power BI refresh+ scheduled email

Business analysis · Operations team

Current state to future state redesign

Nine manual steps across email and spreadsheets mapped, measured and redesigned into four automated steps. Delivered as a BRD with process maps, gap analysis and user stories the internal IT team built from.

9 → 4process steps
3.5d → 4hcycle time
14stakeholders interviewed
Process mappingGap analysisBRDUser storiesPower Automate
TIME PER STEP — BEFORE / AFTER (MINUTES) Data collectionValidationApprovalDistribution −78% TOTAL

Business analysis · Shared services

Workflow optimisation study

Time-and-motion analysis of a monthly close process, with a prioritised backlog of quick wins the team delivered themselves.

−78%handling time
6quick wins
2 wksengagement
Requirements gatheringProcess improvementVisio
SWIMLANE MAP · ORDER TO CASH SALESOPSFINANCE

Business analysis · Distribution

Order-to-cash process mapping

Cross-functional swimlane maps that finally settled who owns which handoff — used as the onboarding pack for new hires.

3functions mapped
11handoffs clarified
1owner per step
Swimlane mappingRACIStakeholder workshops

Website projects · Before & after

Corporate site rebuild for a services firm

Objective: replace a dated brochure site that produced almost no enquiries. Delivered a responsive corporate site with clear service pages, an enquiry form and analytics. Drag the handle to compare.

Before image placeholder
After
3.2×enquiries per month
1.4sload time
100%mobile responsive
HTML/CSS/JSResponsive designSEO setupGoogle AnalyticsWhatsApp integration

Website · Consulting practice

Consulting website & lead capture

A five-page consulting site with service detail pages, enquiry form routing to email, and WhatsApp click-to-chat for mobile visitors.

5pages
2 wksbuild time
SEOready at launch
ResponsiveContact formsAnalytics

Website · Analytics portal

Client analytics portal

A secure landing area where clients open their embedded Power BI reports and download monthly packs, without a separate login.

EmbeddedPower BI
Role-basedaccess
0emailed reports
Power BI EmbeddedWeb appAuthentication

Your project could be next

Bring the report you dread building. We'll show you what it looks like automated.