Reducing analysis time on 1.5 TB of data from weeks to hours
Before Tableau, the organization manually aggregated vast amounts of data from critical applications consisting of over 65 million rows that translate to about 1.5 TB. Using traditional methods for various departmental web applications was very time consuming.
Also, the team was not aware of the quality & consistency of data that was stored or how the relationships between the data were established at the back-end. In some cases, it was difficult to identify and diagnose data-related issues when they arose. Additionally, adapting to the daily change requirements for reporting was also a challenge.
To overcome cited issues and challenges, the department had to request a copy of the data from the state data centre for troubleshooting since the state data center policy prevented them from having access to the production database data. After receiving the copy, the team had to load it to the local system database and find any existing issues in the process, which consumed a lot of time.
Tableau helped the department address cited issues and challenges and the team can quickly analyse the data and deliver reports to departments and tailor dashboards to individual requirements. Since reports are accurate and standardized, the team can also respond to change requests from various stakeholders within a few minutes. Overall, DoIT&C reduced its report delivery period from weeks to hours.