Data Analytics Capability Maturity Assessment

A enterprise data strategy is a business plan for leveraging an enterprise’s data assets to maximum advantage; it sets the direction and goals and defines an approach to solving the key data challenges facing the enterprise.​

A data strategy should include business plans to use information to competitive advantage and support enterprise goals. Data strategy must come from an understanding of the data needs inherent in the business strategy: what data the organization needs, how it will get the data, how it will manage it and ensure its reliability over time, and how it will utilize it. ​Typically, a data strategy requires a supporting Data Management program strategy – a plan for maintaining and improving the quality of data, data integrity, access, and security while mitigating known and implied risks. The strategy must also address known challenges related to data management.

In many organizations, the data management strategy is owned and maintained by the Chief Data Officer (CDO) and enacted through a data governance team, supported by a Data Governance Council. Often, the CDO will draft an initial data strategy and data management strategy even before a Data Governance Council is formed, to gain senior management’s commitment to establishing data stewardship and governance

Many organizations recognize that their data is a vital enterprise asset. Despite that recognition, few organizations actively manage data as an asset from which they can derive ongoing value. Deriving value from data does not happen in a vacuum or by accident. It requires intention, planning, coordination, and commitment. It requires management and leadership.

Data management (DM) principles are usually formulated during data strategy development as part of a DM framework and are the highest order propositions that serve as the foundation for DM. ​

Typically, the first principle within the DM framework will state something like data is recognized as a valuable, enterprise-wide asset. The DM principles within the DM framework are supported by policies, standards, and controls.​

DM policies are short statements of management intent and fundamental rules governing data from creation through to destruction. ​Standards and controls are the measures and mechanisms by which the enterprise maintains the acceptable performance of its DM.​

A Data Management (DM) professional is any person who works in any facet of DM (from technical management of data throughout its lifecycle to ensuring that data is properly utilized and leveraged) to meet strategic organizational goals. DM professionals fill numerous roles, from the highly technical (e.g., database administrators, network administrators, programmers) to strategic business (e.g., Data Stewards, Data Strategists, Chief Data Officers).

​In order for data governance to make its best impact, several working groups, capability centers and decision-making bodies will need to be established and staffed with DM professionals and stakeholders. ​

Enterprise Data Architecture defines standard terms and designs for the elements that are important to the organization. The design of an Enterprise Data Architecture includes depiction of the business data as such, including the collection, storage, integration, movement, and distribution of data.

Ideally, Data Architecture should be an integral part of enterprise architecture. If there is not an enterprise architecture function, a Data Architecture team can still be established. Under these conditions, an organization should adopt a framework that helps articulate the goals and drivers for Data Architecture. These drivers will influence approach, scope, and roadmap priorities.

The principal goals are to:

Identify data storage and processing requirements.
1. Design structures and plans to meet current and long-term enterprise data requirements
2. Strategically prepare the enterprise to quickly evolve products, services, and data to take advantage of business opportunities inherent in emerging technologies.

Data Storage and Operations includes the design, implementation, and support of stored data, to maximize its value throughout its lifecycle, from creation/acquisition to disposal.

Data Storage and Operations includes two sub-activities:

• Database support focuses on activities related to the data lifecycle, from initial implementation of a database environment, through obtaining, backing up, and purging data. It also includes ensuring the database performs well. Monitoring and tuning are critical to database support.
• Database technology support includes defining technical requirements that will meet organizational needs, defining technical architecture, installing, and administering technology, and resolving issues related to technology.

Database administrators (DBAs) play key roles in both aspects of data storage and operations. The role of DBA is the most established and most widely adopted data professional role, and database administration practices are perhaps the most mature of all data management practices. DBAs also play dominant roles in data operations and data security.

Data modelling is the process of discovering, analyzing, and scoping data requirements, and then representing and communicating these data requirements in a precise form called the data model. Data modelling is a critical component of data management. The modelling process requires that organizations discover and document how their data fits together. The modelling process itself designs how data fits together.

Data models depict and enable an organization to understand its data assets. exist at three levels of detail: conceptual, logical, and physical. Each model contains a set of components. Examples of components are entities, relationships, facts, keys, and attributes. Once a model is built, it needs to be reviewed and once approved, maintained.

Within the context of databases, a data definition language (DDL) to used define a data model; a data manipulation language (DML) to insert/update/delete data records and data control language (DCL) is used to control access to data. Data query languages (DQLs) simply the process of retrieving data records which meet the criteria of interest (e.g. all customers in arrears) without the need to know how the data is stored in the database.

Reference data is used to organize or categorize other data, or for relating data to information both within and beyond the boundaries of the enterprise. Usually consists of codes and descriptions or definition. For example, Order Status: New, In Progress, Closed, Cancelled; may incorporate external standards, e.g. postal address or industry classification; it may be used for computation, e.g. currency exchange rate; it may also be quite abstract, e.g. synonym list.

Master Data, which encompasses reference data, is data about the business entities (e.g., employees, customers, products, financial structures, assets, and locations) that provide context for business transactions and analysis. Entities are represented by entity instances, in the form of data / records. Master Data should represent the authoritative, most accurate data available about key business entities. When managed well, Master Data values are trusted and can be used with confidence.

In most organizations, various projects and initiatives, mergers and acquisitions, and other business activities result in multiple systems executing much the same functions, isolated from or uncoordinated with each other. These conditions inevitably lead to inconsistencies in data structure and data values between systems. Both can be reduced through the management of Master Data and Reference Data. ​

A Enterprise Data Warehouse (EDW) is a combination of two primary components:

• An integrated decision support database and the related software programs used to collect, cleanse, transform, and store data from a variety of operational and external sources.
• To support historical and analytical requirements, an EDW may also include dependent, copied subsets of data known as data marts

Data in placed in the EDW through a so called “Extract, Transform, Load” or ETL process. A properly designed ETL system extracts data from the source systems, enforces data quality and consistency standards, conforms data so that separate sources can be used together.

Big data is a term that has become associated with warehousing where the volume of data poses specific challenges that are unique to large scales of data, which are often solved through a range of techniques including parallel and distributed processing.

In many respects big data can be conceived simply as “bigger” data. Despite Moore’s law and the rapid progression of technology, the amount of data that can be captured, processed, and analyzed, relative the amount of data in the observable world, is small. ​