← All projects
Supporting case study · Business Intelligence

ERPSIM Sales and Market Performance Dashboard

Used Power BI to evaluate team revenue, product performance, market share, channel gaps, pricing, and additional commercial insights from ERPSIM data.

Power BIERPSIMRevenue AnalysisMarket ShareChannel Performance
ERPSIM Sales and Market Performance Dashboard project graphic
Teambenchmarking
Productrevenue analysis
Channelgap analysis
Power BIdashboard platform
The challenge

What needed to be understood.

Simulation data contained multiple teams, products, channels, and periods. The dashboard needed to support both competitive benchmarking and internal commercial decisions.

Approach

How the analysis was built.

  1. Prepared ERPSIM sales data for analysis in Power BI.
  2. Compared revenue by team and product.
  3. Tracked revenue trends and market-share movement.
  4. Examined channel gaps and the relationship between price and revenue.
Key findings

What the evidence showed.

  • The dashboard made it possible to identify leading teams and products while monitoring how performance changed over time.
  • Channel-level views revealed where sales opportunities were not being captured evenly.
  • Price and revenue comparisons helped distinguish high-value products from products relying mainly on volume.
Business recommendations

What should happen next.

  • Use the dashboard during simulation rounds to connect pricing, channel coverage, and inventory decisions.
  • Add margin and stockout measures so revenue is not treated as the only performance objective.
  • Track decisions by round to connect managerial actions with later outcomes.
Limitations and integrity

What this project does—and does not—prove.

ERPSIM is a controlled business simulation; results demonstrate analytical process but do not represent a live company.

Continue exploring

More projects, methods, and business questions.