The BI bottleneck dilemma: Centralization, decentralization, and federated governance in logistics analytics

Digital transformation has intensified the tension between centralized data control and decentralized analytical access. Organizations often respond to rising analytical demand by either tightening central oversight to preserve consistency or expanding access to increase agility, yet both approaches introduce structural trade-offs. Ninja Xpress, a Third-Party Logistics (3PL) provider based in Jakarta, Indonesia, experienced this dilemma as it shifted between broad data democratization and strict BI centralization. Initially, the company granted broad data access across departments. Although this improved autonomy, it degraded data platform performance, weakened governance, and produced conflicting “versions of the truth.” In response, the Business Intelligence (BI) team recentralized access to restore stability. However, the centralized model soon created bottlenecks as reporting demand overwhelmed the BI team and slowed decision-making. This teaching case examines how the organization redesigned its analytics structure through a federated governance model that redistributed routine analytical responsibilities while maintaining centralized oversight. Selected departmental representatives formed a “Data Tribe,” receiving controlled data access and guidance from BI while acting as extensions of the central function. The case compares the advantages and limitations of centralized, decentralized, and federated BI governance models and illustrates how governance design influences workload distribution, metric consistency, and analytical capability. Over a 12-month period, the federated approach reduced BI request backlogs by approximately 40% and improved reporting alignment. By foregrounding governance trade-offs in scaling analytics, the case provides students with a practical lens for evaluating how organizations balance agility, consistency, and accountability in data-intensive operational environments.