Data Governance, SAS vinkling
Hvordan kan data governance se ut i praksis? Hvordan komme
i gang, og sammenhengen med andre SAS-produkter
.
C op yr i g h t © 2 0 1 4 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d .
Ved Terje Vatle, Business
Advisor Nordic CoE Information
Management, SAS Institute
C op yr i g h t © 2 0 1 4 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d . S A S C on f i d e n t i a l
SAS DATA
GOVERNANCE
HVORDAN KAN DATA GOVERNANCE SE UT I PRAKSIS?
IT
Business
Users
Data
Stewards
Create & Consume
Manage & Monitor
Implement,
Adapt & Extend
Steps (yellow = demo):
1. Discover quality
2. Define stnds & glossary
3. Evaluate and monitor
4. Correct data issues
5. Overview across
business and
technology
1
2
3
5
4
C op yr i g h t © 2 0 1 4 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d . S A S C on f i d e n t i a l
SAS DATA
GOVERNANCE
FELLES STARTPUNKT
1
2
3
5
4
C op yr i g h t © 2 0 1 4 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d . S A S C on f i d e n t i a l
SAS DATA
GOVERNANCE
STEP 1: DISCOVER QUALITY OF DATA
1
C op yr i g h t © 2 0 1 4 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d . S A S C on f i d e n t i a l
SAS DATA
GOVERNANCE
STEP 2: DEFINE ENTERPRISE WIDE DATA QUALITY
STANDARDS & BUSINESS GLOSSARY
Hvilken
definisjon er
den riktige?
Hvor skal jeg finne den?
C op yr i g h t © 2 0 1 4 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d . S A S C on f i d e n t i a l
SAS DATA
GOVERNANCE
STEP 2: DEFINE ENTERPRISE WIDE DATA QUALITY
STANDARDS & BUSINESS GLOSSARY
Define term templates as per
business needs
By data domains such as
Customer, Product
By business functions such as
Risk, Marketing, HR
Data Domain
Business Function
C op yr i g h t © 2 0 1 4 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d . S A S C on f i d e n t i a l
SAS DATA
GOVERNANCE
STEP 2: DEFINE ENTERPRISE WIDE DATA QUALITY
STANDARDS & BUSINESS GLOSSARY
Protect valuable business
data definition
Granular role-based
user access
Workflow approval process
Granular Access
Data Governance Workflow
C op yr i g h t © 2 0 1 4 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d . S A S C on f i d e n t i a l
SAS DATA
C op yr i g h t © 2 0 1 4 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d . S A S C on f i d e n t i a l
SAS DATA
C op yr i g h t © 2 0 1 4 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d . S A S C on f i d e n t i a l
SAS DATA
GOVERNANCE
STEP 5: OVERVIEW ACROSS BUSINESS AND
TECHNOLOGY
Consolidate enterprise
metadata
Import metadata from all
systems
Visualize relationships in
many views
Data Relationship Views
C op yr i g h t © 2 0 1 4 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d . S A S C on f i d e n t i a l
SAS DATA
GOVERNANCE
STEP 5: OVERVIEW ACROSS BUSINESS AND
TECHNOLOGY (USE ANY METADATA)
5
SAS Relationship
Service
SAS OMR
DataFlux
Data
Management
Server
Other
SAS Lineage Web
Application
C op yr i g h t © 2 0 1 4 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d . S A S C on f i d e n t i a l
SAS DATA
GOVERNANCE
HVORDAN KOMME I GANG?
DQ Analysis
DG Strategy Definition
EDG Readiness &
Maturity
Assessment
Business Drivers
Initiate
Develop
Consolidate
Scope
Prioritize
EDG
Organizational
Framework
Data
Stewardship
Model
Vision,
Mission
Statement
& Guiding
Principles
DG / DQ Processes
Technical Capabilities Gap
Analysis
Business terms
and rules
definition
Data Profiling
Impact & root
cause analysis
Quick wins
analysis
DQ
standards
& KPIs
definition
Business Case
Risk, Cost,
Benefits
Prioritization
DG Roadmap
Stakeholder
Engagement Plan
Change
Management Plan
Top-down
Bottom-up
Core Team
Mobilization
C op yr i g h t © 2 0 1 4 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d . S A S C on f i d e n t i a l
SAS DATA
GOVERNANCE
FOUR MISTAKES TO AVOID
Failing to Define
& Design Data
Governance
Prematurely
Launching a
Council
Treating DG as
a Project
Relying on the
Big Bang
C op yr i g h t © 2 0 1 4 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d . S A S C on f i d e n t i a l
SAS DATA
GOVERNANCE
SAMMENHENGEN MED ANDRE SAS PRODUKTER
•
Data Quality Advanced
•
Data Management Advanced
C op yr i g h t © 2 0 1 4 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d . S A S C on f i d e n t i a l
SAS DATA
GOVERNANCE
HVORDAN VIL DATA GOVERNANCE SE UT FREMOVER?
• Linking to new data
sources
• Privacy & regulations
• Retention policy
• Data Quality
New sources
New use cases
New governance
Operational
data sources
Unstructured
data
Web & social
media
Sensors,
smart meters,
Internet of Things
C op yr i g h t © 2 0 1 4 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d . S A S C on f i d e n t i a l
Brand sentiment
Product strategy
Maximum asset utilization
SAS DATA
GOVERNANCE
MERGING THE TRADITIONAL AND BIG DATA APPROACHES
Traditional Approach
Structured & Repeatable Analysis
Business
users
determine what
question to ask
IT
structures the
data to answer
that question
Big Data Approach
Iterative & Exploratory Analysis
IT
delivers a
platform to enable
creative discovery
Business
users
explore what questions
could be asked
Monthly sales reports
Profitability analysis
C op yr i g h t © 2 0 1 2 , S A S I n s t i t u t e I n c . A l l r i g h t s r es er v e d .
