Interactive decision-support tool enabling internal stakeholders to evaluate service partner investments and repair capability expansion based on financial impact and scenario simulation.

See report: https://app.powerbi.com/view?r=eyJrIjoiMTA3ZTg0N2ItOTI5MC00ZjlmLWEzZGEtMmExMWJkZmNiYzBmIiwidCI6ImMxOWM1ZWQxLTNkNjMtNDQ2MS04YTg0LTI5NzI1ZTlmMWRkNiJ9

📊 Dashboard Preview

📌 Business Problem

Dealer network managers lacked a structured and data-driven way to evaluate whether investing in expanding repair capabilities for specific products, regions, and repair levels would be financially viable.

Decisions were often based on assumptions and fragmented data, making it difficult to:

• estimate demand based on product population and failure rates
• evaluate the impact of regional coverage and partner capacity
• assess financial outcomes (revenue, cost, profitability)
• compare scenarios and determine payback period

💡 Solution

Developed an interactive analytical tool in Power BI that enables internal stakeholders to simulate investment scenarios and evaluate financial outcomes in real time.

The tool combines historical data with parameter-driven assumptions, allowing users to:

• adjust key business drivers
• model different scenarios
• instantly assess ROI and payback