sas global forum 2017...sas data integration studio you can use sas data integration studio on sas...
TRANSCRIPT
Copyright © SAS Inst itute Inc. A l l r ights reserved.
This webinar will be recorded.
Please engage, use the Questions function during the presentation!
Gert Nissen
Technical Client Manager
SAS Global Forum 2017A short summary….
Torben Skov
Principal Technical Consultant,
Analytics & Visualisation
Georg Morsing
Senior Manager
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Please interact with us
During the presentation:
• Ask questions • Provide suggestions• Give us feedback
Use the tools in the upper right corner of your screen
Please use the Questions function
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Sunday Monday Tuesday Wednesday Thursday
Opening session
Technology Connection
pre-conference Tutorials & Certification
Post-Conference
Training
Post-Conference
Training
Nordic Dinner
Kick Back Party
Welcome Reception
Happy Hour Reception
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Opening Session• CEO Jim Goodnight Wherever there is data, we need analytics to make the most of
it. This is the mission of SAS – to bring analytics everywhere
• Executive Vice President and Chief Marketing Officer Randy Guard, who took the stage to update attendees on new releases available on SAS Viya
• Executive Vice President and Chief Technology Officer Oliver Schabenberger
• Vice President of Sales Emily Baranello asked attendees to consider where the future leaders of analytics will come from - nearly 1 million downloads of SAS® Analytics U.
• Gather IQ a crowdsourcing community of volunteers who aren’t afraid to dig into some data. And offer a fresh perspective that can turn the world’s most challenging social issues into solvable puzzles.
• Disney’s The Lion King showhttp://video.sas.com/sasgf17/category/videos/general-sessions
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Technology Connection
• Artificial intelligence (AI)
• SAS Graphics Accelerator
• "Edge Analytics" - Event Stream Processing
• DATA Step Debugging in Enterprise Guide
• Factorization Machine with NCAA Basketball Data
• SAS-Cisco Edge-to-Enterprise IoT Analytics
http://blogs.sas.com/content/sascom/2017/04/03/impressive-technology-surprising-connections/
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Key Note
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Key Note
Change and innovation come from originality Author and professor Adam Grant
Failure … to launchAstronaut Colonel Chris Hadfield (link)
Data is the raw material of the Information AgeAlec Ross, Innovation Expert (link)
For the BBC, data and journalism go together like bangers and mashAmanda Farnsworth, BBC Head of Visual & Data Journalism (link)
Why add technology when you can be technology?Neil Harbisson, Artist and innovator (link)
Brace for impactCaptain “Sully” Sullenberger
Copyright © SAS Inst itute Inc. A l l r ights reserved.http://support.sas.com/resources/papers/proceedings17/#
Copyright © SAS Inst itute Inc. A l l r ights reserved.
The QuadSAS Partners SAS Developers Buy Books
Copyright © SAS Inst itute Inc. A l l r ights reserved.http://video.sas.com/sasgf17?utm_source=sascom&utm_medium=button&utm_campaign=sasgf-live-stream-promo
News Day @ The Forum 51 videosGeneral Sessions 25 videosTech Talks 14 videosUser Program 42 videosExecutive Program 4 videosInterviews 41 videos
Copyright © SAS Inst itute Inc. A l l r ights reserved.
SAS Partner Forum Awards
http://blogs.sas.com/content/partners/2017/04/07/missed-partner-forum-watch-the-replay/
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Overview of customers
Global
Region Sign ups, incl SAS
US 3475
Canada 193
Nordics 184
UK 67
Industry User Exec SAS
Banking 41 8 5
Commercial 8 6 4
Government 35 4 5
Insurance 8 2
Partner 21 11 3
Academic 6
Press 4
PSD 12
Year Customers
2017 154
2016 1832015 152
2014 143
NordicNordic trend
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Social agenda - NordicsSightseeing – Sunday 2. April
Kennedy Space Center
Wild Florida Airboat Tour
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Social agenda - Nordics
Dinner – Monday 3. April
Disney Epcot Center
• Norway loftPre dinner event with Accenture
• American Adventure RotundaNordic Dinner
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Copyright © SAS Inst itute Inc. A l l r ights reserved.https://communities.sas.com/t5/Nordic-Events-and-Presentations/bg-p/nordic-blog
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Visual AnalyticsData ManagementRisk & Fraud SAS Viya & SAS 9 integration Customer IntelligenceAnalytics
The Big 6
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Visual Analytics 8.1+ -
Utilizes CASDesigner and Explorer integratedLooks nice
?It has a new DataBuilder
You can talk to it
It has less features than 7.3/7.4
Pretty early VA on Viya version
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Stuart Nisbet demoing VA / Alexa integration
Google: SAS Tech Talk: Amazon Echo and other Cool SAS Tricks
(Vice President, Business Intelligence Research & Development)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Visual Analytics 7.4+ -
Many new features• Multi-value parameters• Date parameters• Dynamic labels• And much more…
!Probably the last 7.x version
(that is the last on SAS 9.x platform)
Designer and explorer not integratedStill Flash and HTML5 mix
(see it for your self: https://support.sas.com/documentation/onlinedoc/va/)
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Interesting VA papershttp://support.sas.com/resources/papers/proceedings17
• Designing for Performance: Best Practices for SAS® Visual Analytics Reports, Kerri L Rivers
• Nine Best Practices for Big Data Dashboards Using SAS® Visual Analytics, Elena Snavely
• SAS® Visual Analytics Tricks We Learned from Reading Hundreds of SAS® Community Posts, Tricia Aanderud, Ryan Kumpfmiller
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Interesting VA papershttp://support.sas.com/resources/papers/proceedings17
• Designing for Performance: Best Practices for SAS® Visual Analytics Reports, Kerri L Rivers
• Nine Best Practices for Big Data Dashboards Using SAS® Visual Analytics, Elena Snavely
• SAS® Visual Analytics Tricks We Learned from Reading Hundreds of SAS® Community Posts, Tricia Aanderud, Ryan Kumpfmiller
• Server-side performance is affected by the structure of the
data table (or data tables) in the SAS LASR Analytic Server.
• Client-side performance refers to the number and type of objects to
render.
• Design performance includes things like the number of custom
calculations and concatenation of strings
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Interesting VA papershttp://support.sas.com/resources/papers/proceedings17
• Designing for Performance: Best Practices for SAS® Visual Analytics Reports, Kerri L Rivers
• Nine Best Practices for Big Data Dashboards Using SAS® Visual Analytics, Elena Snavely
• SAS® Visual Analytics Tricks We Learned from Reading Hundreds of SAS® Community Posts, Tricia Aanderud, Ryan Kumpfmiller
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Interesting VA papershttp://support.sas.com/resources/papers/proceedings17
• Designing for Performance: Best Practices for SAS® Visual Analytics Reports, Kerri L Rivers
• Nine Best Practices for Big Data Dashboards Using SAS® Visual Analytics, Elena Snavely
• SAS® Visual Analytics Tricks We Learned from Reading Hundreds of SAS® Community Posts, Tricia Aanderud, Ryan Kumpfmiller
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Interesting VA papers
http://support.sas.com/resources/papers/proceedings17
• Designing for Performance: Best Practices for SAS® Visual Analytics Reports, Kerri L Rivers
• Nine Best Practices for Big Data Dashboards Using SAS® Visual Analytics, Elena Snavely
• SAS® Visual Analytics Tricks We Learned from Reading Hundreds of SAS® Community Posts, Tricia Aanderud, Ryan Kumpfmiller
Together these 3 papers teaches you the fundamentals for getting the most out of VA 7.X.
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Support for browsers
• System requirements for VA 7.4
https://support.sas.com/documentation/installcenter/en/ikvisanlytofrsr/70807/HTML/default/index.html
• System requirements for Viya 3.2 (Visual Analytics 8.1)
http://go.documentation.sas.com/?docsetId=dplyml0phy0lax&docsetVersion=3.2&docsetTarget=p1w4wmouohveemn1crrf7djt5pir.htm&locale=en
Copyright © SAS Inst itute Inc. A l l r ights reserved.
• TRANSFERRING DATA TO AND FROM THE CLOUD• CONNECTIVITY AND ACCESS PUSHDOWN OPTIMIZATIONS• HADOOP INTEGRATION AND CONNECTIVITY• SAS FEDERATION SERVER• New SAS Data Remediation Features• SAS® DATA LOADER FOR HADOOP• SAS® Event Stream Processing• SAS Business Data Network
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Programming
Copyright © SAS Inst itute Inc. A l l r ights reserved.
SAS Visual Investigator and SAS Mobile Investigator
• New solution based on SAS Viya platform
• Displays alerts sent from any system. Sample SAS Solution could be:
• SAS® Event Stream Processing and normal DI-Studio job
• Also leverages queue functionality within SAS Viya to receive alerts
• Open and configurable architecture
• Alerts are stored in a Postgres database
• GUI is configurable using Java Script
• Integrates with maps (Google maps, or whatever map is available over http)
• REST-API
• Put into production at customer sites
http://support.sas.com/resources/papers/proceedings17/sas-visual-investigator-papers.html
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Copyr i g ht © 2016, SAS Ins t i tu t e Inc . A l l r ights reser ve d .
Following are several examples of SAS 9.4 solutions that contain user interface features that you can use to issue SAS/CONNECT statements to bridge the SAS 9.4 and SAS Viya environments:
SAS Enterprise MinerFrom your SAS Enterprise Miner process flow diagram running on SAS 9.4, you can remotely submit SAS Data Mining and Machine Learning procedures to run in SAS Viya and then return the results to SAS 9.4 and integrate them into the SAS Enterprise Miner output.
SAS Model ManagerYou can run SAS Data Mining and Machine Learning procedures and train models in your SAS Viya environment, and then upload the models and the models’ metadata to SAS 9.4. From SAS 9.4, you can remote submit code to register the SAS Viya created model and metadata in SAS Model Manager. You can use SAS Model Manager to manage both your SAS 9.4 models and your SAS Viya models. For example, you can use SAS Model Manager to deploy score code derived from both SAS 9.4 and SAS Viya models to a database.
SAS Data Integration StudioYou can use SAS Data Integration Studio on SAS 9.4 to perform tasks such as fetching data from multiple sources and preparing the data for mining. Then, you can use the Data Transfer node to upload the data table to SAS Viya and load it directly into memory.
SAS Enterprise Guide / SAS Add-In for Microsoft OfficeYou can use the custom code nodes in either of these products to upload or download data between the two environments. For example, you could remote submit code to SAS Viya for processing, and then return the computational results back to SAS Enterprise Guide on SAS 9.4.
SAS StudioYou can use the SAS Studio web interface to perform many programming actions in SAS Viya. For example, you could enter code in SAS Studio to access data in your SAS Viya environment, remotely submit SAS Viya procedures to run on the data, and then transfer the results data between the two environments.
SAS Stored ProcessesYou can save SAS/CONNECT SIGNON, RSUBMIT, UPLOAD, and DOWNLOAD statements as SAS Stored Processes, and then use the SAS Stored Processes as another way to bridge your SAS 9.4 and SAS Viya environments.
Copyr i g ht © 2016, SAS Ins t i tu t e Inc . A l l r ights reser ve d .
Copyright © SAS Inst itute Inc. A l l r ights reserved.
User ConferenceCI Program
Customer Presentations
• Am I Getting the Most Value out of My SAS® Installation Dollars? Proceeding Link
• Develop a Simple Data Governance Program for a SAS® Customer Intelligence Environment in 90 Days. Proceeding Link
• Enabling Advanced Customer Value Management with SAS®. Proceeding Link
• Increasing Revenue in Only Four Months with SAS® Real-Time Decision Manager. Proceeding Link
SAS Presentations
• SAS® Customer Intelligence 360 for Dummies. Proceeding Link
• Optimizing Your Optimizations by Maximizing the Financial and Business Impacts of SAS® Marketing Optimization Scenarios
• Using the SAS® Customer Intelligence 360 Hybrid Cloud Capabilities for True Omnichannel Marketing. Proceeding Link
• Customer Journey Optimization
• An Oasis of Serenity in a Sea of Chaos: Automating the Management of Your UNIX/Linux Multi-tiered SAS® Services. Proceeding Link
• Analytics Using SAS® Customer Intelligence: Multivariate Testing Processes for Digital Marketing Campaigns
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Executive ConferencePresentations with CI flavour
• Predictive Modeling: Improving Customer Touch Points and Customer Experience
- Chris Dingle, Senior Director of Customer Intelligence, Rogers Communications
• Making Data Work for You: Integrating Marketing Data for Better Customer Experiences
- Prakash Sankaran, Senior Director of IT Marketing and Merchandising Systems, Office Depot Office Max
• General SessionKeynotes: Anthony Perez and Jill DychéGame Changer! Analytics Transforms the Orlando Magic Fan Experience
• Video Link
Copyright © SAS Inst itute Inc. A l l r ights reserved.
SAS Customer Intelligence Customer Connection SessionFKA ”CI VIP event”
• SGF CI Customer Connect Event Private Luncheon (Invite Only)
• Product vision & direction and provide best practice sharing to improve the value of your Customer Intelligence investment.
- By Michele Eggers, Sr Director, Product Management, Customer Intelligence
• Best practices workshop on Digital Intelligence
- By Suneel Grover
Copyright © SAS Inst itute Inc. A l l r ights reserved.
SAS® Customer Intelligence 360 for DummiesFariba Bat-haee, Principal development tester for the CI360
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Four steps to creating a digital campaign
Personalize web content for
each visitor
Create more opportunities for engagement with
journeys
Display default content on a
web page
Automatically replace the default content with new
content
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Analytics
• SAS Visual Analytics
• SAS Visual Statistics
• SAS Visual Data Mining and Machine Learning
• SAS Visual Investigator
• SAS Visual Forecasting
• SAS Econometrics
• SAS Optimization
New products!
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Information is subject to change.
Q1 | 2017 Q2 | 2017 Q3 | 2017 Q4 | 2017 H1 | 201817w12 (March)
SAS Viya
• SAS/ACCESS engines• SAS Data Connectors
• SAS In-Database Technologies• SAS Data Connect
Accelerators
SAS Data Management
17w16 (April)
SAS 9.4
• SAS MDM• SAS Business Data Network,
SAS Lineage, and SAS Data Remediation (delivered with): SAS Data Management, SAS Data Governance, SAS Data Quality, SAS MDM
17w25 (June)
SAS 9.4• Data Management Platform
(delivered with): SAS Data Management, SAS Data Governance, SAS Data Quality, SAS MDM
• QKB for Medicinal Products [New]
17w38 (September)
SAS 9.4
• SAS Data Integration Studio
• SAS In-Database Technologies
• SAS/ACCESS engines
• Hadoop @ SAS
17w47 (November)
SAS Viya
• SAS Data Preparation [New]
• SAS Data Quality [New]
• SAS/ACCESS engines• SAS Data Connectors
• SAS In-Database Technologies• SAS Data Connect
Accelerators
• SAS Scoring Accelerators
• SAS Quality Knowledge Base for Contact Information
SAS 9.4
• SAS Data Loader for Hadoop
• SAS Federation Server
• SAS Scalable Data Server
• SAS MDM
SAS Viya
• SAS Data Preparation [New]
• SAS Data Discovery [New]
• SAS Data Integration [New]
Action Starts with Data• Data on Demand• Data Decisions You Can Trust• Data-Driven Businesshttp://smportal.sas.com/products/Pages/info.aspx?ai=PRA_738b271c-6f45-449c-809f-e5d865b7a830_2
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Information is subject to change.
Q1 | 2017 Q2 | 2017 Q3 | 2017 Q4 | 2017 H1 | 2018SAS Viya
• SAS Visual Statistics
• SAS Visual Data Mining and Machine Learning
• SAS Visual Forecasting (new) – programming only
• SAS Econometrics (new)
• SAS Optimization (new)
SAS 9 & SAS Viya
• SAS Pipefitter (Python API)
Analytics
SAS Viya
• API for R language
• Cloud Foundarydeployments:
- SAS Visual Statistics
- SAS Visual Data Mining & Machine Learning
SAS 9
• SAS/STAT & SAS/QC
• SAS/IML
• SAS/ETS
• SAS/OR
• SAS Enterprise Miner
• SAS Text Miner
• SAS Forecast Server
• SAS Contextual Analysis
SAS 9 & SAS Viya
• SAS 9 Unified Client for SAS Viya
SAS Viya
• SAS Visual Statistics
• SAS Visual Data Mining and Machine Learning
• SAS Visual Forecasting
• SAS Visual Text Analytics (new)
• SAS Econometrics
• SAS Optimization
• SAS Model Manager
SAS Viya
• SAS Visual Statistics
• SAS Visual Data Mining and Machine Learning
• SAS Visual Text Analytics
• SAS Visual Forecasting
• SAS Econometrics
• SAS Optimization
• SAS Event Stream Processing
• SAS Model Manager
• Simple• Powerful• Automated
http://smportal.sas.com/products/Pages/info.aspx?ai=PRA_ac0b95dd-8c51-4f98-89d1-fc2599d7087e_3
Copyright © SAS Inst itute Inc. A l l r ights reserved.
SAS Global Forum
Nordic SAS Customer Cases
Copyright © SAS Inst itute Inc. A l l r ights reserved.
SAS Global Forum
Nordic SAS Customer Cases
We will share selected presentations across the
Nordic Forums
Copyright © SAS Inst itute Inc. A l l r ights reserved.
SAS User Forum 2017
Tracks
• SAS Programming
• SAS Data Management & SAS Platform Technologies
• SAS Analytics
• SAS Visual Analytics
• SAS Customer Intelligence
• SAS Risk & Fraud Solutions
Topics
• EU Data Protection
• SAS Viya
• New software releases
Copyright © SAS Inst itute Inc. A l l r ights reserved.
SAS User Forum 2017Copenhagen
TimeSAS
ProgrammingSAS DM &
TechnologySAS Analytics
SAS Visual Analytics
08:30 Breakfast
09:15 Intro Intro Intro Intro
09:30
10:00
10:30
Break
11:00
11:30
12:00
Lunch
SAS Customer
Intelligence
SAS Risk & Fraud
Solutions
13:30
14:00
Break
15:00
15:30
Break
16:30
17:00
17:30 Closing Closing Closing Closing Closing Closing
18:00 - 22:00 Buffet, Drinks and Networking
Tracks
• SAS Programming
• SAS DM & Technologies
• SAS Analytics
• SAS Visual Analytics
• SAS Customer Intelligence
• SAS Risk & Fraud Solutions
SAS Viya
EU GDPR
Copyright © SAS Inst itute Inc. A l l r ights reserved.
SAS User Forum Copenhagen
Do you want to contribute with a presentation?
Contact [email protected]
Copyright © SAS Inst itute Inc. A l l r ights reserved.
mission
• User group events in 8 Nordic cities
• SAS User Forum in Copenhagen, Helsinki, Oslo and Stockholm
• SAS Global Forum and Analytics Experience
• Nordic webinar series
• SAS Community Nordics online community
• Live web classes and e-learning courses included
Skanderborg
Trondheim
Stavanger
Networking with peers, building knowledge and relationsNews in SAS software, tips & tricks
Copyright © SAS Inst itute Inc. A l l r ights reserved.
mission
Skanderborg
Trondheim
Stavanger
Networking with peers, building knowledge and relationsNews in SAS software, tips & tricks
20. April 2017:93 organizations are now FANS members
See member list here
Copyright © SAS Inst itute Inc. A l l r ights reserved.
FANS - Nordic User Group packages 2017
Type ofpackage
Online Nordic events
FANSNetworking
Events
SAS UserForum
SAS Global Forum
Analytics Experience
SAS Education included Fee per year Fee per year
CompanyUnlimited
access15 people per
event 15 people per
event 2 tickets 2 tickets
5 SAS e-learning courses5 SAS live web classes
19.000 DKK 2.500 Euro
CompanyPlus
Unlimited access
Unlimited per event
Unlimited per event
each extra person
1.000 DKK
each extra person
130 Euro
PersonalUnlimited
access1 person 1 person 50% discount
50%discount
1 SAS e-learning courses1 SAS live web classes
3.000 DKK 400 euro
PartnerUnlimited
access15 people per
event15 people per
event 2 tickets 2 tickets
5 SAS e-learning courses *5 SAS live web classes
29.000 DKK 3.900 Euro
The value of the Company FANS membership package is more than 100.000 Kr. or 13.000 Euro per yearAll prices above is excluded VAT.
* In addition to possible existing partner agreements with SAS Institute
Sign up here: www.sas.com/nordic-users
Copyright © SAS Inst itute Inc. A l l r ights reserved.
Nordic webinar seriesSign up at www.sas.com/nordic-users
Date Title Area
January 5.1. News in SAS 9.4 M4 All
February 2.2. Efficient SAS programming Programming
7.2. SAS Studio version 3.6 Programming
28.2. Calculating values and creating parameters in SAS Visual Analytics Visual Analytics
March 17.3. SAS Environment Manager Administration, Data Management
21.3. Machine Learning with SAS Analytics
April 20.4. News from SAS Global Forum All
26.4. Graph Builder and Maps with SAS Visual Analytics Visual Analytics
May 10.5. New versions of SAS Visual Analytics Visual Analytics
45 – 60 minutes webinars. Want to request a topic? Send an e-mail: [email protected]
Note: Date and topics are preliminary. Changes can occur.
Copyright © SAS Inst itute Inc. A l l r ights reserved.
SAS programs and presentationhttp://communities.sas.com/nordic
• Get the presentation from today and continue your learning
• Join the Nordic SAS Online Community and receive regular activity updates
Copyright © SAS Inst itute Inc. A l l r ights reserved.
FANS - Links
• Read about the FANS membership
• See the FANS member list here
• Webinars for Nordic SAS users
• FANS events in 8 cities
• SAS User Forum in Helsinki, Oslo, Copenhagen, and Stockholm
• Nordic on-line SAS Community
• FANS Contact
• Denmark - Georg Morsing, [email protected]
• Norway – Petter Dybvig, [email protected]
• Sweden – Marie Lienzén, [email protected]
• Finland – Pietari Koskela, [email protected]