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, among others. 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 analysed, 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 visualisations 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 visualisations. 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: You need expertise in CCH Tagetik to disclose the proper data and expertise in PowerBI to not only successfully visualise, but also adhere to the standards so you can significantly improve the efficiency of your analysis and the accuracy of your decisionmaking. 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.
 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!
In this interview, Jonathan Aardema talks with Prof. Eric Postma (professor of Cognitive Science and Artificial Intelligence at the University of Tilburg) about the why, how, and what of artificial intelligence applications. What do we see in practice, and what does science say about it?
Every year Tableau invites its most valuable partners to kick off the new year together. The theme for this year was Accelerate, so let’s get right to the point. This exciting event was focused on three main areas.
Keeping your skills up to date is crucial when you work with the newest technology. At Rockfeather, we challenge each other to be the best version of yourself. That’s why I attended the mastering DAX course. DAX (Data Analysis Expressions) is a formula expression language. Next to Power BI, DAX is applied in Excel Power Pivot and tabular models in SQL Server. Learn it once, use it tomorrow.