A Case Study: Turning Data into Actionable Information

My previous blog post, Exploring the Data/Information Architecture Domain, established what Data/Information Architecture is and touched on the benefits and issues surrounding the topic. In this blog post, I provide a mini-case study summarizing how ABC Bank was able to turn data into actionable insights and information that helped improve the stability of the organization’s Application Architecture.

ABC Bank is a fictitious regional bank located in multiple East-Coast states. The bank’s Lines of Business use several monolithic applications to drive its business forward. Throughout history, these applications have been the subject of numerous critical outages causing upset customers and lost business.

To rectify this issue, ABC Bank needs to understand the root cause of the critical outages and find a way to prevent them before they even occur or drastically reduce the mean time to resolution (MTTR). Being able to predict/prevent these outages would yield significant benefits for ABC Bank, but where should they start?

The answer lies in data and the bank’s ability to convert data into useful insights and information, commonly referred to as “telemetry.” By default, the information systems used by ABC Bank collect raw data regarding the system’s performance. Whether the system is server infrastructure-based, application architecture-based, or reporting-based, IT practitioners in ABC Bank need access to the data and need to be innovative to make the information useful and actionable. Refer to Table 1 to see examples of data sources, data points, and how ABC Bank could potentially use the data to help reduce the number of critical outages experienced.

Table 1: Raw data sources, data points, and their usefulness at ABC Bank.

Using the data points in Table 1, IT practitioners could create alerting and automated self-healing mechanisms to address the problem. Of the three data sources listed, Server Infrastructure and Application Architecture contain the data points that, when addressed, had the most significant positive impacts on the organization.

Using data retrieved from the server infrastructure, IT practitioners could create automated mechanisms to detect and correct issues before they become problems. For example, if the primary disk drive on a Microsoft Windows Server (“C”) became full, the server would crash, potentially causing the entire system to become unavailable. IT practitioners were able to structure server disk data, and automate the analysis of disk drive usage across its servers, searching for drives that are 95% utilized. The automated process would analyze the data and produce a list of servers that were in imminent danger of crashing due to a full disk drive (over 95% utilized). This data would then be fed into another automated process that consumes the list of servers with high disk space utilization and launches a process that deletes pre-approved temporary system files and log files. The automated data analysis and self-healing actions essentially eliminated the problem of ABC Bank’s disk drives becoming full and crashing the systems.

A similar use case can be found in application architecture. Common application-related issues can often be identified before they become problems by analyzing data collected within the application architecture. For example, IT practitioners can establish baseline execution times for processes and workflows within applications. One early warning sign of an information system (application) issue is when a process’s execution time starts to become greater than the average of that process’s execution time throughout history. IT practitioners in ABC Bank have been able to analyze this data and create mechanisms to alert team members of potential issues. Some mechanisms have been developed to fix the issues without human intervention. Additionally, data consistency errors have haunted the application architecture of the organization. Creating data structures and automated quality management validation processes have led to the reduction of application-based critical outages.

Lastly, IT practitioners were able to find valuable data within the organization’s IT Support Ticketing System. ABC Bank was able to identify two key data points from this system: (1) support tickets and their metadata, and (2) metrics regarding the frequency, occurrence, and types of system/application issues that occur within the organization. With this information, ABC Bank could determine when problems were more likely to occur, what systems the issues were likely to occur in, and gain a deeper understanding of how the problem and how to resolve it. The new capability allowed ABC Bank to better plan staff members’ time allocations and on-call shifts.

As discussed in my previous blog post, Exploring the Data/Information Architecture Domain, the Data/Information Architecture domain supports all other domains within Enterprise Architecture (EA). Figure 1 below summarizes how the Data/Information Architecture domain supports all other EA domains.

Figure 1: Modeling illustration of a simplified summary of how D/IA supports other EA domains.

Although this is a simplified case study, it showcases the value of the Data/Information Architecture domain well. By identifying data sources and data points and structuring the data, ABC Bank was able to create mechanisms that significantly reduced the number of critical system outages by as much as 28% in one year. In these terms, the Data/Information Architecture domain contributed to ABC Bank’s goal of reducing critical outages, which directly corresponds with the organization’s “customer first”/“supplying the best customer experience possible” strategies.

Exploring the Data/Information Architecture Domain

Introduction

Figure 1: Four domains (layers) of Enterprise Architecture [1].

Enterprise Architecture (EA) is comprised of four domains. The four domains of EA are illustrated in Figure 1: (1) Business, (2) Data, (3) Application, and (4) Technology. Today’s blog post will focus on EA’s “Data/Information Architecture” domain.

Before exploring the domain, let’s address the slash (“/”) in the room. Is data the same thing as information? Many people and organizations use the terms interchangeably, but according to Haissam Abdul Malak from, TheeCMConsultant.com, there is a difference. Malak says, “Data is raw, unanalyzed, unorganized, unrelated, uninterrupted facts that are used to derive information after analysis. Information, on the other hand, is acquired when data is analyzed, structured, and given composure or context to make it useful.” [2].

One of the most important assets to any organization is data. Data enables organizations to learn about their customers’ needs, determine how products are used, improve decision-making, discover hidden insights, find solutions to problems, back up points made in discussions, and much more! With digital modernization sweeping across most industries, many organizations are aware that data is an asset but knowing what to do with data (data structure, storage, etc.) and how to turn it into usable information remains a challenge for many.

What is Data/Information Architecture?

Many organizations may wonder, “What exactly is the Data/Information Architecture domain?”; frankly – it’s a great question! When researching the topic, several definitions can be found. However, most definitions share a common foundational concept: Data/Information Architecture is the structural organization of data assets within an enterprise [3] [4].

Gartner Inc. defines Enterprise Information Architecture (EIA) as “the part of the EA process that describes – through a set of requirements, principles and models — the current state, future state and guidance necessary to flexibly share and exchange information assets to achieve effective enterprise change.” [5].

Through these definitions, an EA practitioner may synthesize that Data/Information Architecture is the understanding of how an organization’s data is structured in its current state, identifying the desired future state, and achieving the future state. It is vital to organizations that data can be standardized and shared with the entire organization to enable practitioners to gain actionable information and insights.

Benefits of Data/Information Architecture

Organizations in the process of defining a Data/Information Architecture, or already possess an architecture, will realize many benefits they may not have seen without the architecture in place. Some examples include:

• Data/Information Architecture provides conceptual, logical, and physical descriptions of data;
• Creates an authoritative source of truth for organizational data. Commonly referred to as a “System of Record” (SOR);
• Provides a way to collect and connect data throughout the organization;
• And allows for a common understanding of data definitions and metadata for the entire organization.

Issues Associated with Data/Information Architecture

Like anything, Data/Information Architecture comes with issues that challenge organizations. The bullet points below are examples of Data/Information Architecture issues:

• Most of the data sharing across applications is a technical success but does not meet the needs of the business.
• High cost of data storage.
• Most IT infrastructures already in place are not capable of scaling to address the high demands for data sharing.

How does Data/Information Architecture Support Other Domains Within EA?

The Data/Information Architecture domain supports the other three EA domains in several ways. Giulio Barcaroli et al. provide a model showing how the Information Architecture domain supports the others; see Figure 2 below.

Figure 2: Interactions between the Enterprise Architecture layers [1].

As shown in Figure 2, all EA domains support each other. The Information Architecture domain is no exception. From providing a framework for Business Architecture to providing Application Architecture with standardized formats to providing Technology Architecture with data structures, and instructions to govern data, the Data/Information Architecture domain is an important domain with much value to offer organizations.

In summary, the Data/Information Architecture domain of EA represents the current/future state of data structure and data systems within an organization. Many benefits can be realized once a data architecture is implemented; however, a few common issues will need to be addressed. The Data/Information Architecture domain supports the other EA domains and is an essential asset to organizations.

References

[1] G. Barcaroli, A. Fasano, P. D. Falorsi and N. Mignolli, Business Architecture model within an official statistical context, Rome, 2014.

[2] H. Abdul Malak, “Data vs information: Whats the difference?,” 26 June 2022. [Online]. Available: https://theecmconsultant.com/data-vs-information/. [Accessed 24 September 2022].

[3] Penn State University, “L03 activities: The enterprise data architecture,” 2022. [Online]. Available: https://psu.instructure.com/courses/2213347/assignments/14192445?module_item_id=36154462. [Accessed 25 September 2022].

[4] Btoes Insights, [Online]. Available: https://insights.btoes.com/what-is-enterprise-architecture#:~:text=Data%20architecture%20domain%20%E2%80%93%20describes%20the,and%20continuously%20evolve%20business%20processes.. [Accessed 25 September 2022].

[5] Gartner, Inc., “Gartner Glossary,” [Online]. Available: https://www.gartner.com/en/information-technology/glossary/enterprise-information-architecture#:~:text=Enterprise%20information%20architecture%20(EIA)%20is,to%20achieve%20effective%20enterprise%20change.. [Accessed 25 September 2022].

[6] Harvard University, “Architecture layers,” [Online]. Available: https://enterprisearchitecture.harvard.edu/domains. [Accessed 24 September 2022].

[7] T. Friedman and A. White, Implementing the Data Hub: architecture and technology choices, Gartner Inc., 2018.