From Broken Spreadsheets to Automated Dashboards: How Better Data Transformed Incentives and Decision Making

The Head of Customer Experience was sitting on a problem that was quietly affecting the entire field operation. The reporting system the team relied on was an outdated set of spreadsheets, built up over years, inconsistent, and increasingly difficult to maintain. Nobody had a clear, reliable picture of what was actually happening on the ground across the network.

The consequences were real. Commercial decisions were being made on data that was hard to trust. And worse, the incentive payments being made to frontline staff, rewards for upselling and selling ancillary products to customers at the counter, could not be verified with confidence. For a business where counter sales performance was a meaningful revenue driver, that was a significant risk.

The challenge was not just technical. The Head of Customer Experience was understandably cautious about change. She had seen system transitions go wrong before. Her team depended on the existing process, however imperfect, and any disruption had real consequences for the people on the ground.

My Role

My role was to design and implement a modern, automated reporting solution that would replace the legacy spreadsheet system entirely. But before any of that could happen, I needed to do something more important: build enough trust and credibility with the Head of Customer Experience that she would be willing to move at all.

The technical challenge was significant. The commercial challenge was bigger.

What We Did Together

I started with conversations, not solutions. Over a series of meetings with the Head of Customer Experience, I listened carefully to her concerns, understood what her team needed day to day, and made sure she felt heard. I was transparent about the limitations of the existing system and honest about what a transition would involve. Gradually, through consistency and follow-through on smaller commitments, the relationship shifted from cautious to collaborative.

Once the trust was there, we moved to the work itself. Together, we mapped out what the new reporting needed to do, not just from a data perspective but from a practical, operational one. What did a branch manager actually need to see each morning? What did the Customer Experience team need to review each week? What data needed to be locked down and verified before incentive payments could be processed?

From there, we designed and built a new BI dashboard that replaced the spreadsheet system entirely. The dashboards pulled data directly from the source systems, removed the manual handling that had been introducing errors, and presented performance information in a clean, consistent format that anyone in the business could read and act on. Crucially, the incentive calculation logic was built directly into the data pipeline, ensuring that sales figures used for staff rewards were accurate, auditable, and consistent every single time.

We then worked closely with the team through the transition, running sessions to build familiarity with the new system and making iterative adjustments based on their feedback until the solution felt genuinely theirs.

Result

The impact was felt immediately and on multiple levels.

Manual reporting preparation time dropped by 90%. What had taken hours of spreadsheet work each week was now automated and available almost in real time. The field team and leadership could see branch-level or state performances clearly, with consistent data they could trust to make decisions.

The incentive payment process became reliable and auditable. Frontline staff could see their own performance data transparently, which improved both engagement and confidence in the reward system.

And the Head of Customer Experience, who had started the process as a cautious sceptic, became one of the strongest advocates for the new system within the business.

The experience reinforced something I carry into every engagement today. The best analytical solution in the world is only as valuable as the trust and human understanding that gets it adopted. Data transformation is never just a technical project.

It is a people project first.

This is the kind of work I do through Ganalytics. If your business is sitting on data that is not being used properly, or relying on reporting processes that have quietly become a liability, I would love to offer a free 30-minute conversation.