SYSTEMS / DECISION INTELLIGENCE / 2016 — 2020

From business database to management decision: a finance BI system

I connected product, city, repayment, and profitability views so managers could see not only what moved, but which operating lever moved it.

One viewDecision intelligenceFinance and operations shared a common fact base.

Drill-downActionable analysisManagers could trace movement to a product, city, or cohort.

Profit-ledManagement logicResource choices followed contribution rather than volume alone.

01 / THE CHALLENGE

What had to be made clear

Move from periodic reporting to an analytical system that could support drill-down, comparison, and action at product and city level.

02 / MY ROLE

I designed the metric definitions, management views, and decision rhythm, then translated findings into operating targets and resource choices.

03 / THE APPROACH

01 Defined consistent revenue, repayment, cohort, and contribution measures.

02 Built comparative views across products, cities, and asset vintages.

03 Linked variance analysis to accountable managers and review cadence.

04 Added drill-down tables and visual signals for early intervention.

05 Used the system to support profit-led resource and capacity decisions.

04 / DELIVERABLES

↳ Management BI metric dictionary

↳ Product and city profitability views

↳ Cohort and repayment analysis

↳ Decision review and accountability cadence

BEYOND THE RESULT

This case is one part of a wider finance-and-AI practice. Explore the prototypes that make the underlying logic tangible.