data governance and modeling best practices’ · ©2007-2008 axis software designs, inc. all...
TRANSCRIPT
©2007-2008 Axis Software Designs, Inc. All Rights Reserved
‘Data GovernanceAnd
Modeling Best Practices’
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 2
Welcome! Let Me Introduce Myself…
Marcie Barkin GoodwinPresident & CEO
Axis Software [email protected]
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 3
Data Governance & Modeling Best Practices
The Big Picture – Data Governance in Modeling EnvironmentsWhat Is It and Why Do We Need It?Modeling Best Practices – They’re Not Just A Pretty Face
Strategy FirstModeling Best Practices Goals
Communication (What?)Metadata Integrity (Who Can You Trust?)Reusability (Saving Time & Money)Reduce Redundancy (Say Again?)
Then ImplementationBest Practices - The Basics
Strategy, Standards and ProceduresWe Know It’s Important, But Who Has Time?
‘DM SOS!™’ (Data Modeling Set of Standards)• Robust Jumpstart• Saves Time & Money• Easy To Customize
‘DM SOS!’™ Brief Demonstration
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 4
The Big Picture –Data Governance In Modeling
As in life, as in our IT and Modeling environments…Enter Governance.
IT Governance, including Data Governance, is a philosophy of accountability, substantiated by a structured plan to guide IT processes towards
accurate and accessible information.
“It’s astonishing, in this world, how things don’t turn out at all the way you expect them to.”
Agatha Christie
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 5
The Big Picture –Data Governance in Modeling (Cont.)
Rarely do organizations work from the big picture, and as a result they ‘sub optimize’ solutions by allowing diverse standards, naming conventions, codes, etc.
This ‘silo’ approach to data and modeling efforts resultsin data inconsistencies which have a deleterious effect on the overall understanding, accessibility, integration and integrity of data.
Data Governance seeks to remedy these problems.
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 6
Data Governance –What Is It?
Data Governance is a subset of IT governance that focuses on establishing processes and policies around managing data as a corporate asset.
And:Data governance refers to the overall management of the availability, usability, integrity and security of the data employed in an enterprise.
And:Data governance provides the infrastructure, resources and processes necessary to manage data with the ‘Big Picture’ in mind.
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 7
Data Governance –Why Do We Need It?
…Because generally speaking, the management and quality of our data is sorely lacking.
The costs of managing disparate IT assets is expensive and the work efforts are cumbersomeData processes aren’t consistent and standardized, thus creating different report results4The decision to standardize and consolidate data assets is
inevitable Regulatory compliance - Sarbanes-Oxley, etc.:4 “Where management has outsourced…functions to third party
service provider(s), management maintains a responsibility to assess the controls over the outsourced operations.”
(Cont.)
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 8
Data Governance –Why Do We Need It? (Cont.)
The goal of data governance is to establish and maintain a corporate-wide agenda for data including:
4 Joint decision making and collaboration for the good of the corporation rather than individuals or departments
4Balancing business innovation and flexibility with IT standards and efficiencies
4Creating reliability, trust and accountability in data environments that frequently miss the mark
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 9
Data Governance & Modeling Goals
The goals of a data governance program are also reflected in the requirements for best practices in modeling:
Define the owners or custodians of the data assets in the enterpriseDevelop policies that specify who is accountable for the variousaspects of the data:4Accuracy, accessibility, consistency, completeness and
change controlDevelop procedures regarding how models are to be created, organized, stored, changed, archived, backed up, versioned and migrated through a model development life cycle
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 10
Data Governance & Modeling Goals (Cont.)
Develop audit procedures that ensure ongoing compliance with business rules and/or government regulations Develop standards that define:4 Model and model object naming4 Model development requirements 4 User permissions required to make development efficient while
protecting the work in progressDefine roles & responsibilities for:4Developing data models4Administrating model management best practices4 Interfacing with business data stewards and those who
implement governance policies
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 11
Modeling Best Practices
Data and process modeling best practices support the objectives of data governance as well as ‘good modelingtechniques.’Let’s face it - metadata’s not new; we used to call it documentation.But now we have a more critical need to have robust, effective documentation, and the model is one logical place to house it.
Because inadequate documentation and audit practices can result in bad business (as well as jail sentences), we need to:4 Understand the meaning of critical business data4 Trust the accuracy of the data4 Know its source4 Use it correctly4 Value & engage the data stewards (both business and technical)
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 12
Strategy First –Modeling Best Practices
Modeling best practices can only be as successful as the strategy they support –
Strategies will vary depending upon the organization’scurrent & future needs
Strategies are determined by clarifying where youare, and determining where you want to be
Strategies are not ‘one size fits all’, but they do sharevaluable goals of communication, metadata integrity,reusability and non-redundancy…
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 13
Communication
Communication is the single most important aspect of a successful data governance and modeling program.
Education, when combined with ongoing communication, can strengthen awareness of both data governance & modeling best practicesInadequate communication of model requirements & system changes is a common cause of deliverable failures Data governance & model management represent a continuous process rather than periodic decision-makingMonitoring and enforcing standards and procedures is critical and should be communicated & understood as a ‘business need’as well as a technical requirement
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 14
Metadata Integrity –Who Can You Trust?“The naked truth is always better than the best-dressed lie.”
Ann Landers
Your models represent important business (logical) & technical (physical) metadata, & these model structures truly support your business processes.
If you have varying answers when reviewing similarly named, but different metadata descriptions, how can you trust the models or the data they represent?
Modeling best practices assist in finding (and keeping) a way to the truth of the metadata…
910 8
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 15
Reusability –Saving Time & Money
Modeling best practices should include a commitment to the reuse of model objects, bringing consistency to model structures – their definitions, formats, properties & values.
Consistency leads to:Trust (in the metadata)Less time spent on analysis & fixing unnecessary problemsLess money spent on reworkThe ability to create models which are ‘jump started’ by previouslyused & approved logical & physical model objects
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 16
Reduce Redundancy –“Haven’t We Done This Already?”
Redundancy in the modeling world is one of the most common causes of inefficiency & data inaccuracy.
Best practices should include procedures which enable you to avoid:
Duplication of analysis effortsInconsistent model contentConflicting property definitions and valuesWasting time & money by not sharing knowledge, resulting in redundantly creating similar metadata
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 17
Then Implementation
When an organization manages its data as a corporate asset, and makes modeling best practices a part of its data governance efforts, the focus turns towards the business value of the data, not just the IT requirements. The business drivers for managing data as a corporate asset are: 4Competitiveness4Regulatory compliance4Realizing the benefit of investments in BI and other
information-based initiatives
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 18
Then Implementation (Cont.)
The keys to successful best practices modeling implementation are:
4Management support of a data governance program, including an integral best practices approach to modeling
4Development of a modeling strategy with data governance goals in mind
4 Involvement by both the business side as well as IT4Resistance to creating or accepting silos of standards and
procedures4Development of a ‘model management infrastructure’ to
support the modeling strategy
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 19
What IsModel Management?
Model management is the method by which data and process models are developed,
maintained, used & reused within a model development life cycle.
And a Model Management infrastructure is theestablishment & formal documentation of the standards & procedures used to apply model
management.
MO
DE
L
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 20
Model Management Components Model management for an effective multi-user modeling environment includes the following infrastructure components:
Standardized toolsEstablishment of a modeling strategy which includes:
A formal model management life cycleReusability of approved logical & physical model objectsReduction of unnecessary redundancy via standards for all model objectsProcedures which facilitate development & maintenanceMetadata integrity via consistency of definitions, documentation & model reviews
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 21
A Modeling Infrastructure
Organizations generally understand the need for modelingstandards and procedures, but face several obstacles ingetting the job done:
There isn’t a plan for developing an infrastructureIn-house resources are already working full timeResources may not have infrastructure knowledge or writing skillsInternal politics or ‘silo groups’ can’t agree on what should be implemented
“We know we need it, but who has the time?”
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 22
And So…
Organizations build most of their models from scratch, instead of creating an infrastructure which facilitates the use of previously developed & defined model objects.
A ‘Best Practices’ modeling environment which supports data governance goals is directly affected by the commitment to a modeling strategy, and putting in place the infrastructure to support it.
But who has the time?
Am I being redundant?
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 23
Let’s Make This Easier…
“It’s much easier to edit and delete than it is to create from a blank page.”
Marcie Barkin Goodwin
Starting with a robust, complete set of standards and procedures, and customizing them to meet your specific requirements is the solution to
quickly creating or enhancing your modeling infrastructure.
Introducing ‘DM SOS!’ (Data Modeling Set of Standards)…
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 24
Effective Model ManagementWith ‘DM SOS!’™‘DM SOS!’™ (Data Modeling Set of Standards) is a unique infrastructure product that helps companies implement an effective, customized modelinginfrastructure.
A Brief HistoryBenefits of ‘DM SOS!’™
Robust Jumpstart – 30 critical standards, procedures, templates and formsSaves Time & Money – customize rather than createExpert Baseline – written by an infrastructure expertEasy To Customize – Word docs and HTML
‘DM SOS!’™ Demonstration
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 25
The Art Of Infrastructure –‘DM SOS!’ (Data Modeling Set of Standards)
Administrative Change Control (Templates)BackupModel Merge (Complete Compare, Add Model Source)Versioning (Model Manager)
Model Maintenance6.
Logical/Physical Model Submission & Deliverables(Data Browser, RTB)Non-Conformance (Complete Compare)Logical/Physical Model Review FormLogical/Physical Model Submission Checklist
Model Review & Approval5.
Issue ResolutionResolve Issues4.
Model Change Control (Complete Compare)Notification & Update (Report Template Builder)Stewardship (UDPs)*Change Control Form – Logical Shared Objects
Reconcile Model Object Differences3.
Logical/Physical Data Model Object Naming (NSM,DSM)Class Word List (Logical Domains, NSM)Logical Domain List (Class words)Stewardship (UDPs)*
Develop Entities/Attributes2.
Modeling Strategy – (Design Layer Architecture)Diagram NamingModel Creation & Population (Templates, Derive, Split)
Create a model diagram and determine existence of required entities/attributes
1.
Associated Infrastructure Best Practices
ActivityStep #
©2007-2008 Axis Software Designs, Inc. All Rights Reserved page 26
Products & Services
Axis ServicesModel Management Consulting & AssessmentsModeling Standards & Procedures Consulting
Axis ProductsData Modeling (DM) SOS!™ - a critical Set of Standards & ProceduresBusiness Process Modeling (BPM) SOS!™ - also available
Axis Customized Education & MentoringData Modeling ConceptsData Modeling with AllFusion® ERwin® DMProcess Modeling with AllFusion® Process ModelerProcess Modeling Overview for Business Users & Managers
Call us at 303-415-1090 or visit our website at: www.axisboulder.com