This is the start of a hopefully long series of BI FAILs, examples of dysfunctional behavior and problems gathered from conversations with companies implementing business intelligence projects. Certain details (may) have been changed to protect the guilty.
“We had just implemented a new dashboard system, using data from a corporate warehouse. One key performance indicator had been typically been shown on a standard chart with the y-axis varying between 0 and 100, and the typical score was 95. The new chart engine automatically zoomed in, based on the values, to show the y-axis starting at 90.
Soon after the new system was installed, the team that owned the KPI had a tough quarter, and it dropped to 90.5 for the month. Because of the new charting system, this looked at first glance like a massive drop, rather than a modest 5% setback, and the manager called the dashboard implementation team to complain.
The team refused to make changes, explaining that the system was working as specified, and that a zoomed-in view was more appropriate.
The next day, after a refresh of the underlying data warehouse, controlled by a different (and more malleable?) team, the KPI had mysteriously jumped back up to 95…”