Tips & Tricks IV- Consolidation of Summary Case Data to Executive Dashboards and Corporate Dashboards.

The usual final resting place of operational data is a data warehouse.

With many systems in place within a corporation, data warehouses traditionally have been the only place where KPI (Key Process Indicator) calculations can be initiated.

There are two problems with KPIs.

The first is their value is based on an ability to trend them from one day/week/month to the next. If KPIs are being retired and replaced with new KPIs, there is not much to trend.

The second problem is there is no guarantee that management is looking at the right KPIs.

One approach that removes the focus from the past and puts this on the present and the future is to park KPIs at the corporate KnowledgeBase (Kbase) where connect-the-dots initiatives can be engaged to verify the validity of KPI values and seek out new candidate KPIs.

Once an organization has a means of scheduling work and receiving decision support during the performance of work, it can leverage data exchange to mirror operational data to both its corporate data warehouse and to the corporation’s Kbase.

There are no magic formulas for constructing Kbases.

Basically, a corporate Kbase needs to inventory infrastructure (capital, access to capital, land, plant, processes, equipment, tools, suppliers, staff, customers). Kbases also need to consolidate information relating to technology, industry trends, changing legislation and competitors.

It’s easy with a Kbase to have access to 50,000 or more documents all at one computer screen.

Success with Kbases comes when:

#1) There is a realization that infrastructure is perishable and that unless preserved and enhanced, it decays or goes away. The elements of infrastructure frequently are interconnected in complex ways.

#2) The resources required to make good use of infrastructure are in short supply.

#3) The effort to build and maintain a Kbase is minimal compared to having to hunt for information needed to make decisions.

#4) Operational level data can be easily pushed to a Kbase if the organization has interoperability.

Most Kbases only stock information.

Putting information and data together makes for better planning, better decision-making and better control.

List of Posts in this set:
Tips & Tricks I – Work Scheduling
Tips & Tricks II – Decision Support/Work Performance at Cases
Tips & Tricks III – Data Exchange
Tips & Tricks IV- Consolidation of Summary Case Data to Executive Dashboards and Corporate Dashboards.


Management consultant and process control engineer (MSc EE) with a focus on bridging the gap between operations and strategy in the areas of critical infrastructure protection, major crimes case management, healthcare services delivery, and b2b/b2c/b2d transactions. (C) 2010-2019 Karl Walter Keirstead, P. Eng. All rights reserved. The opinions expressed here are those of the author, and are not connected with Jay-Kell Technologies Inc, Civerex Systems Inc. (Canada), Civerex Systems Inc. (USA) or CvX Productions.
This entry was posted in Case Management, Data Interoperability, Database Technology, Decision Making, Enterprise Content Management, Strategic Planning. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s