sunz performance bg 20071128
DESCRIPTION
TRANSCRIPT
![Page 1: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/1.jpg)
SUNZ Annual Conference 2007
A Big Thank You, to Our Sponsors
![Page 2: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/2.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
“BI” of the Future
SAS Enterprise Intelligence Platform: What’s new and what’s the next wave
Keith Collins, Senior VP & Chief Technology Officer, SASpresented by Bill GibsonChief Technology Officer SAS Asia Pacific
![Page 3: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/3.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Top Ten Technology Issues – by Drivers Business Drivers
• BPM/BAM• Unstructured Data and Content Management• Operational Analytics• Regulatory Compliance / Security / Privacy• Geospatial Data Analysis
Technology Drivers• SOA, Web Services and Composite Applications• Software as a service• Advanced Data Visualization• RFID Analysis
Disruptive Technologies or Business Models • Enterprise Search
![Page 4: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/4.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
BI Models – Current & Emerging
Classic BI
Classic BI with Data Quality
BI with Feedback Loops
Real Time BI
Business Activity Monitoring
![Page 5: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/5.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Traditional idea of extracting data, building a DWH, running some analytics and producing a report...
Consumers are humans
Useful for monitoring processes
Provides consistency and management
Legend
Data Flows managed by 3rd parties (----------) Data Flows with SAS ETL (solid red) Analytical Data Flows (solid black)Results Flows
Classic BI Architecture
![Page 6: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/6.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
SAS Visual BI and BI Dashboard
![Page 7: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/7.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Data Quality added
Various Possibilities in Combination
Real Time DQ in Operational Applications
DQ added in Flows to EDW or to Marts
One Set of Rules
Legend
Data Flows managed by 3rd parties (----------) Data Flows with SAS ETL (solid red) Analytical Data Flows (solid black)Results Flows
Classic BI Architecturewith Data Quality
![Page 8: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/8.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Results fed back into Operational Systems
Integration at the Data level
Useful for Cyclical Applications eg Planning
Results of Forecasts, Cost Models or Optimisations
Users see same workflow but with better recommendations
Legend
Data Flows managed by 3rd parties (----------) Data Flows with SAS ETL (solid red) Analytical Data Flows (solid black)
Results Flows
BI Architecture with Operational Feedback
![Page 9: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/9.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Integration at a Service Level between Operational Application and Model
Real Time Scoring or Decisioning
Must Satisfy Throughput Requirements
Useful when Score on Demand is required
May need to “marshall” data from operational system
Legend
Data Flows managed by 3rd parties (----------) Data Flows with SAS ETL (solid red) Analytical Data Flows (solid black)Results Flows Service Calls
Real Time BI ArchitectureBAM: Business Activity Monitoring
![Page 10: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/10.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
SAS Enterprise Intelligence Platform: What’s new and what’s the next wave
![Page 11: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/11.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
SAS 9.2 Logistics (SUNZ 2006)
Coming….. 2007 Q3
Migration• High priority for R&D
• Mandate from Jim Goodnight
• Details later
You should be on current maintenance• 9.1.3 SP4
• Current hot fixes
• Current DI & BI releases, EG 4.1
![Page 12: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/12.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
SAS Technologies RoadmapComing Soon
Today
Already Production!
6 Months Ago
What’s New Recently With SAS 9.1.3
December
ComingSoon - 9.1.3
![Page 13: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/13.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Scalability improvements (operation time now largely independent of project size) for unit level operations:
• Add, edit, copy, and delete models
• Make series active / inactive
• Recreate automatically-generated models, refit all models, and select a forecast model for a series
• Refresh the current forecast model, updating the parameter values for a series; refit the current forecast
Performance improvements for project level operations• Creating, opening and closing large and very large projects
• Filtering and scrolling through large and very large projects
• Fitting models for large and very large projects
Key Benefits of Forecast Server 2.1
![Page 14: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/14.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
EM project conversion utility
Addition of new data mining algorithms for predictive modeling, variable reduction, and market basket analysis
Additional tools for analytical data pre-processing• Interactive binning, append, transpose
Enhanced interactive data visualization including new graph types and persistence of interactive graphs created by the user
Reporter node for surfacing EM results via PDF and RTF ODS output
Key Benefits of Enterprise Miner 5.3
![Page 15: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/15.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Key Benefits of Enterprise Miner 5.3 User Interface Updates – Updated PFD
Node status indicators
Improved icons along with zoom controls
Data library
![Page 16: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/16.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
SAS Technologies RoadmapSAS 9.2 – The Future
Today Future
Already Production! Still Under Development!
6 Months Ago December
ComingSoon - 9.1.3
What’s New Recently With SAS 9.1.3 What Will 9.2 Bring
Already Production!
SAS 9.2• Phase 1 (End of Q1/Early Q2 2008) : “Classic” SAS
• Phase 2 (End of Q2/Early Q3 2008) : Technology Solutions Selected
Solutions
• Phase 3 (Ongoing after phase 2) : Analytic Solutions Rest of SAS
Solutions
![Page 17: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/17.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
New Application Server Support (BI)
Updated Browser Support (BI)
New Operating Environments
Environment Updates
![Page 18: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/18.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Deployment, Installation and Configuration
Electronic Software Delivery
SAS Deployment Wizard
Increased support for silent (and repeatable) installs
Pre-requisite handling of specified 3rd party products
Optional “phone home” support
Expanded system requirements support
Simplified documentation install center
![Page 19: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/19.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
SAS 9.2 ODS Enhancements
![Page 20: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/20.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.Copyright © 2007, SAS Institute Inc. All rights reserved.
ODS Graphics From Start to Finish
![Page 21: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/21.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Survival Plot with LIFETEST
![Page 22: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/22.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Bivariate Density Plot with KDE
![Page 23: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/23.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Basics of ODS Graphics
Invoke with
ODS GRAPHICS ON;
Procedure options determine “which plot I get”
Destination determines “where I see my plots”
Style determines “what all my plots look like”
Template determines “what a specific plot looks like”
![Page 24: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/24.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
SAS 9.2: Stat Studio
The power of SAS analytical modeling tools
Exploratory graphics and modeling capabilities
Extensibility of SAS/IML
![Page 25: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/25.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Management & Administration
Major focus for 9.2 and beyond• Audit
• Monitor + Manage
• Deployment
• Environment Migration (Promotion)
9.2: Common logging system across the platform• Log4SAS (based upon Log4J Java standard)
Common Prompting Framework
![Page 26: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/26.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Security EnhancementsSingle Sign On
Single Sign-On (Windows Only – No Prompting)
Will be implemented for all SAS platform windows based clients and Web Clients
![Page 27: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/27.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Enhanced Web Service Support
Easier to call a SAS Web Service from anywhere
• More fine grained WSDL used to define SAS web services
• Simpler use from standard tools and environments (Visual Studio, Sharepoint, Eclipse)
Easier to call a web service from SAS - XML Libname engine updated to support WSDL and SOAP.
Web Service invoked by issuing the Libname statement with the native WSDL type.
fileref foo "http://www.sas.com/webservice/test.wsdl";
Libname foo XML type=WSDL ;
To do a discover of the methods- returns the methods, input and output parameters, and the description
Proc contents data= foo._all_;
Returns the results from method1 in the web service foo based on the input parameters. Parameters can be a data set, and the Proc can be any Proc and the values would be manipulated appropriately.
Proc Print data=foo.method1(param1=x, param2=y…);
![Page 28: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/28.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
SAS 9.2 DI Enhancements
![Page 29: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/29.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
SAS 9.2 Key Initiatives• Single sign-on
• Dynamic and cascading prompts
User Interface enhancements• Enhanced PFD
• “Post-it” Notes
• Complete undo/redo
Advanced Debugging• Capture & display runtime statistics
• Dynamic source, log, PFD linking
Job and Process Manageability• Step-thru and Run from processing
• Change Data Capture Transformations – DB2, Oracle, Attunity
Metadata Reporting
Enhanced Data Cleansing and Enrichment
Product RoadmapData Integration Studio 4.2
![Page 30: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/30.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Data Integration Studio 4.2Advanced Debugging
![Page 31: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/31.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Data Integration Studio 4.2 Warning / Error Management
View of Warnings and Errors with ability to jump right into the log or the code. We will also offer advice as to the likely cause
![Page 32: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/32.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Data Integration Studio 4.2Run-time Monitoring
![Page 33: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/33.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Data Integration Studio 4.2Metadata Reporting
![Page 34: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/34.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
SAS/Access Enhancements
SAS/Access to Netezza (already shipping)
SAS/Access to HP Neoview
Overall enhancements for SAS/Access products• Teradata Parallel Transporter (TPT) support
• PC Files (Paradox, Prodas, Dbase)
• PC File Server as a Windows Service
![Page 35: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/35.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
SASScoring
Data
Teradata EDW
Current Capabilities
Data
Teradata EDW
Future Option
SAS
Analytic Modeling
SAS
Analytic Modeling
SAS Modeling
SASScoring
SAS® In-Database Processing for Teradata
![Page 36: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/36.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
OLAP Server Enhancements
Incremental Cube Update:• Easier to update the very large cubes SAS supports. Refresh times
significantly reduced
• Available options for updating a cube:
− Add new data
− Add new members per dimension table
− Member property updates for existing members
New Batch Management
![Page 37: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/37.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
OLAP Cube Studio Enhancements
Carry out an incremental update
Provide security settings
Allows for preview and validation of cube without leaving the admin interface
![Page 38: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/38.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
SAS 9.2 BI Enhancements
![Page 39: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/39.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
SAS® Information Map Studio
Improved relational support• Dynamic & cascading prompts
• Auto arrange tables in relationship tab
Easier maintenance of information maps• Set property for multiple data items at once
• UI for fixing unresolved references
• Improving default descriptions
![Page 40: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/40.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
SAS® BI Dashboard 4.2
Run in 3rd party portals via JSR 168
Support for alerts
Secure editing of ranges
Pass parameters to Web Report Studio report
![Page 41: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/41.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Parent Values
Visual Totals & Subtotals
% of Totals & Subtotals
![Page 42: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/42.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
SAS Web Report Studio 4.2
Prompting & Filtering
Dynamic & cascading prompts
Case insensitive filters/prompts
Use information map filters & prompts for OLAP
Allow multiple filter conditions for one data item
Filter Dialog: Search for values
![Page 43: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/43.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Report Linking• Link from ESRI spatial map with multi-select parameter passing
• Link directly to a stored process
• Link to a specific report section
− Within same report
− Section in another report
SAS® Web Report Studio 4.2
![Page 44: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/44.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
SAS® Web Report Studio 4.2
Add/view report comments
Email link to report, optionally with parameter values
Ability to call a report directly from a URL
Data driven hyperlinks in Tables/Graphs
Built-in scheduler
![Page 45: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/45.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
![Page 46: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/46.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
SAS® Add-In for Microsoft Office 4.2
Dynamic & cascading prompts
Forecast Server manual override
ODS Statistical Graphics support
Function in Microsoft Office 2007
![Page 47: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/47.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
SAS® Add-In for Microsoft Office 4.2
Open and refresh SAS Reports authored by Web Report Studio or Enterprise Guide
PivotTable: calculated measures and drill-through support
PROC REPORT-based Wizard
![Page 48: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/48.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Top-level menus have been reduced and combined with a basic toolbar.
Summary Statistics
One-time Analysis
Programs
A contextual tool bar appears inside the content area optimized for the object being viewed.
Enterprise Guide 4.2 UI Framework
![Page 49: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/49.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Conditional processing is set up but not run:
Icons to show the path that is taken for the current run:
Conditional Logic displayed visually
![Page 50: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/50.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Conclusion
9.2 is designed to meet the emerging issues of new models of BI, as well as improving the user, and administrator experience.
This presentation only covered selected highlights – there is much more.
Further details will become available closer to release dates.
![Page 51: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/51.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
Thank You
![Page 52: Sunz Performance Bg 20071128](https://reader031.vdocuments.us/reader031/viewer/2022013100/54b995c74a79593d0f8b464d/html5/thumbnails/52.jpg)
Copyright © 2006, SAS Institute Inc. All rights reserved.
SUNZ Annual Conference 2007
A Big Thank You, to Our Sponsors