從數據架構開始數據治理.pptx

1、Data Governance Begins With Data ArchitectureAaron N.Cutshall,DHA,MSHI,ACHEAaron N.Cutshall,DHA,MSHI,ACHESQL RV SQL RV http:/Just who is this guy?Just who is this guy?Enterprise Data ArchitectB.S.ComputerScienceM.S.ComputerInformationSystemsM.S.HealthInformatics35+YearsSpeaker various eventsDoctor o

2、f Healthcare AdministrationSQL RVCopyright 2024,SQL RV-All Rights ReservedSince 2023Something to considerSomething to consider“Any sufficiently advanced technology is indistinguishable from magic.”Sir Arthur Charles Clarke(1917 2008)A celebrated author of many science-fiction classicscreditCopyright

3、 2024,SQL RV-All Rights ReservedTodays GoalTodays Goal Why this session?Learn what data governance is How to do it When starting a new project For projects already in progress Leverage your data assetsCopyright 2024,SQL RV-All Rights ReservedWhy this session?Why this session?Data Governance is a mys

4、tery It must be important It must be difficult Its likely complicated Data Architecture is complicated Why should I worry about either one?How will they affect me?What can they do for me?Copyright 2024,SQL RV-All Rights ReservedAgendaAgenda Questions everyone should ask:Who should be involved?What i

5、s:Data Governance(DG)?Data Architecture(DA)?DG with DA?When should DG begin?Where is DG needed most?Why begin with DA?How do I get started?Leverage your data assets Next stepsCopyright 2024,SQL RV-All Rights ReservedQuestions everyone should askQuestions everyone should ask Who should be involved?Ch

6、ief Data Officers Compliance Officers Risk Management Professionals Data Governance Managers&Professionals Data&Information Architects Data&Information Quality Professionals Data Stewards Data AnalystsCopyright 2024,SQL RV-All Rights ReservedQuestions everyone should askQuestions everyone should ask

7、 What is:Data Governance(DG)?Managing data assets Rules,processes,policies,and frameworks Ensure data quality,integrity,security,and compliance Improve decision-making and reduce operational friction Defining and implementing organizational rules Standards and procedures for repeatable processes Dat

8、a management,usage,and access Reduce costs and increase effectiveness Establish accountability,transparency,and control Maximize value minimize risksCopyright 2024,SQL RV-All Rights ReservedQuestions everyone should askQuestions everyone should ask What Is Data Architecture(DA)?Design and structure

9、of data systems and infrastructure Consistent,accurate,and complete picture of data Consists of documentation,terms,and definitions Encompasses the organizations data assets Models,databases,integration&infrastructure Methods for data storage,retrieval,processing,and analysis Provides the blueprint

10、for how data is Sourced(the origin),flows(in motion),and stored(at rest)How and by whom it is utilized and under what circumstancesCopyright 2024,SQL RV-All Rights ReservedQuestions everyone should askQuestions everyone should ask What is:DG combined with data architecture?DG(business focus)works wi

11、th DA(implementation focus)Closely correlated in objectives,strategies,and implementation Work together to promote guiding principles Data quality,standardization,and integrity Accountability,stewardship,security,and compliance Checks and balances,along with proper change management Overall effectiv

12、e organizational managementCopyright 2024,SQL RV-All Rights ReservedQuestions everyone should askQuestions everyone should ask When should DG begin?Best answer:Right now!When beginning the data initiatives Keeps things from being missed Helps to identify gaps in governance When in the middle of an i

13、nitiative Better late than never capture all that you can Helps to identify and stop data hemorrhaging Start at the beginning Allows data governance to help guide data usage Allows data usage to help guide data governanceCopyright 2024,SQL RV-All Rights ReservedQuestions everyone should askQuestions

14、 everyone should ask Where is DG needed most?Best answer:Everywhere!DG is the glue that binds all data sources together It identifies and ensures that best practices are followed It preserves data definitions across the enterprise In every project,DG should include:A data dictionary with consistent

15、definitions A data lineage to show the migration of all data from source to target regardless of area The rules necessary for usage including minimum necessaryCopyright 2024,SQL RV-All Rights ReservedQuestions everyone should askQuestions everyone should ask Why Begin with Data Architecture?Alignmen

16、t Ensure both DG&DA align objectives and strategies DG policies&guidelines should inform DA design&implem.DA enables DG framework through quality,access&compliance Avoids divergent“rabbit trails”and“squirrel”moments Data Consistency&Integrity:DG requires accurate,consistent,and reliable data DA ensu

17、res this through well-designed models&rules Both are supported through data profiling,cleansing,and lineage tracking.Copyright 2024,SQL RV-All Rights ReservedQuestions everyone should askQuestions everyone should ask Why Begin with Data Architecture?Data security&privacy DG defines data security&pri

18、vacy policies DA provides the technical foundation(encryption,access,etc.)Both establish and enforce security&privacy controls Data lifecycle management:DG defines policies for data retention,archiving,and disposal DA provides means for storage,backup,and purging processes Both ensure lifecycle mana

19、gement practices fit requirementsCopyright 2024,SQL RV-All Rights ReservedQuestions everyone should askQuestions everyone should ask How Do I Get Started?Start with data architecture Tools:ER/Studio,Erwin,and others Not restricted to custom development Captures data definitions,flows,usage,and linea

20、ge Focus on logical models with full documentation Use a data catalog if already underway Tools:Alation,boomi,Collibra,data.world,OvalEdge,etc.Capture what data is stored where,how it gets there,and where it goes Use to understand then document your data flowsCopyright 2024,SQL RV-All Rights Reserve

21、dLeverage Your Data AssetsLeverage Your Data Assets Simplify data management Improve consistency Maximize usage Support compliance Government&industry regulations Best practice conventions Reporting requirements Various governmental agencies Executives and Board of DirectorsCopyright 2024,SQL RV-All

22、 Rights ReservedNext StepsNext Steps How Do I Get Started?Start with data discovery:data in place or incoming raw Build a data catalog and keep it current Keep a data dictionary and ensure consistent usage Track data lineage from incoming raw to outgoing reports Be Mindful of Data Quality Data is no

23、t a project its a process Not all data are created equal Must have Should have Nice to have Do not keepCopyright 2024,SQL RV-All Rights ReservedNext StepsNext Steps Is DA only for new projects?Fortunately,no!Begin right where you are no time like the present to begin!Backfill what you can and contin

24、ue to refine over timeMake it a priority to continue the process through completion Not only for custom-built systems but commercial ones too.Record your data sources,ETL transformations,and final structuresFocus only on the areas of your data ignore system specificsCapture data usage and flows in l

25、ineage As architecture progresses,so should the data catalogCopyright 2024,SQL RV-All Rights ReservedNext StepsNext Steps Goals of DG:Enable better decision-making Reduce operational friction Protect the needs of data stakeholders Train management and staff to adopt common approaches Build standard,

26、repeatable processes Reduce costs and increase effectiveness through coordination Ensure transparency of processes Improve data consistency and reliability Make data more useful and valuableCopyright 2024,SQL RV-All Rights ReservedNext StepsNext Steps How do I implement DG in my chaotic environment?

27、Do not expect to do it all at onceIdentify the most critical areas that may have the most impactCreate a plan to work through each area in a logical manner Begin capturing what you can in your data catalog Define how data should be used and compare it to present usage Continued efforts will unravel

28、the mystery of your dataDiscover hidden data caches and unknown processesEstablish a plan based upon such discoveries to improve all processes Eventually,you will master the chaos in your environment!Copyright 2024,SQL RV-All Rights ReservedWhat We CoveredWhat We Covered Questions everyone should as

29、k:Who should be involved?What are DG and DA?When should DG begin?Where should we start DG?Why begin with DA?How do I get started?Leverage your data assets Simplify data management Support compliance Reporting requirementsCopyright 2024,SQL RV-All Rights ReservedClosing ThoughtsClosing Thoughts DG an

30、d DA go very well hand-in-hand DG provides the rules and rationale to ensure compliance with various regulations DA provides the infrastructure support and processes to ensure DG is implemented properly Both provide documentation to ensure projects are on track and to avoid data hemorrhaging Both en

31、sure value-added data projectsCopyright 2024,SQL RV-All Rights ReservedClosing ThoughtsClosing Thoughts Be aware of these mistaken trends:Confuse activity with productivity Consider DA or DG is nice to have but not critical DG is like compliance something that we just do Neither DA nor DG are useful

32、 if not implemented Both are of the same time-saving principle Take time now to save a whole lot of time later Time wasted is money wasted and opportunity lostCopyright 2024,SQL RV-All Rights ReservedReferencesReferences Data Governance:Data Governance The Complete Guide to Data Governance Roles and

33、 Responsibilities Data Governance:How to Design,Deploy,and Sustain an Effective Data Governance Program Data Architecture:What is data architecture?A data management blueprint Data Architecture:From Zen to RealityCopyright 2024,SQL RV-All Rights ReservedQuestions&CommentsQuestions&CommentsBONUS:A TON of free eBooks from Microsoft,RedGate and SentryOne!PRESENTATION FEEDBACK:Your thoughts needed Improve presentations Make this event even more valuable!Aaron N.C 2024,SQL RV-All Rights Reserved