As a professional you know that the worlds of Finance and IT are moving closer and closer to each other. Your organization is looking for a way to harvest vast amounts of data within their domain and use it to its advantage.
Our customers want to implement a data-driven mindset within their company. They’re achieving this by a broader consumption of data and combining several data sources in one reporting platform.
A proper integration makes it possible for you to analyze and gain much more insights:
- Project members are able to see their own real-time financials and project data in one report.
- Store managers can see their KPI’s and compare these with the KPI’s of their peers to make improvements.
- Companies get a concise overview of the entire corporates’ performance with the ability to zoom in and out on details.
And so on! In this article, we will discuss all the possibilities for companies using CCH Tagetik or PowerBI and analyze this combination.
As companies have been using their CPM platforms for a while now, rich data has been created and collected there. Most of our clients have been reporting from their CCH Tagetik environments for several years now. Within this environment their financial statements can be viewed from intersections between dimensions such as: Companies, Costcenters, Lines of Business, Products, and Projects. But getting to share this knowledge with the people steering the business is not always optimally configured. In order to consume this data on a lower level within the business, experience and investment into the inner workings of the platform is required.
On the other hand, there is the PowerBI environment where easy to use dashboards can be defined and analyzed. But getting the data into PowerBI can be a challenge. A proper connection would, for example, not only bring in the financial data, but also the reporting structures. So the administration is centered into the platform where most of the business logics are. The ability to create your own reports is not without risks, however. Improper use of visualizations can lead to misinterpretations, which should be avoided. Just ask two analysts to create a visual out of some data, and most often you will receive two different visualizations.
There are methods however to prevent that. Just think about it, if a composer from Argentina creates a masterpiece, a musician from China is able to play it. Why shouldn’t you use a standard for visualisation within your own company? The good news is that there already is a standard for it: the International Business Communication Standards, better known as IBCS. And wouldn’t it be nice if the consumption of your reports would automatically follow these standards? While ideal, some companies are not yet able to correctly disclose their vast collection of data in such a way.
In order to get to the situation described in the opening of this article, two essential pieces of the puzzle must be found. Firstly, you need expertise in CCH Tagetik to disclose the proper data and expertise in PowerBI to not only successfully visualize. But also adhere to the standards, so you can significantly improve the efficiency of your analysis and the accuracy of your decisionmaking[1]. Now you can invest into these two roles separately, but you can also buy it off the shelf.
Over at Finext, we invested into these two pieces already and came up with our official CCH Tagetik to PowerBI connector. An off-the-shelf product that you can install in your CCH Tagetik and PowerBI environment to periodically send all required data from your system of record to your dashboarding platform. And with the use of the ZebraBI plug-in in addition to our connector you can make sure that all reports follow the IBCS methods, increasing the accuracy and efficiency of data consumption within your departments too. The standardisation of the product makes it easily implementable: within a few days you can roll out to your end-users. You probably spend more time deciding on whether to do it than to actually do it.
So in short, connecting your company with its data allows you to get the following:
We tell our story in a series of videos. In these three videos we look at the proposition from three angles:
Choose whichever angle suits you best and come explore the endless possibilities with us. If you want to skip ahead of the queue and want to talk directly to us about it, let us know by leaving your contact details in the box below.
[1] Research by the University of Munich has shown that the efficiency of analysis improves by +46% and the accuracy of decisionmaking improves by +61% when using the standards of IBCS in your reporting.
We will contact you soon!
Forrester Research predicts that companies with smart Data & Automation programs will not only overtake their competitors, but crush them. When you integrate Data & Automation well, you’ll have a big head start over the competition. During “The Future of Data & Automation: Your Roadmap for 2025” we give you the tips and tricks you need to let your solid ideas take flight.
Although it is essential, the value your dashboard can achieve is not entirely dependent on the data you have available. It can become equally important to show the story behind your data in the most efficient way possible while critically assessing the audience for and purpose of your dashboard. A lack of focus on those fundamentals can result in an abundance of reports created without properly considering business needs.
Use this webpage for information about more than 10 solutions that we think will help your solid ideas take flight. A Data & Automation solution Line Up so to say.