BI Dashboard Through Smartview & TIBCO Spotfire

By: CloudADDIE
Published: December 1, 2018

The vendor’s team was brought in to develop a 7-page dashboard of 24 KPIs, including a red/green scheme to indicate favorable/unfavorable performance results. The president of the company had requested the development of a highly customized dashboard for his office. The client set a deadline for 2.5 months. After the first month, the vendor communicated that only 1 of 7 pages would be completed within the anticipated project timeline. The client’s Senior Director of IT removed the vendor team and recruited the Paradigm SES team to take over leadership of the project.The Paradigm SES team was brought in to assist the vendor with the design and implementation of the dashboard.

OUR CLIENT

A Fortune 500 industry leader and ongoing client. Environment 14 product lines 50 sub-product lines 7 business pillars (functions) 120+ users (North America) The client’s organizational structure was comprised of 6 key business pillars: HR, profitability and cost, finance, health safety and environment, sales and marketing, and operations. Each of these functions managed its own data sources independently.

THE CHALLENGES

Give select stakeholders the ability to view and analyze 24 KPIs in one location Develop a customized dashboard for the president of the company The sales and marketing pillar, along with profitability and cost, had begun utilizing a TIBCO Spotfire dashboard to consolidate and communicate important KPIs daily. However, the other functions were still relying on monthly and quarterly reporting to support decision making, and the C-level executive team did not have a consolidated source of business-critical metrics. A critical step in the success of this project was the mapping of data from the 6 individual business pillars into a consolidated source with 100% accuracy. With only 1.5 months left before the project deadline, the Paradigm SES quickly went to work.

SOLUTIONS

Software Solutions used in this project include:

  • Smartview
  • TIBCO
  • Spotfire

Building from previous data clean-up work with this client, they consulted with senior management and subject matter experts representing each pillar to extract data from each source and map it to the new dashboard design.

RESULTS

The CloudADDIE team successfully delivered this project in 1.5 months while producing savings against the original vendor’s budget. A dashboard was launched for more than 120 users, and a customized dashboard was designed specifically for the president of the company. Users were able to drill down into “red” KPIs to understand where immediate response was required. Data refreshed every 2-3 seconds, providing users a real-time look at performance. Users responsible for creating a flash budget were able to take advantage of the KPI data and identify where action was needed across the company. As the client moved forward to model this dashboard approach in other geographies, including the Middle East and Africa, the CloudADDIE team was hired to lead in-country training and share best practices and strategies for dashboard development.

FREE CONSULTATION

Ready to see how we can create Custom Reports & Report Packaging for your company?

Schedule your Free Consultation, to see it in action!
Contact Us!

We offer Autonomous Systems for EPM Cloud Applications such as Oracle Planning & Budgeting Cloud Service (PBCS/EPBCS), Financial Close & Consolidations Cloud Service (FCCS), Enterprise Data Management Cloud Services (EDMCS), Account Reconciliation Cloud Service (ARCS), Profitability & Cost Management (PCM) and more.