Sales performance and decision intelligence
- Problem
- Plenty of ERP sales data, no single source of truth. KPIs were undefined and leadership decided on instinct.
- What I built
- A star schema on top of the ERP, a measure layer in DAX for revenue, ticket and growth (month over month and year over year), and a seller ranking with drill-through to customer level.
- Result
- One report the sales leadership opens every week, with underperforming segments and concentration risks visible on the first page.