The data was complex, having numerous levels of hierarchy, with people, devices and time to name just a few. Creating a standard set of tables is hard enough, but having an online system that allows users to apply filters that can affect the dimension was a challenge. There were surprisingly few data issues; almost all the numbers matched results from the conventional database software from day one. The online reporting tool went live the day it was scheduled, and feedback from users has been unanimously positive since.
The technology has improved the efficiency of the delivery of the research, and delivered an outcome that is more fit for purpose than the written report we would otherwise have had to produce. Users have greater freedom to explore the data and can tailor the outputs to their own needs.