dentsu Australia was struggling to utilise data to generate meaningful business insights. They had limited visibilityof capacity (supply and demand), client and department/business unit profitability, forecasting, portfolio reporting, and project delivery.
Like many organisations, dentsu Australia grappled with manual processes (lots and lots of spreadsheets!) and time-consuming procedures to pull various data sets together. By the time Finance or Operations had collated the information, the data was often out of date. This inconsistent framework and structure compromised data consistency and the ability to make decisions at speed, creating challenges across capacity evaluation, client profitability, and portfolio reporting.
dentsu Australia’s main goal was to replace these manual processes with an automated reporting solution, improving data accuracy and timeliness to deliver business insights in real-time. This reporting workstream was run in parallel to the implementation of Deltek WorkBook in the Creative business to ensure that data points and information flows were considered and prioritised as part of the system build.
Tangram has demonstrated an exceptional ability to establish a deep understanding of our business. Our biggest challenge lay in connecting a sound operational process with valuable data insights. Tangram not only tackled this challenge but consistently delivered great data that has become integral to our business operations and decision-making.
Navigating the complexities of making the front end of our business work seamlessly for insightful outcomes is no easy feat. We had tried to address this internally with little success.
The partnership with Tangram has been transformative, providing us with not just solutions but a refined and optimised operational process. Their expertise in seamlessly connecting operations with valuable data has significantly impacted our ability to derive meaningful insights.
Tangram implemented a comprehensive reporting solution focused on maintaining data quality and incorporating best practice processes.
Discover
In the initial phase, we developeda detailed understanding of dentsu's processes, data structures, and requirements, including their structure, the intended audience for reports, and the KPIs used to measure business success. We drafted report formats and structures to visualise the end result, defining report frequency, required calculations, and required data sets ahead of development.
Design + Build
The Design + Build process started with data architecture, allowing us to identify potential errors and improve data capture before integrating into the reports. Draft visualisations were designed before introducing live data,ensuring the reports aligned with the key insights the business required.
Regular communication and collaboration with key dentsu stakeholders through daily stand-ups was integral to the process, ensuring reporting requirements remained embedded throughout the solution design.
This project reinforced something we’ve seen time and again with agencies: better reporting starts long before the dashboard. You need the right processes, data structures and measures in place first. The work we’ve done with dentsu and other agencies has shaped how we approach Business Intelligence today, giving us a much clearer understanding of the operational and commercial insights agency leaders actually need.