Business challenge

Aftermarket revenue, service performance and customer mix were reported through disconnected spreadsheets, so leadership had no agreed view of performance.

Solution

Designed an executive KPI framework and a single Power BI model consolidating repairs, spares, warranty and service revenue with drill-through to order level.

KPIs

• Aftermarket revenue & growth
• Gross margin %
• Order volume and average order value
• Revenue by region, channel and category

Business challenge

Pricing was inconsistent across regions and customers, eroding margin with no visibility into which products or drivers were responsible.

Solution

Built margin waterfall and price realization analytics segmenting products by volume, criticality and competitive exposure.

KPIs

• Price realization %
• Margin waterfall by driver
• Average selling price vs margin
• Gross profit by region and category

Business challenge

Complaints were closed case by case, hiding recurring failure modes and the true cost of poor quality.

Solution

Created Pareto and root-cause analytics linking complaints to product line, failure mode, plant and resolution time.

KPIs

• Complaint volume and ageing
• Pareto of failure categories
• Average resolution time
• First contact resolution %