make
connections • share ideas • be inspired
Nyheter i SAS Data Management
med SAS versjon 9.4
Terje Vatle
Hvorfor SAS
®
Data Management?
Hva kan du gjøre med SAS
®
Data Management?
Nyheter med SAS
®
9.4-basert Data Management
•
SAS Access
•
SAS Data Integration Studio
•
SAS Data Management Platform
•
SAS Master Data Management
DEGREE OF INTELLIGENCE
C
O
M
P
E
T
IT
IV
E
A
D
V
A
N
TA
G
E
Standard
reports
Ad hoc
reports
Drill down
Source
data
Cleansed
data
Alerts
BUSINESS INTELLIGENCE
Why is this happening?
What will happen if these trends continue?
What will happen next?
What is the best that can happen?
Statistical
analysis
Forecasting
Predictive
modeling
Optimization
What happened?
Where exactly is the problem?
Which actions are required?
How many, how often?
BUSINESS ANALYTICS
Tilrettelegging for analyse
•
Preppe store og små data
•
Lasting rett inn i in-memory appliance
In-database datakvalitet
Hvor går grensene for SQL?
•
SAS DM kan gjøre kompliserte beregninger
•
SAS DM er én løsning for datakvalitet, dataintegrasjon, tilgang,
føderasjon og MDM
Operasjonalisering av analyse
Data Governance
Hva kan du gjøre med SAS Data Management?
Data Integration
Data Quality
Enterprise Data Access
Data Access Engine / Db connectors (incl. Hadoop)
Event stream processing
Data Migration
Data Preparation for Analytics
Business glossary & rules
Matching / Entity Resolution
Profiling & Monitoring
Reporting & dashboarding
Stewardship, Remediation
Multi-domain MDM
Reference data management
Relationship management & lineage
Workflows / Enrichment
Data abstraction
Data aggregation
Data caching
Master Data
Data Governance
SAS Data Management
Data Integration
Data Quality
Management
Master Data
Data Federation
Enterprise Data Access
Leader Gartner
Magic Quadrant
Leader Gartner Magic Quadrant
Champion Bloor Research
Leader Information Difference
2nd Largest
Data Access & Management Vendor - IDC
COE Advisory Workshops (Exec Briefing,
Assessments, Strategy & Roadmap)
SAS Best Practices
Leader in Advanced Data
Visualization - Forester
Leader in Big Data
Analytics - Forester
36 Years of Data Management and Governance
Experience
Customers in 60k sites across 134 countries
90% of the Fortune 500 companies use SAS
24% reinvestment in R&D
Data Access
Connectors &
Access
Engines
Event stream processing
Transparent access to data stored on a variety of platforms and
formats (>60 different sources)
Continuously analyzes data as it is received for real
time decision making
•
Bank transaction fraud detection
•
Real-time analysis of social data streams
•
Personalized online offers based on navigation
•
Data residing in Applications as well as metadata stores
•
Structured, semi-structured and unstructured data
Data Integration
A
B
Integrated data quality to stop
bad data at the source,
de-duplicate, standardize, etc
Interactive, visual data integration
development environment that
enables collaboration and reusability
Data Federation
People
Processes
Technology
Oracle
DB2
Terad
ata
SQL
Server
ODBC
SAS
Datas
ets
SAP
Other
…
SAS Federation Server
Virtual Data Layer
“Query and use of data
across multiple systems
without the physical
movement
of source data”
Data Federation
People
Processes
Technology
Virtual Data Layer
SAS Federation Server
End Users
Power users
Contractors
Auditors
3
rdparties
Orders
Call center
Customer onboarding
Customer Service
Off shore
BI tools
Analytic apps
Spreadsheets
Data Warehouse
MDM
Summary data Personal data Customers Recent Activities Dashboard summary data
Public data Private data Products Suppliers Complete detailed data
Data Quality
Define the terms and sources
1
Discover & Profile the Data
2
Design data quality standards
3
Apply injection
and execution
4
Monitor & Publish
DQ measurement
5
Remediate &
Improve
6
In-database: SAS Data
Quality Accelerator for
Master Data Management
MDM