Transcription
BALANCING DATA AND PROCESSTO ACHIEVE ORGANIZATIONAL MATURITYDECEMBER 19, 2017Ron HuizengaSenior Product Manager, Enterprise Architecture & Modeling@DataAviator 2017 IDERA, Inc. All rights reserved.1
AGENDA Organizational effectiveness Standards/bodies of knowledge Maturity indicators Data Maturity Process Maturity Supporting Perspectives Governance Enterprise architecture Architecture complexity Summary Q&A 20172016 IDERA, Inc. All rights reserved. Proprietary and confidential.2
SO MANY STANDARDS AND BOKS! CMM: Capability Maturity Model (1988) Sponsored by US Department of Defense Carnegie Mellon University, Software Engineering Institute Used as the basis to derive many other standards Other Standards DMM: Data Maturity Model BPMM: Business Process Maturity Model - Object Management Group COBIT: Control OBjectives for Information and Technology 2000 ITIL: Information Technology Infrastructure Library 2002 TQM: Total Quality Management SPC: Statistical Process Control The Bodies of Knowledge DMBOK: Data Management Body of Knowledge BABOK: Business Analysis Body of Knowledge PMBOK: Project Management Body of Knowledge 20172016 IDERA, Inc. All rights reserved. Proprietary and confidential.3
WHAT IS MATURITY? Mature “Having reached an advanced stage of development” Organizational maturity requires: Data Maturity Process Maturity One cannot be achieved without the other They are fundamental to: Enterprise architecture Governance 20172016 IDERA, Inc. All rights reserved. Proprietary and confidential.DataProcess4
Introduction01NoneInitialLevelDescriptionData GovernanceMaster Data ManagementData IntegrationData QualityBehaviourNoneProject Levelno formal masterdata clasificationNon-integratedmaster dataad-hoc, point topointExpansion2ManagedProgram LevelChaoticTransformation345Standardized Advanced OptimizedDivision LevelData cleansing atconsumption inorder to attemptdata qualityimprovementReactiveMiddleware utilization:service bus, canonicalmodel, business rules,repositoryStablePrimary IT FocusHIGHRiskValue Generation 20172016 IDERA, Inc. All rights reserved. Proprietary and confidential.Data ExcellenceCentre (educationand training)Data Quality KPI's andPrevention approachconformance visibility,to data qualitysome cleansing at source.Technology &InfrastructureLOWCross DivisionalIntegrated, sharedMaster data stewardsmaster dataData Management ServicesestablishedrepositoryReactive, point-tocommon integrationpoint interfaces,platform, designsome common tools,patternslack of standardsRecognition ofSilos, scattered data,inconsistecies but noinconsistenciesmanagement plan toacceptedaddressUnaware /DenialData MaturityProactiveEnterprise WideData stewardshipcouncilData Excellenceembedded incorporate cultureFull data qualitymanagementpracticePredictiveInformation &Strategic BusinessEnablementLOWHIGH5
Organization MaturityDATA MODEL aFull ecycle, valuechainFully integratedmodeling,glossaries,metadata, selfserve analyticsDocumentationand/or PhysicalDatabaseGeneration(project focused)Evolution 20172016 IDERA, Inc. All rights reserved. Proprietary and confidential.6
DATA - LIFECYCLE Describes how a data element is created,read, updated, deleted (CRUD) Many factors come into play Business rules Business processes Applications There may be more than 1 way a particulardata element is created Need to model: Business process Data lineage Data flow Integration Include Extract Transform and Load (ETL) fordata warehouse/data marts and staging areas 20172016 IDERA, Inc. All rights reserved. Proprietary and areClassifyStoreUse/Modify7
IntroductionLevel1DescriptionInitialFocusWork managementEfficiencyCultureBusiness ProcessIndividual: people rely on personalmethods to accomplish workProcess Maturity2ManagedProactive: management takeresponsibility for work unitoperations and performanceInconsistent: little or no preparation Managed: balance commitmentsfor managing a work unitwith resourcesInefficient: few measures foranalyzing effectivenessRepeatable: work units useprocedures that have proven to beeffectiveStagnant: no identifiable foundation Responsible: work units managefor commitment and improvement capability to meeting their owncommitments. (Silos)Few activities explicitly defined.Basic management processes andProcesses lack current statecontrols established to trackdocumentation.progress. Processes planned,documented, tactically performed.Decision makingTribal Knowledge, gut-feeldecisions, hierarchical structure.ArchitectureDisparate IT systemsLowLowHighHighCost cuttingChaos 20172016 IDERA, Inc. All rights reserved. Proprietary and : variation reduced - re-use,Integrated: standard processesbased on best practices in work units mentoring, statistical managementTransformation5OptimizedSystematic: improvementsevaluated and deployed usingorganizational change managementEmpowered: staff have the process Continual: individuals andAdaptable: standard processesdata to evaluate and manage their workgroups continuously improvetailored for best use in differentown workcircumstancescapabilitiesLeveraged: common measures and Multi-functional: advance fromAligned: performance aligned acrossprocesses. Promote organizationfunctional processes to role based the organization to attain strategicwide learning.business processes. (ownership)objectivesProfessional: organizational culture Predictable: metrics in place toPreventative: Systematicemerges from common practicespredict capability & performanceelimination of defects and problemacross work unitscausesProcess is documented andDetailed measures of process andContinuous process improvementstandardized. Cross functionality output quality. Processes managed, enabled by quantitative feedback.understood.controlled and forecasted usingProcesses fully integrated, fluid,quantitative techniques (andhighly predictablestatistical algorithms)Functional process orientation, data Integrated processes, performancedriven decisions, quality bymetrics, data driven decisionsinspectionRandom services adoptionFull service gementSelf service dashboards & analytics, Competitive advantage through bestexception managementpractice innovation.Service Oriented Architecture (SOA) Process driven enterpriseHighHighLowLowValue generationLeadership8
Organization MaturityPROCESS MODEL UTILIZATIONProcess DesignFully Mature(Lean, Six Sigma)ProcessImprovementBusiness ProcessManagement (BPM)DocumentationEvolution 20172016 IDERA, Inc. All rights reserved. Proprietary and confidential.9
SUMMARY DESCRIPTORSIntroduction1InitialIndividual initiative, heroicsInconsistentInefficientStagnantLacking current state documentationTribal knowledgeGut-feel decisionsDisparate IT systemsCost cuttingAd hocLow alignmentUnpedictableReactivePoint-to-point interfacesNon-integrated master dataLack of standardsInconsistencies recognizedChaoticProject data governance2ManagedOrganizational sponsibleTactical processesFunctional process orientationQuality by inspectionRandom services adoptionBasic controlsProject monitoringReduced reworkTypically meet schedulesNo business architectureImmature or no data architectureIntegrated master data repositoryCommon integration platformRecognize data quality problemsData cleansing at consumptionDesign patternsProgram data governance 20172016 IDERA, Inc. All rights reserved. Proprietary and confidential.IntegratedAdaptablecommon processesDocumented and standardizedIntegrated processesPerformance metricsData drivenFull service adoptionEfficiencyManagementAutomated exception reportingBusiness silos still existData management servicesMiddleware (service bus)Canonical modelModel/metadata repositoryData quality KPI'sSome data cleansing at sourceDivisional data PredictableDetailed quantitative measuresSelf service analyticsException managementService Oriented Architecture (SOA)Capability managementAutomated tactical process stepsFlexibleMeasuredControlledMaster data stewardsData Excellence centerPrevention approch to data qualityProactiveConfident forecastsCross divisional data uous improvementStrategically alignedPreventativeQuantitative feedbackFully IntegratedCompetitive advantageBest practice innovationValue generationLeadershipFull governanceBusiness rulesOrganizational change managementOptimizingData Stewardship councilData cultureFull data quality managementPredictiveEnterprise data governance10
ORGANIZATIONAL MATURITY JOURNEYNot FeasibleNot Feasible 20172016 IDERA, Inc. All rights reserved. Proprietary and confidential.11
ADDRESSING GOVERNANCE THROUGH MODELSDataArchitectureData Modeling& DesignData QualityData Storage& OperationsMetaDataDataGovernanceDataWarehousing& BusinessIntelligenceData SecurityDataIntegration &InteroperabilityReference &Master DataDocuments &Content 20172016 IDERA, Inc. All rights reserved. Proprietary and confidential.12
TOGAF ARCHITECTURE DEVELOPMENT CYCLE 20172016 IDERA, Inc. All rights reserved. Proprietary and confidential.13
MODELS ARE CRUCIAL! (ZACHMAN FRAMEWORK) 20172016 IDERA, Inc. All rights reserved. Proprietary and confidential.14
ENTERPRISE ARCHITECTUREGovernanceTechnical ArchitectureBusiness ArchitectureApplication ArchitectureEnterprise EnablementData Architecture 20172016 IDERA, Inc. All rights reserved. Proprietary and confidential.15
ER/STUDIO ENTERPRISE TEAM EDITION – INTEGRATED MODELING 20172016 IDERA, Inc. All rights reserved. Proprietary and confidential.16
DATA MODELING CONTEXTConceptual ModelsEnterprise Model(s)Enterprise Data DictionariesImplementation ModelsData omerDemographicsProductsCustomerCustomerDemoOrder Details 20172016 IDERA, Inc. All rights reserved. Proprietary and confidential.17
BUSINESS ARCHITECTUREWhat?Who? ules,RegulationsWho? Where?What?How well? 20172016 IDERA, Inc. All rights reserved. Proprietary and ions,EventsHow?How?When?18
SERVICE ORIENTED ARCHITECTUREService OrientedManagement &GovernanceService ConsumersPortalsComposite ApplicationsMash UpsBusiness ProcessRegistrySLAManagementBusiness IntelligenceCollaborative Team WorkflowRules ManagementProcess OrchestrationEvent DetectionBusiness Activity MonitoringManaged Service vice ardsDeploymentHostingConfigurationEndpointsChange & ControlData ServicesLegacyAdaptationDurable &Reliable DeliveryIntegrationServices & ETLData ReplicationProtocol & APIAdaptationQuality of ServiceDistributedQueryEIIIdentity & Authorization Management 20172016 IDERA, Inc. All rights reserved. Proprietary and confidential.19
SUMMARY Organizational maturity requires: Data Maturity Process Maturity One cannot be achieved without the other They are fundamental to: Enterprise architecture Governance Enterprise architecture is the solution Solid data architecture foundation Integrated process modeling to provide business context Modeling is more important than ever before! Data modelingProcess modelingData lineageMetadataBusiness glossaries Focus on enabling business capabilities Driven by goals and strategies Supported by advanced architecture 20172016 IDERA, Inc. All rights reserved. Proprietary and confidential.20
THANKS!Any questions?You can find me at:ron.huizenga@idera.com@DataAviator 20172016 IDERA, Inc. All rights reserved. Proprietary and confidential.21
Dec 19, 2017 · BPMM: Business Process Maturity Model - Object Management Group COBIT: Control OBjectives for Information and Technology 2000 ITIL: Information Technology Infrastructure Library 2002 TQM: Total Quality Management SPC: Statistical Process Control The Bodies of Knowledge
