The Solution
Ancoris built a core data platform that provides a single source of truth for all reporting and analysis. The solution ingests data from The Works’ operational systems and runs this through several dataflow pipelines to cleanse and transform it.
Stakeholders are pro-actively notified of any data violations so that affected data can be remediated if required. Ultimately, the transformed data is pushed to a BigQuery data warehouse which becomes the source of truth which feeds BI dashboards and on demand data exploration through SQL queries or Data Studio projects for example.
A third-party QlikSense platform is also hosted on Google Compute Engine allowing The Works to create interactive reports and dashboards to visualise the data. In addition, The Works have a dedicated VPN back to their data centre supporting end user access.