Tableau is a leading visualization tool used by companies world-wide to enable easy data analysis with interactive dashboards. However, to drive faster and better decisions across the organization, the benefits multiply when Tableau is delivered with a directly integrated with Planning and Financial Reporting solution.
Mostly thanks to vendors mixing terminologies, many people have a hard time distinguishing between dashboards, financial reporting and planning solutions. Here is a simple set of definitions:
All the tools above provide flexibility for trained users to design their own layouts, something which enables these technologies to work across all industries. Here is a page with 100’s of formatted examples.
Dashboard tools like Tableau fall into a category of software referred to as Business Intelligence (BI), and financial reporting and planning tools belong to a category often referred to as Corporate Performance Management (CPM). As explained above, BI and CPM tools each perform unique functions to help an organization drive faster and better decisions. Due to their complimentary nature, when these tools are closely integrated, users can easily move back and forth between them and still have “one version of the truth” in their planning and analysis processes.
Many BI and CPM vendors do not do a great job integrating with each other’s application. Instead, usually to capture license and subscription revenue, they try to incorporate everything inside their own product. In other words, a dashboard tool trying to use its functionality to offer financial reporting and budgeting, or a CPM tool providing native dashboards. These all-in-one approaches are well known in the software space and almost always leads to sub-optimal functionality, slow development cycles, and a poor user experience. The result is often expensive, consulting-intensive projects and solutions that tend to die a relatively quick death as users instead seek functionality that solves their specific dashboard or CPM needs.
On the other hand, with a best-of-breed approach, the BI vendor focuses on building a market-leading dashboard offering, while the CPM vendor focuses on streamlining financial reporting and planning processes. An example of this is Tableau and Solver. When best-of-breed solutions are well integrated, they tend to provide higher return on investment (ROI and a longer useful life than the all-in-one approach.
Financial Reporting and Planning Integrated with Tableau Dashboards
An API (application programming interface) is a technology that lets different vendors connect their solutions using standard protocols as compared to heavily customized consulting-driven integrations. Using Tableau and Solver as an example, Solver’s cloud-based CPM application connects to the Tableau API interface to deliver data and dimensions directly from Solver to the Tableau cloud. Benefits of such standard integration include:
In conclusion, as a Tableau customer, you have a best-of-breed BI solution to drive powerful visualizations that support decision-makers. When you also deploy a best-of-breed CPM solution like Solver that automates financial reporting and planning, the true “magic” lies in a flexible and automated integration between the two technologies. This enables Tableau to easily utilize and represent the budgets, forecasts and financial data delivered by the CPM solution. The result: Faster and Better Decisions!