sas visual analytics hands-on

26
Copyright © 2015, SAS Institute Inc. All rights reserved. SAS VISUAL ANALYTICS HANDS-ON INSTANT GRATIFICATION ON BIG DATA

Upload: sas-canada

Post on 16-Apr-2017

2.412 views

Category:

Data & Analytics


0 download

TRANSCRIPT

Page 1: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

SAS VISUAL ANALYTICS HANDS-ONINSTANT GRATIFICATION ON BIG DATA

Page 2: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

AGENDA FOR THE DAY

 TIME8:30 a.m. Registration & Breakfast 9:00 a.m.     Visual Analytics Introduction and Overview9:30 a.m. Visual Analytics Walk through 9:45 a.m. Break10:00 a.m. Put SAS Visual Analytics through its Paces

Using real data and real scenariosExplore all relevant data quickly and easily

10:45 a.m. Sharing Insights Through Visual Analytics ReportingUsing sample reports to show dissemination of insight

11:00 a.m. Break11:15 a.m. Visual Statistics

Moving from analytics to statistics11:50 am Wrap up and questions

Page 3: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

SAS VISUAL ANALYTICS LAB OBJECTIVES

• Introduce you to a the new approach for BI• Get hands on with Visual Analytics • Understand how Visual Statistics extends the capabilities• Learn how to get started with Visual Analytics• Answer your questions

Page 4: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

ExplorationData Visualization

ANALYTICS WHAT DOES ANALYTICS MEAN TO YOU?

Traditional Reporting Creation and sharing of known

information resulting in the deliver of reports

Data DiscoveryExploration of data to

discovery new questions and opportunities

Advanced AnalyticsLeverage Data to make the best

decisionForecastingOptimization

Prediction

Standard ReportsDashboards

Ad Hoc Query

Page 5: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

BI CIRCA 1995 THE WAY BI TYPICALLY WORKS

DATA SOURCESoperational, transactional

INFORMATION ORGANIZEDsummaries, samples, subsets

INTELLIGENCE ADDEDcalculations, hierarchies, groups

ANALYTICS PERFORMEDdescriptive, predictive, prescriptive

APATHY

Attributes:• Data rules the process• IT gathers and organizes the data• Multi step process• Analytics are an after thought• Outcome is a report

ITDRIVEN

REPORTS DELIVERED

USERDRIVEN

Page 6: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

BI TODAY BUSINESS INTELLIGENCE PROCESS REVISED

DATA SOURCESoperational, transactional

ORGANIZE INFORMATION

ADD INTELLIGENCE

PERFORM ANALYTICS

DESIGN REPORT

ENTHUSIASM

Attributes:• Data is still required• End Users organize and enrich

data• Reports are visualized• Self serve and agility is a reality• Outcome is amazing

ITDRIVEN

USERDRIVEN

Page 7: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

BI TODAY BUSINESS INTELLIGENCE PROCESS REIMAGINED

ENTHUSIASMGive Business Users access to all the data

• No more samples, subsets, summaries• Granular, detailed transactions: what the business does.

Empower business users with tools to:• Organize the information• Add intelligence – data autonomy• Perform (and understand) advanced analytics• Design and customize their own reports

SELF SERVICE ENABLEMENT EMPOWERMENT ENTHUSIASM

Page 8: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

Data Autonomy

VISUAL ANALYTICS WHEN TO CONSIDER IT

Enterprise Data Sandbox

Governed Visualization

Analytical Insights

Data Prep to Visualization

ScalabilityLeverage SAS Investment

Unguided Analysis

Page 9: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

VISUALIZATION WHY IT MATTERS…

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov DecDomestic $1,983 $2,343 $2,593 $2,283 $2,574 $2,838 $2,382 $2,634 $2,938 $2,739 $2,983 $3,493 International $574 $636 $673 $593 $644 $679 $593 $139 $599 $583 $602 $690

versus

Page 10: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

SAS VISUAL ANALYTICS & SAS VISUAL

STATISTICSDELIVERS A SINGLE SOLUTION FOR FASTER, SMARTER DECISIONS

MOBILEDATA PREPARATION

EXPLORATION REPORTING

• Native iOS and Android applications that delivers interactive reports

• Join data from multiple sources

• Create calculated and derived columns

• Load data

• Perform ad-hoc analysis and data discovery

• Apply exploratory analytics

• Create dashboard style reports for web

or mobile

SAS LASR ANALYTIC SERVER

ADMINISTRATION

• Monitor SAS LASR Analytic server

• Load/unload data• Manage security

MODELING

• Perform exploratory data analysis

• Conduct rapid model prototyping

Central Entry Point Integration Role-based Views

Page 11: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

SAS VISUAL ANALYTICS SAS IN-MEMORY ARCHITECTURE

RAM

CPU CPU

SAS LASR Analytic Server

• Data in-memoryUltra-fast processing

• Extreme ParallelismLeveraging all processor cores

• Distributed EnvironmentStart small and grow

Page 12: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

SAS VISUAL ANALYTICS PREPARING THE DATA…

ANALYTICAL TABLE:• Simple flat table: rows and columns• Denormalized• Each row is an autonomous transaction• No summaries or total• No hierarchical structure

Page 13: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

HANDS ON LAB

Page 14: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

SAS® VISUAL ANALYTICS DELIVERS A SINGLE SOLUTION FOR FASTER, SMARTER DECISIONS

Central Entry Point Integration Role-based Views

MOBILE BIDATA BUILDER EXPLORER DESIGNER• Native iOS and

Android applications that deliver interactive reports

• Join data from multiple sources

• Create calculated and derived columns

• Load data

• Perform ad-hoc analysis and data discovery

• Apply advanced analytics

• Create dashboard style reports for web

or mobile

SAS® LASR™ ANALYTIC SERVER

ADMINISTRATOR• Monitor SAS® LASR™

Analytic server• Load/unload data• Manage security

Page 15: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

SAS® VISUAL ANALYTICS DESIGNER

Interface for designing reports and dashboards Leverage existing reports and data to create reports Self-service data import from most popular data sources,

including Twitter and Salesforce Use multiple data sources in a single report Large number of visualization options with ability to create

custom graphs WYSIWYG designer with integrated report viewer Precision and tiled layout Report object interactions, linking to sections, reports, stored

processes, or external content Prompts at the report, section, and report object levels Comments in the report and object (charts and tables) levels Self-service Hierarchies: Drill down, up, and across siblings Quickly derive relative time calculations and create new

calculated columns via expression builder Parameterize calculations, filters, display rules, and ranks Print report, section, object, share report via email, schedule

reports to be distributed, setup and receive alerts via email or sms

Export data to Excel and CSV/TSV document formats “Adaptive presentation” - build once, access on computer

browser, mobile device, MS Office suite and SharePoint

Page 16: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

SAS® VISUAL STATISTICS

Page 17: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

SAS® VISUAL STATISTICS FUELING THE ANALYTICS LIFECYCLE

SAS® Visual Statistics

TEXTCOMPETITIVEADVANTAGE

MANAGE DATA

EXPLOR

ED

ATA

EXPLORE & DEVELOP MODELS

DEP

LOY

&

MO

NIT

OR SAS® Visual Analytics

Page 18: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

SAS® VISUAL STATISTICS RAPID MODEL BUILDING AND REFINEMENT

Page 19: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

SAS® VISUAL STATISTICS

ANALYTIC CAPABILITIES HOW IT CAN BE USED?

Classification Predict outcomes using causal factors -, churn, campaign response, part failure

Regression Estimate outcomes using causal factors - spend, policy premium, credit limit, etc.

Clustering Segment data based on self-similarity – risk, profitability, demographic, etc.

Group-By Models by segments/groups (e.g. location, store, owner, device, etc.).

Page 20: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

SAS® VISUAL STATISTICS MODELING TECHNIQUES

• Predictive Techniques• Linear Regression• Logistic Regression• Generalized Linear Model• Classification Trees

• Descriptive Techniques• Clustering

• Group-By Processing• Auto-update

Page 21: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

HANDS ON LAB

Page 22: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

CLOSING COMMENTS

Page 23: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

ExplorationData Visualization

ANALYTICS WHAT DOES ANALYTICS MEAN TO YOU?

Traditional Reporting Creation and sharing of known

information resulting in the deliver of reports

Data DiscoveryExploration of data to

discovery new questions and opportunities

Advanced AnalyticsLeverage Data to make the best

decisionForecastingOptimization

Prediction

Standard ReportsDashboards

Ad Hoc Query

Page 24: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

Data Autonomy

VISUAL ANALYTICS WHEN TO CONSIDER IT

Enterprise Data Sandbox

Governed Visualization

Analytical Insights

Data Prep to Visualization

ScalabilityLeverage SAS Investment

Unguided Analysis

Page 25: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved .

SAS® VISUAL ANALYTICS TRY BEFORE YOU BUY

http://www.sas.com/en_us/software/business-intelligence/visual-analytics.html

http://www.sas.com/en_us/software/analytics/visual-statistics.html

Page 26: SAS Visual Analytics Hands-On

Copyr igh t © 2015 , SAS Ins t i t u te I nc . A l l r i gh ts res erved . www.SAS.com

QUESTIONS?