Data Warehousing with SAS

(1)

Data Warehousing with SAS

Wilbram Hazejager

Product Manager

SAS Warehouse Administrator® software

(2)

Agenda

! Introduction

! Data Warehousing ! Future Developments ! Questions and Answers

(3)

The SAS Intelligence Architecture is a low-risk framework that integrates our industry-leading capabilities in data warehousing, advanced analytics, and business intelligence to provide an intelligence framework that

can grow and adjust with your enterprise.

(4)

Data Warehousing

Data Warehousing is the ongoing process that brings

together data from any distributed source, manages it, and transforms it into information that has a positive influence on your company's bottom line.

SAS offers an end-to-end, award winning Data Warehousing solution backed

by a proven development and implementation Methodology, as

(5)

(6)

Capture

! Gather requirements ! Determine sources ! Set up extractions

! Use all existing rules,

documentation, models and metadata

(7)

Integrate

! Take any existing

metadata and turn into business terms, not IT terms.

!Rules !Metrics !Processes

(8)

Automate

! Make processes

!Repeatable !Manageable !Cost Effective

(9)

Metadata Management

! Enrich metadata ! Manage metadata ! SAS does this

(10)

High level challenges

! Disparate data sources, platforms, and operational

systems

! Independent operational and business data views ! Failure to turn raw data into actionable knowledge ! Limited resources and budgets

! Hard-to-access information ! No way of leveraging varying

employee skill sets

(11)

SAS Provides

! Integrated, platform-independent technologies

covering over 100 data sources and 40 supported platforms

! Warehousing tools that manage metadata

from business rules, processes and metrics to transformations.

! Market leadership across the entire

intelligence creation process – end to end supplier of intelligence

(12)

What should a DW Solution give you?

! Alleviate the complexity of data management ! Easily accommodate needs of business users

and IT professionals

! A simple, cost-effective way to access data,

regardless of its source

! Provide a true 360-degree view of the enterprise ! Do more than collect and store the information;

(13)

What should a DW Solution give you?

! Provide information in a ready-to-consume

format where quality is never in question.

! Easy to maintain and manage, flex with changing

business needs, and be low-risk.

(14)

What you get with SAS and warehousing

! Streamline the integration and management

of your information

! Provide a foundation for quality information

throughout the enterprise

(15)

Why use SAS for data warehousing

! Simplifies the ongoing operation of a data

warehouse environment through unique SAS process management capabilities.

! The SAS warehousing solution integrates

with our advanced analytical and business intelligence applications to form the SAS Intelligence Architecture.

(16)

Data Warehousing: Sprint

! Global Telecommunication Company

!Serving 23 million customers in 70 countries !Using a suite of SAS products to build a DW

!Consolidating over 25 data sources into 1 platform !Automating ETL process for efficiency

Almost everything we want to do we can do inside of SAS, and it's all integrated and seamless.

(17)

Data Warehousing: Barclays

! UK-based Global Provider of Financial Services

!17 million customers

!Using a SAS data warehouse

!Deliver Mortgage Limit information to sales people at

the point of customer contact

The customer feels he has received a great service without paperwork. ROI was achieved in eight weeks.

(18)

How do we do this?

Latest developments

! The SAS Scalable Architecture

! Metadata

! Management Console

! ngWarehouse Administrator – Managing the ETL

process

! Application Servers

(19)

Benefits of Centralized Metadata

! A central storage environment

! A secure storage environment

! Organized by business relationships ! Reusability of defined information ! Sharability across application users

! Supports impact analysis

(20)

Open Metadata Architecture

OMG CWM

!

Member of CWM

working group

responsible for the

definition of the

standard.

OMG CWM

!

Member of CWM

working group

responsible for the

definition of the

(21)

Benefits of the Open Metadata

Architecture

! Common model with support for extensions ! Multi-tiered approach

! Single tool to manage metadata for all SAS

applications

! Support industry standards for metadata

(22)

SMC Maintenance !License Mgr !Install information Monitor Policy !Authorization Environment !Metadata !Servers

(23)

SAS Management Console

Metadata Manager

! Manage repository

servers.

! Manage Resource

(24)

Screenshot of SAS Management

Console

Technology Knowledge Centre

(25)

" Java-based thin client " Wizard-driven interface " Multi-user operation " Multi-level (dev, test,

prod) operation

" Common metadata

server a key feature

" Leverages SAS Scalable

Architecture

ng

Warehouse Administrator

Managing the ETL process

(26)

(27)

Functionality re-used from Query component

(28)

SAS Application Servers

! Scalable Architecture

! SAS/ACCESS threaded reads ! Threaded procedures

! SAS/CONNECT using MP CONNECT

Stream2 (Intelligent Storage and Architectures):

Wednesday 12 June 17:10

Scaling up and out: the value proposition of the SAS® Scalable Architecture (Cheryl Doninger)

(29)

SAS Management Console • Server Definitions • Server Definitions SAS Application Servers

SAS ngWarehouse Administrator

• Warehouse Processess • Warehouse Processess • Accessing libraries • Processing data • Accessing libraries • Processing data DEV/TEST/PROD … • … • …

Conclusion

(30)

Conclusion

! Enterprise-wide data warehousing requires:

!integration of all DW components !automation of all processes

!documentation of all processes

! SAS software provides the framework to achieve

(31)

(32)