1. No category

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
SAS DATA
HVORDAN KAN DATA GOVERNANCE SE UT I PRAKSIS?
GOVERNANCE
Steps (yellow = demo):
1
1. Discover quality
2 Define stnds & glossary
2.
Data
Stewards
3 Evaluate and monitor
3.
Manage & Monitor
4 Correct data issues
4.
Business
Users
Create & Consume
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 .
IT
Implement,
Adapt & Extend
S A S C on f i d e n t i a l
5. Overview across
5
business and
technology
SAS DATA
FELLES STARTPUNKT
GOVERNANCE
1
3
2
5
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 .
4
S A S C on f i d e n t i a l
SAS DATA
STEP 1: DISCOVER QUALITY OF DATA
GOVERNANCE
+
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
1
SAS DATA STEP 2: DEFINE ENTERPRISE WIDE DATA QUALITY
GOVERNANCE 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
2
SAS DATA STEP 2: DEFINE ENTERPRISE WIDE DATA QUALITY
GOVERNANCE STANDARDS & BUSINESS GLOSSARY
Data Domain
Define term templates as per
business needs
By data domains such as
Customer, Product
Business Function
By business functions such as
Risk, Marketing, HR
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
2
SAS DATA STEP 2: DEFINE ENTERPRISE WIDE DATA QUALITY
GOVERNANCE STANDARDS & BUSINESS GLOSSARY
Granular Access
Protect valuable business
data definition
Granular role-based
user access
Data Governance Workflow
Workflow approval process
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
2
SAS DATA
STEP 3: EVALUATE AND MONITOR
GOVERNANCE
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
3
SAS DATA
STEP 4: CORRECT DATA ISSUES
GOVERNANCE
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
4
SAS DATA STEP 5: OVERVIEW ACROSS BUSINESS AND
GOVERNANCE TECHNOLOGY
Data Relationship Views
Consolidate enterprise
metadata
Import metadata from all
systems
Visualize relationships in
many 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
5
SAS DATA STEP 5: OVERVIEW ACROSS BUSINESS AND
GOVERNANCE TECHNOLOGY (USE ANY METADATA)
Web Client
SAS Lineage Web
Application
SAS Relationship
Service
SAS OMR
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 .
DataFlux
Data
Management
Server
S A S C on f i d e n t i a l
Other
5
SAS DATA
HVORDAN KOMME I GANG?
GOVERNANCE
Develop
Initiate
EDG Readiness &
Maturity
Assessment
Top-down
Business Drivers
Core Team
Mobilization
Bottom-up
Prioritize
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 .
DG Strategy Definition
EDG
Organizational
Framework
Vision,
Mission
Statement
& Guiding
Principles
Data
Stewardship
Model
DG / DQ Processes
Risk, Cost,
Benefits
Prioritization
DG Roadmap
Technical Capabilities Gap
Analysis
Business Case
DQ Analysis
Data Profiling
Scope
Consolidate
Business terms
and rules
definition
Impact & root
cause analysis
S A S C on f i d e n t i a l
Quick wins
analysis
DQ
standards
& KPIs
definition
Change
Management Plan
Stakeholder
Engagement Plan
SAS DATA
FOUR MISTAKES TO AVOID
GOVERNANCE
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 .
Failing to Define
& Design Data
Governance
Prematurely
Launching a
Council
Treating DG as
a Project
Relying on the
Big Bang
S A S C on f i d e n t i a l
SAS DATA
SAMMENHENGEN MED ANDRE SAS PRODUKTER
GOVERNANCE
• Data
Quality Advanced
• Data Management Advanced
• MDM 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
HVORDAN VIL DATA GOVERNANCE SE UT FREMOVER?
GOVERNANCE
New sources
New use cases
Operational
data sources
New governance
• Linking to new data
sources
Unstructured
data
• Privacy & regulations
• Retention policy
Web & social
media
• Data Quality
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
SAS DATA
MERGING THE TRADITIONAL AND BIG DATA APPROACHES
GOVERNANCE
Big Data Approach
Iterative & Exploratory Analysis
Traditional Approach
Structured & Repeatable Analysis
IT delivers a
platform to enable
creative discovery
Business users
determine what
question to ask
IT structures the
data to answer
that question
Business users
explore what questions
could be asked
Monthly sales reports
Profitability analysis
Customer surveys
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 .
Brand sentiment
Product strategy
Maximum asset utilization
S A S C on f i d e n t i a l
SPØRSMÅL?
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 .
www.SAS.com