xcelsius Dashboard

10 Ways To Create xCelsius Dashboards for External Entities

Table of Contents

How To Leverage External Data in A Dashboard

We frequently see a need in the market for companies and government entities to monitor the status and activities of external market players.  For instance, an institution such as the Federal Deposit Insurance Corporation, which is the entity that, among other activities, guarantees your savings account in case the bank fails.  Unfortunately, in today’s environment, many banks have failed and many more are likely to fail.

A Real World Example

Part of our xcelsius dashboard tutorial series

One example Dashboard requirement that might result from this type of  oversight activity is to monitor the various aspects of the banks insured by the FDIC.


Just brainstorming here but the characteristics and or design approaches of a dashboard to help in this monitoring would include the following capabilities:


  1. Ability to monitor the leverage of each bank, down to the branch level, by product.  This would be considered a Key Performance Indicator (KPI) that would need to be reflected on the Dashboard.

  2. Ability to aggregate the overall exposure of the FDIC to potential claims both from individual banks and the overall banking system

  3. Use of XBRL as a common language across the entities.  I remember clearly reading that at the beginning of the 2008 financial crisis, the failure to adopt XBRL by all entities meant it was impossible to easily get the ’info’.  This is considered a critical facilitating technology.

  4. Incorporation of automatic process chains and meta chains, which are programmatic devices to automate the system and to provide automatic alerting when anomalies occur.  This is how you enable real-time Performance Indicator monitoring and control systems.

  5. A common data warehouse, such as SAP BW, which can stand alone without the underlying ERP systems that many banks use, such as the SAP IS-Banking Solution.

  6. Alerting capabilities-Any dashboard must pro-actively alert the relevant users to pre-planned risk events, i.e. leverage ratios above both the target and the system mean, median and mode.

  7. Push capabilities for information broadcasting, such that all concerned users can receive it on any device, anytime, anywhere.

  8. Ability to provide different views of the same data.  For example, depositors might want to be able to monitor their own banks leverage and risk levels, but have no need or ability to interpret system wide exposure levels.

  9. Due to the extremely high data volumes involved in the underlying systems, technologies such as SAP HANA might be a consideration, although not strictly necessary in the initial design stages.

  10. Be integrated into a larger risk management process.


Though there are doubtless many other aspects of dashboarding to consider when integrating external entities into your project, such as interactive visual analytics design requirements, we have found these to be key in our engineered approach.

Sample xCelsius Finance Dashboard


Additional SAP xCelsius Dashboard Best Practices

In addition to the design approaches mentioned above, we've also prepared a checklist of xcelsius dashboarding best practices.  We suggest you download and print it out, hang on your project teams wall, and refer to it frequently as you build SAP Dashboards.



xCelsius Dashboard Best Practices


More reading:

10 Critical Chain Project Manager Tips

How To Use Google Keyword Planner Tool Tutorial

Top 10 Benefits for Financial Analysis in the Latest SAP EP4

Learn What Tools To Use To Investigate IS-Mill Functionality

BusinessObjects Explorer Best Practices

Take a Deeper Dive into Aircraft Cockpits Vs Dashboards





Download SAP BW Mindmap

Learn what SAP Business Warehouse is and what it does in under five minutes

Get this Mindmap

Lonnie D. Ayers, PMP

About the Author: Lonnie Ayers is a Hubspot Certified Inbound Marketing consultant, with additional certifications in Hubspot Content Optimization, Hubspot Contextual Marketing, and is a Hubspot Certified Partner. Specialized in demand generation and sales execution, especially in the SAP, Oracle and Microsoft Partner space, he has unique insight into the tough challenges Service Providers face with generating leads and closing sales using the latest digital tools. With 15 years of SAP Program Management experience, and dozens of complex sales engagements under his belt, he helps partners develop and communicate their unique sales proposition. Frequently sought as a public speaker in various events, he is available for both inhouse engagements and remote coaching.
Balanced Scorecard Consultant

He also recently released a book "How to Dominate Any Market - Turbocharging Your Digital Marketing and Sales Results", which is available on Amazon.

View All Articles by Lonnie D. Ayers, PMP

The SAP Blog

Subscribe to our blog and receive SAP BW Updates, demand generation, inbound marketing, sales enablement, technology and revenue generation insights and ideas delivered right to your email.