Data Quality Factors

INTRINSIC

· Accuracy

· Lineage

· Semantic

· Structure

CONTEXT

· Completeness

· Consistency

· Currency

· Timeliness

· Reasonableness

· Identification

Data Consistency

Presentation:  Common presentation formats for each data element are defined.  Data elements that are presented in a screen or a form will conform to the defined presentation format.

Presentation completeness:  Each data presentation format can convey all information within the attributes.  Every defined presentation format will be verified to ensure that it can present all values the displayed attribute can take.

Null presentation:  Standards for the presentation of missing information for each data type are defined.  Any data element that may be null must have a defined representation for the absent value. If there are multiple reasons for absent values that can be captured in the data (e.g., "unavailable" vs. "not applicable") there will be multiple null representations.

Capture and collection:  Data entry edits and data importation rules should be defined for each data element.  Participants must apply the defined data edit and collection rules.

Data Timeliness

Accessibility:  Newly posted records should be available to enterprise applications within a specified time period. Policies specifying acceptable time delays must be provided.  Time delays must be measured and recorded.

Response time:  Ensure that requested data is provided within the acceptable time period.  Expectations for response time must be specified.  Requested data must be received by the requestor within the specified time period.

Strategic Alignment Components: Business & IT

BUSINESS STRATEGY

·    Scope – Includes the markets, products, services, groups of customers/clients, and locations where an enterprise competes as well as the buyers, competitors, suppliers and potential competitors that affect the competitive business environment.

·    Competencies – The critical success factors and core competencies that provide a firm with a potential competitive edge. This includes brand, research, manufacturing and product development, cost and pricing structure, and sales and distribution channels.

·    Governance – How companies set the relationship between management stockholders and the board of directors. Also included are how the company is affected by government regulations, and how the firm manages their relationships and alliances with strategic partners.

ORGANIZATION INFRASTRUCTURE & PROCESSES

·    Administrative Structure – The way the firm organizes its businesses. Examples include central, decentralize, matrix, horizontal, vertical, geographic, and functional.

·    Processes - How the firm's business activities (the work performed by employees) operate or flow. Major issues include value-added activities and process improvement.

·    Skills – H/R considerations such as how to hire/fire, motivate, train/educate, and culture.

IT STRATEGY

·     Technology Scope - The important information applications and technologies

·     Systemic Competencies - Those capabilities (e.g., access to information that is important to the creation/achievement of a company's strategies) that distinguishes the IT services.

·     IT Governance - How the authority for resources, risk, and responsibility for IT is shared between business partners, IT management and service providers. Project selection and prioritization issues are included here.

IT INFRASTRUCTURE AND PROCESSES

·         Architecture - The technology priorities, policies, and choices that allow applications, software, networks, hardware, and data management to be integrated into a cohesive platform.

·         Processes - Those practices and activities carried out to develop and maintain applications and manage IT infrastructure.

·         Skills - IT human resource considerations such as how to hire/fire, motivate, train/educate, and culture.

 

Strategic Value

1.      Cost focus: Drawing on the value discipline of operational excellence

a)      Price products and services at lowest cost

b)      Drive economies of scale through shared best practices

2.      Value differentiation as perceived by customers: Drawing on the value discipline of customer intimacy

a)      Meet client expectations for quality at reasonable cost

b)      Make the customers' product selection as easy as possible

c)      Provide all information needed to service any client from any service point

3.      Flexibility and agility: Drawing on the value discipline of product and service innovation

a)      Grow in cross-selling capabilities

b)      Develop new products and services rapidly

c)      Create capacity to manufacture in any location for a particular order

4.      Growth: How the base of the business will expand

a)      Expand aggressively into underdeveloped and emerging markets

b)      Carefully grow internationally to meet the needs of customers that are expanding their business

c)      Target growth through specific product and customer niches

5.      Human resources: Where people policies fit in

a)      Create an environment that maximizes intellectual productivity

b)      Maintain a high level of professional and technical expertise

c)      Identify and facilitate the movement of talented people

6.      Management orientation: Different aspects of business governance and decision making

a)      Maximize independence in local operations with a minimum of mandates

b)      Make management decisions close to the line

c)      Create a management culture of information sharing (to maintain or generate new business)

The Business Value of IT: Managing Risks, Optimizing Performance and Measuring Results by  Michael D. Harris, David E. Herron and Stasia Iwanicki, Auerbach Publications © 2008 (294 pages)

Attributes of Good Metric

• Relevant
• Practical
• Actionable
• Reported or communicated
• Owned

IT Value Formula

Benefits
     + Product capability
     + Time to market
     + Timeliness
     + Product evolution

Costs
     - Development
     - Rework
     - Knowledge recovery
     - Legacy
-----------------------------------
                  VALUE
===================

Build SIPOC

1. State process name. Use a Verb + Noun format (e.g. recruit Staff).

2. Detail Outputs. These are the deliverables that the process produces (e.g. a report, or letter).

3. Identify Customers. These are the people who receive the Outputs. Every Output should have a Customer.

4. Detail Inputs, or process triggers. They will often be tangible (e.g. a customer request)

5. List Suppliers. They supply the inputs. Every input should have a Supplier.

6. Add the sub-processes that make up the process. These are the activities that are carried out to convert the inputs into outputs. They will form the basis of a process map.

LEAN Sins

• Defects and deviations
• Excessive motion / activities / procedures / processes 
• Excessive resources due to sub-optimized resource leveling and redundant activities
• Over production
• Unnecessary processing time due to fragmented workflow or not needed processing steps
• Unnecessary/ ineffective handoffs resulting from verification loops and excessive approvals
• Waiting time for response / approvals / documents