One of our clients recently showed me this report. Names and numbers have been changed, but in my conversation with them, they were very excited about it and it was clearly an important source of information for them. Their Revenue Analysis Dashboard gives them an immediate window and insight into their top performing regions, clients, products and sectors.
Look at the drop-down lists to see how they can drill deeper into any region, product or sector (I need to ask them why they don't need to dig deeper into client, but if they wanted to, a client drop-down could be added to the dashboard in 5 minutes). Other variables on the report can also be changed (time, currency, etc), so each country can see their data in local currency and head office can consolidate in any currency. They can also look at current or prior period performance or any aggregation of time (eg last quarter, or last year).
Every CALUMO report that uses drop-downs is in effect many reports. In this case, this single report represents thousands of potential combinations.
The data is securely stored in SQL Server, while the dashboard is a simple CALUMO web page for fast, secure, scalable reporting available anywhere. Being a dynamic report, when any variables change, the top ten results are updated and sorted on the fly. Naturally they also have a bottom-ten report for badly performing and unprofitable regions, clients, products and sectors.
Our client also uses CALUMO for convenient and rapid data collection during their planning, budget and forecasting cycles. Furthermore, CALUMO is used for guided self-service analytics. With its excellent query performance, analysis can be refined produced immediately, leading to even clearer insights and smarter actions.
About CALUMO
The CALUMO Group (www.calumo.com) is a leading provider of Performance Management solutions for enterprise-wide reporting planning and Business Intelligence. Since 1998 the group has successfully delivered solutions to a wide range of enterprises from SME’s to some of the largest listed companies and government organisations. These solutions provide quantifiable and valuable business insight, offering a single platform from which to integrate Corporate, Financial and Operational performance and objectives.
The Group is a Microsoft Gold Certified Partner in Business intelligence (achieving full competency in both Platform and Performance Management Specialisations), Data Management Solutions and ISV/Software Solutions.