1. No category

SAS® Data Governance
Hvad er det, og
hvordan kommer man i gang?
Frans Holm, Advisor Data Management/SAS Platform
Dagsorden
• Hvad er Data Governance?
• Hvorfor Data Governance?
• Hvad betyder Data Governance for dit SAS-miljø?
• Hvad er SAS® Data Governance?
• Hvordan kommer man i gang med Data Governance?
• Eksempel på SAS® Data Governance: Sporbarhed – SAS Lineage
Definition
Hvad er Data Governance?
Kilde: Wikipedia
Data governance is a set of processes that ensures that important data
assets are formally managed throughout the enterprise.
Data governance ensures that data can be trusted and that people can
be made accountable for any adverse event that happens because of
low data quality.
It is about putting people in charge of fixing and preventing issues with
data so that the enterprise can become more efficient.
Kilde: Wikipedia
Data governance also describes an evolutionary process for a company,
altering the company’s way of thinking and setting up the processes to
handle information so that it may be utilized by the entire
organization.
It’s about using technology when necessary in many forms to help aid
the process
Data Governance
Data Governance – Eksempel i SAS
DI Best Practise – Struktur i Metadata og fysiske foldere
SAS Folders
SAS_Project
Data
Documentation
Jobs
User_Written_Transformations
Utilities
SASInstitute_UI_Applications
Analytical_Marts
Analytics
Data
Jobs
ModelLifeCycle
Data_Marts
General Reporting
BI_Dashboards
Organization1
SubjectArea1
Reporting
Organization1
Data
Programs
Reports
Organization2
Hvorfor?
Data Governance
Hvorfor Data Governance?
All your business processes and business
decisions rely on Data …
But do you manage your Data
Assets
as other Corporate Assets?
Hvorfor Data Governance?
Den rigtige information
Til tiden
Det rigtige format
Til de rette personer/
systemer
Hvorfor Data Governance? 3 tilgange?
RISIKO
OMKOSTNINGER
INDTÆGTER
Hvorfor Data Governance? 3 tilgange, der understøtter hinanden!
RISIKO
OMKOSTNINGER
INDTÆGTER
Hvad betyder Data Governance
for dit SAS-miljø?
Data Governance
SOURCES
SAS® DATA MANAGEMENT
CONSUMERS
DATA GOVERANCE
EVENT STREAM PROCESSING
DATA INTEGRATION
XML
DATA ACCESS
DATA QUALITY
Cloud
DATA VIRTUALIZATION
MQ
RDBMS
MASTER DATA MGMT
Data Governance-skalaen (Frans Holm)
Gør ingenting =
Ingen har reelt adgang til nogen
data, fordi Governance gør det
umuligt!
Gør ingenting
Gør ingenting =
Alle har adgang til alle data,
som deGør
er! ingenting
Hvor er I ?
Er I bevidste om, hvor I er?
Hvad betyder det for jeres SAS-miljø?
Hvad er SAS® Data
Governance?
SAS® Data Governance in a nutshell
• Formal orchestration of people, processes and technology to leverage data as a
corporate asset
Data Management processes
DQ Remediation
Business rules
Consensus
Collaboration
Transparency
Roles and responsibilities
Ownership, stewardship, accountability
Business data glossary
Data validation and DQ monitoring
Reporting and dashboarding
…
SAS® Data Governance
Data Profiling
Data Quality
Data Monitoring & Visualization
Business Data Glossary
Data Lineage
Data Remediation
Workflows
Metadata Support
Hvordan kommer man i gang
med Data Governance?
Hvordan kommer man i gang med Data Governance?
Data Governance er ikke et projekt!
1.
Data quality and data governance should never be considered a one-time
project. A quality culture must be established as an ongoing, continuous
process.
2.
No organization can tackle enterprise-wide data quality and data
governance all at once. To be successful, your journey must be
evolutionary. Start small and take achievable steps that can be measured
along the way.
”The Data Asset” by Tony Fisher
Data Governance – Kom i gang
1.
2.
3.
4.
5.
Ledelses-commitment
Hvor er I på ”Data Governance-skalaen”?
Hvor vil I gerne være på ”Data Governance-skalaen”?
Udpeg ressourcer, der har fokus på opgaven (data steward)
Følg Data Governance Best Practice
Data Governance – Best Practices
Stay focused on delivering value with information
Be ambitious in term of results instead of scope
Make your DG initiative visible and define an appealing business case
Quickly demonstrate added value
Simplicity is the strongest policy
Follow the maturity model
Invest in the right tools!
The data governance journey – Follow the maturity model
Unpredictable
Managed
Controlled
Proactive
Governed
No awareness
No accountability
Nascent awareness and
DS
Assigned DS
Accountability of
business owners
Proactive behaviours on
DQ
Recognized DS
DG office
DQ culture
No common language
Application-centric
Business definitions
DQ processes
Shared business
definitions and rules
DG policies
DQ embedded in
processes
Optimised crossfunctional processes
No tools
DQ tools
Metadata repositories
Shared metadata
Business glossary
Analytical MDM
DG process tool and
dashboards
Operational /
collaborative MDM
Data as a service
Eksempel
Sporbarhed – SAS Lineage
Data Governance – Eksempel
• Hvem ved noget om Data Governance?
• Løsning: SAS Lineage
SAS Lineage
Centralized Metadata and Relationship Viewer
• Visually represent or explore metadata objects and
their relationships
• Shows technical lineage from SAS environment and
business relationships from Business Data Network
SAS Lineage
All Relationships
•
•
•
Expanded visualization formats
Default views: Relationship, Governance and Impact view
Customers can design save individual views
Governance
Impact Analysis
SAS Lineage
Web Client
Centralized Metadata and Relationship Viewer
• Visually represent or explore metadata objects
and their relationships
• Shows technical lineage from SAS environment
and business relationships from Business Data
Network
SAS OMR
SAS Lineage Web
Application
SAS Relationship Service
DataFlux
Data
Management
Server
Other
SAS Relationship (Lineage) Repository
One repository to store metadata from multiple environments.
Import via Metadata Bridges.
SAS Lineage
Physical
Data
Model
ETL
Logical Data
Model
Data Quality
Database
Database
Database
Mainframe Data
via COBOL
Analytics
and Reporting
SAS Lineage – Eksempel
SAS Lineage – Eksempel
Spørgsmål?
[email protected]
[email protected]