As a global business, JLL has multi-million dollar accounts with key performance indicators that need to be reported without fail on the 10th of the month. This involves aggregation of multiple data sources to ensure KPIs roll up from site to country to region to global level. Understanding each indicator and using it to direct the business puts business intelligence right at the heart of the organisation.
The global KPI project took a ground-up approach to revolutionise how the business told its story each month. Starting with data architecture, then moving to data visualisation with supporting training sessions, the business has enabled data access globally to allow users to explore and understand the insights they need.
The data architecture was platformed to ensure it was robust, with automated routines to meet the critical tenth day deadline. This solid foundation ensures that the stories being told are based in trusted, accurate data. A project team was created bringing together members across multiple regions and time zones across a three-month timeline. Alteryx is used to combine data sources and perform aggregations and calculations automatically which are then fed into Tableau to create dashboards and data visualisations.
A listening project among senior global stakeholders captured their needs and feedback, ensuring that the data visualisations would meet their needs for granularity. This means a global lead can now drill down into nearly 1,000 metrics from over 50 countries and understand its source and meaning. Direct links are included to supporting dashboards with embedded detail to explain each metric and target. Context is also provided to avoid misunderstandings, such as an indicator of 50% in a market meaning one out of two targets have been missed, rather than 50 out of 100.
Beyond the underlying data architecture and data visualisation tool, business support tools have been put in place in the form of a comprehensive user guide which offers analytical tips, a talking head video guide to introduce the KPI resource, and a communications plan via written support documents and familiarisation sessions. These cover 25 time zones and options in total. By taking a global approach and ensuring all requirements and needs have been addressed, the KPI project is ensuring the whole story gets told.