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.

  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’.

  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.

  5. A common datawarehouse, 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

 

 

 

 

 

Download SAP BW Mindmap

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

Get this Mindmap

Lonnie Ayers

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 Ayers

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.