GET IN TOUCH
Case 10 · Yiğitoğlu

BI Dashboard for Supply Chain Optimization

Real-time procurement visibility by integrating ERP and CRM data.

Client
Yiğitoğlu
Role
Digital Transformation & BI Manager
Period
2023
Location
Istanbul, TR
Fig. 10 — Yiğitoğlu
/ A

Overview

Purchasing and supply chain decisions were slowed by disconnected ERP and CRM data. I designed a BI dashboard that integrated both sources to give procurement and operations a real-time view of purchasing performance, supplier behaviour, and inventory signals.

Power BIERPCRMSupply Chain AnalyticsProcurement
/ B

Challenges

  • 01ERP and CRM data were siloed, making end-to-end supply chain visibility impossible.
  • 02Procurement teams relied on static reports that were outdated by the time they were reviewed.
  • 03Key metrics like supplier performance and inventory health were calculated differently across functions.
  • 04The dashboard had to serve both operational buyers and strategic planning.
/ C

Approach

  1. 01Mapped the full procurement data flow from ERP orders and CRM supplier interactions to inventory signals.
  2. 02Built a unified data model that aligned purchasing, operations, and finance on the same definitions.
  3. 03Delivered a Power BI dashboard with real-time refresh and role-based views.
  4. 04Focused the interface on decisions: what to buy, from whom, and when.
/ D

Outcomes

Real-time
Procurement visibility
ERP+CRM
Unified data model
Faster
Purchasing decisions

"Supply chain dashboards are only useful when they answer the next question before the buyer has to ask it."

— Behrouz Bagherzadeh, on the project
Next case · 01

Executive Power BI Suite

Yiğitoğlu

Read →