Loading...
Managing data as a business asset.

Tech2Tech

Tech Knowledge

Stop the Chaos

Managing data as a business asset.

After a decade of enterprise resource planning (ERP) and two decades into data warehousing, many business executives are still frustrated over their inability to trust their company’s data. They have spent millions on new technologies, only to find that the state of their data assets is deteriorating and losing value rather than improving. One big reason for this continuing data erosion is that companies do not manage their data as a business asset.

In order to do that, they need an enterprise-wide data governance program, which includes a set of policies, processes and resources to standardize data, control data redundancy and share a single view of the business across the organization. A critical key to this effort is to clearly define the roles and responsibilities of IT and business.

Enforcing Data Governance

Implementing a data governance program requires a new mental model and some organizational changes.

Data governance cannot be assigned solely to one specialized group; it requires collaboration between business people and technicians. For instance, the business side must participate in the roles of data owners and stewards. The more technical data administration is performed by a specialized team called the enterprise information management (EIM) group, which is typically staffed by an administrator, enterprise data modeler, metadata administrator and data quality analyst. Additionally, data custodians in IT, such as developers and database professionals, have the ultimate responsibility for data integrity.

Figure: Data Governance Organization

Click to enlarge

Three levels of data governance responsibilities must be implemented for an organization to be most effective:

  • Strategic layer. Business executives should provide collective sponsorship for the data governance program by assigning data owners, giving them the authority to set policy for the data assets in the organization and communicating their authority through all layers of management. The owners in turn will assign stewards in their business units and make them accountable for the quality and integrity of the data. People in the strategic layer can also be considered as the data governance council.
  • Tactical layer. Data stewards must collaborate with the administrator, enterprise data modeler, metadata administrator and data quality analyst from the EIM group in creating the enterprise data model, managing the metadata, administering the lexicons, correcting dirty data and so on. This level contains the active work force of a data governance program.
  • Operational layer. Custodians execute data policies and rules at the operational layer. Database architects and administrators implement policies and rules in their database definitions and processes. Developers and other technicians embed the policies and rules in their programs when they create, modify, move, copy or delete data. It is also their responsibility to communicate and escalate any discovered data discrepancies to the stewards and EIM staff.

Different Standards

A CFO is approached by the CEO and asked for an accounting of the company’s financial assets. The CFO gives a vague response indicating a lack of knowledge of the corporate bank accounts, what’s in each account and the status of accounts receivable. When asked about the intended use of the corporate assets, the CFO replies, "There is no plan for their use." The CFO (and probably the CEO) would soon be pursuing new professional interests.

Would the same hold true if the CIO were asked for an accounting of the company’s data assets? No one would probably even blink an eye.

That’s precisely why companies need to begin treating their data as a business asset and why executive leadership must be dedicated to business integration.

—L.T.M.

Data Has Value

When planning to institute a data governance program, senior executives must accept that data has business value and that it should be managed like any other business asset. They must be willing to sponsor and fund a data governance organization and assign owners and stewards from both the business and IT sides of the organization.

Success will require new practices, disciplines, methods, applications, infrastructure, tools and techniques, roles and responsibilities, and policies and procedures.

Implementing these changes must be systemic and holistic, not isolated and sporadic. To avoid data chaos, executive leadership must be dedicated to business integration.

Data Governance Organization Team

Data governance cannot be assigned solely to one specialized group; it requires collaboration between business people and IT technicians. The business side’s roles focus on data ownership. The more technical data administration is performed by a specialized team called the enterprise information management (EIM) group. And, finally, data custodians in IT have the ultimate responsibility for data integrity.

  • Executive sponsors: Data governance is an enterprise-wide practice that must be supported by all business executives to be most effective. Sponsorship must come from the collective body of senior business executives rather than from one person. These sponsors fund the staffing of the EIM group, communicate goals and guidelines throughout the organization, identify data owners and play the role of ultimate arbiters on escalated data disputes.
  • Data owner: A data owner must specify what information can be accessed, when and by whom. An owner also establishes business rules that will be coded into program edits, validation and data cleansing code, database management system (DBMS) specifications and as metadata in the metadata repository.
  • Data steward: The most important duty of a data steward is to continuously evaluate and improve the processes that contribute to data quality. Stewards enforce the policies and business rules established by the owners, find and correct dirty data, resolve disputes among business units, help reconcile data from disparate systems and ensure data integrity.

Data administration is a function of the EIM staff that consists of IT technicians who maintain, catalog and standardize corporate data. This is done by establishing data-related standards, policies and procedures that are reflected in the enterprise data model (EDM) and the business metadata.

  • Data administrator: A data administrator establishes and enforces rules for data modeling, writing formal data definitions, creating fully qualified data names, documenting data domains and creating standards for metadata.
  • Data quality analyst: A data quality analyst delivers quality report cards to the owners and collaborates with stewards to profile the operational source data to uncover values that violate the business rules.
  • Enterprise data modeler: An enterprise data modeler merges application-specific logical data models into one enterprise data model. This is an extremely important activity because many data collisions are not discovered until data names, definitions and domains from different application-specific logical data models are merged, requiring resolution of differences by working with stewards and owners.
  • Metadata administrator: A metadata administrator maintains the metadata repository. Metadata is collected through data modeling tools, spreadsheets, text documents, DBMS tables and so on. The administrator integrates and loads metadata from these sources into the repository and delivers the metadata through reports, online access or a help function (wizard).
  • Data custodian: Any IT technician who touches data is a data custodian. This can either be a database architect or administrator who is responsible for the physical databases, or it can be a developer who creates, updates or deletes information from files and databases. Custodians must be mindful not to introduce errors into their processes that might corrupt the data in the files and databases.
  • Read "Data Governance Glossary"  to review some data governance terms and definitions.

    —L.T.M.


    Your Comment:
      
    Your Rating:

    Comments