Comprehensive self-service reporting and analytics
Our client is a leading building products and construction materials group with over 12,000 employees. After establishing a rich understanding of the organisation and its operations, we delivered a Tableau solution that would serve as a ‘one-stop-shop’ for all of the Finance KPIs across products. The solution was optimised for self-service reporting and analytics.
Our client had been using IBM Cognos reporting software for some time, however it was no longer meeting the needs of their business.
Their National Finance Centre (NFC) team had little to no ability to customise reports and manage their general ledger effectively. Additionally, making changes to the data structure was a sizeable challenge, and the business was becoming increasingly frustrated by the significant effort required to interrogate, analyse and visualise their data.
The organisation sought a new business intelligence (BI) solution that was flexible, adaptable and easy to use. They had identified several potential Cognos replacements, but needed guidance on which solution was best suited to both their current and future requirements.
We were engaged to identify the most appropriate BI tool and implement the preferred solution.
After establishing a rich understanding of the organisation and operations, we identified Tableau as the optimal solution for generating customised reporting, visual analytics, self-service financial reporting and analytics. Tableau was selected for several reasons:
- Ease of use: Our client needed a solution that could be managed in-house by their NFC team, without reliance on IT resource. Tableau is built for the everyday business user, which means it can be easily used to rapidly load, clean, analyse, interrogate and visualise complex datasets to gain actionable insights.
- Geospatial: Operating across multiple countries and geographies, the organisation needed to be able to analyse data by region. Tableau is the market leader in data visualisation and its ability to support visual analyses of geographical data is among its greatest strengths.
- Trends and forecasting: As a growing business, it was essential that the platform could support sophisticated trend analysis and forecasting. Both are inherent features of Tableau.
- Security: With highly sensitive commercial data at stake, it was imperative for the chosen solution to have strong security. Tableau’s authentication and authorisation features met all of the organisation’s stringent data and application security requirements.
- Data structure: Our client required metadata-based reporting, in which the metadata for all data sources was stored centrally. Users needed to be able to connect to a central data source to create reports, thereby using consistent metadata. Tableau Data Server was the perfect fit.
As part of the project we designed and built a suite of Tableau dashboards with visualisations and geospatial analytics to support the National Finance Centre’s reporting requirements. The dashboards help users understand key business metrics, see year-over-year trends and derive deep insights across various products over geography.
Key finance KPIs are now made available in a ‘one stop shop’ dashboard for respective products and security has been established around data. As an example: A NSW Regional manager will only be able to see NSW numbers on the dashboards.
We also provided training and support for the in-house team to uplift their skills and ensure they would be ready to take ownership of the new enterprise analytics platform.
We’ve worked with six different consultants from Analytics8 to date. It’s a real testament to Analytics8 that every one has had an advanced skill level. Everyone who’s been on this job has been of an extremely high calibre.
The implementation of Tableau has been a clear success for our client. Around 500 users throughout the organisation are using Tableau to view reports and explore their data. Engagement with Tableau has extended well beyond the finance team, with Sales, Compliance and Logistics all now using Tableau to manage their information needs.
Tableau users within the business are extremely positive about the user experience, and team members are now empowered to easily and efficiently surface insights from their data. Compelling visualisations make complex data accessible and assist in communicating data insights to internal stakeholders and management.
I like that Analytics8 brings oversight. It’s not that we lack talent or the ability to do things ourselves. Rather, Analytics8 brings depth and vision. Its consultants bring a fresh perspective that helps us avoid becoming myopic in the way we look at things. Their disciplined approach means that they see what we don’t see, and bring more rigour. In the end, that’s what leads to a better result.
Importantly, the organisation’s finance team is now confident and capable in designing Tableau reports and dashboards independently and are no longer reliant on IT to manage their reporting needs
Analytics8 is very knowledgeable. We initially started working with them on projects only, but our relationship has evolved, and we use them to supplement and enhance the capabilities of our existing team. It’s not just about performing tasks, but also building our skills internally. You can send people on a training course, sure, but we’ve found it to be more valuable to bring in Analytics8 to show people how to use technologies using our own data and systems.
The organisation plans to roll out Tableau across other parts of their business, and ultimately upskill its staff by transforming ‘report consumers’ into a team of analysts that can uncover valuable insights by using sophisticated yet easy to use self-service analysis tools.
350 Kent Street,
Sydney, NSW, 2000
+61 2 9299 4430
350 Collins Street,
Melbourne, VIC, 3000
+61 3 8605 4880