tibco advanced analytics meetup (taam) november 2015
TRANSCRIPT
![Page 1: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/1.jpg)
TIBCO Advanced Analytics Meetup : Q4 2015Michael O’ConnellChief Data [email protected]@MichOConnell
November 2015
![Page 2: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/2.jpg)
• TIBCO Analytics & Data Science (Michael)• Data Analysis Pipeline
• Visual Analytics & Dashboards (Catalina Herrera)• Building Dashboards on the fly
• Predictive Analytics (Peter Shaw, Anna Nowakowska)• Simple Data Functions (R and TERR)
• Customer Analytics (Churn & Value)
• Data Access & APIs (Andrew Berridge, Mathew Lee)• Iron Python
• Advanced GeoAnalytics
• Wrap-Up / Questions (Michael)• Resources, Training, Links
Increase Productivity
Grow Revenue
Value
Reduce Risk
ROI
TIBCO Advanced Analytics Meetup (TAAM) Agenda
© Copyright 2000-2015 TIBCO Software Inc.
![Page 3: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/3.jpg)
Data Access & Prep
Exploratory Data Analysis Features Visual
DashboardModel & Predict
Deploy Champion
Model
Test & Learn
Channel
Social
Loyalty
Campaign
Filter
Map
Merge
Shape
Propensity
Affinity
Improve Guided -------- Deploy -------- In-LineExplore Data
Aggregate
Prepare DataBusiness Case
Increase Productivity
Grow Revenue
EnsembleForest
RegressionAdditive ModelsSegment
Visualize
Pricing
Promotion
ChallengerModels
At Rest
In Motion
Value Theses
Reduce Risk
ROI
Value
Dashboard Updates
Data a Insight a Action
© Copyright 2000-2015 TIBCO Software Inc.
![Page 4: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/4.jpg)
Spotfire Platform
© Copyright 2000-2015 TIBCO Software Inc.
SpotfireDesktop
![Page 5: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/5.jpg)
© Copyright 2000-2015 TIBCO Software Inc.
Spotfire Platform
![Page 6: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/6.jpg)
Immediate Long-Term Competitive AdvantageValue to the Organization
TIBCO is the only analytics platform that provides business value across this Analytics Spectrum
Self-service Dashboards API and CEP
Predictive and Prescriptive Analytics
Measure Diagnose Predict Optimize Operationalize Automate
Analytics Maturity
Insight to Action
![Page 7: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/7.jpg)
Immediate Long-Term Competitive AdvantageValue to the Organization
TIBCO is the only analytics platform that provides business value across this Analytics Spectrum
Self-service Dashboards
Measure Diagnose Predict Optimize Operationalize Automate
Analytics Maturity
Predictive and Prescriptive Analytics API and CEP
Insight to Action
![Page 8: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/8.jpg)
Immediate Long-Term Competitive AdvantageValue to the Organization
TIBCO is the only analytics platform that provides business value across this Analytics Spectrum
Self-service Dashboards
Measure Diagnose Predict Optimize Operationalize Automate
Analytics Maturity
API and CEP Predictive and
Prescriptive Analytics
Insight to Action
![Page 9: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/9.jpg)
Immediate Long-Term Competitive AdvantageValue to the Organization
TIBCO is the only analytics platform that provides business value across this Analytics Spectrum
Self-service Dashboards API and CEP
Predictive and Prescriptive Analytics
Measure Diagnose Predict Optimize Operationalize Automate
Analytics Maturity
Insight to Action
![Page 10: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/10.jpg)
Spotfire Visual Analytics - Interactive Brush-Linked
© Copyright 2000-2015 TIBCO Software Inc.
![Page 11: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/11.jpg)
Spotfire Visual Analytics + R Extensions
3D rotate SurfacePolar
Contour Network Funnel
© Copyright 2000-2015 TIBCO Software Inc.
![Page 12: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/12.jpg)
Spotfire + JS Extensions
Sankey Venn
ChordDonut
Gantt
WaterfallDials
© Copyright 2000-2015 TIBCO Software Inc.
![Page 13: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/13.jpg)
Dashboards and Themes – KPIs
![Page 14: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/14.jpg)
Dashboards and Themes – Company Specific
Mock-Up Only
Fictitious data
![Page 15: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/15.jpg)
Dashboards and Themes – Color
![Page 16: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/16.jpg)
Dashboards and Themes – Color
![Page 17: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/17.jpg)
Map Charts
![Page 18: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/18.jpg)
![Page 19: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/19.jpg)
![Page 20: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/20.jpg)
![Page 21: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/21.jpg)
![Page 22: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/22.jpg)
Map Layer
Marker Layer Feature Layer
Image LayerWMS Layer
Map Layers
© Copyright 2000-2015 TIBCO Software Inc.
![Page 23: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/23.jpg)
Roads
Labels
Borders
Standard map
Standard map - light
Basic map
Basic map - light
Base Map Options
© Copyright 2000-2015 TIBCO Software Inc.
![Page 24: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/24.jpg)
• Color• Shape • Size
• Relative amounts • Size
Marker Layer Feature Layer
• Color
Marker or Feature Layer
• Tooltip
• Labels
Map Elements
© Copyright 2000-2015 TIBCO Software Inc.
![Page 25: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/25.jpg)
Building Dashboards
Catalina Herrera
![Page 26: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/26.jpg)
Jaspersoft Pixel-Perfect Embedded Reports
![Page 27: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/27.jpg)
Analytic Workspaces & Analytic Fabric
APIs
Sear
ch, S
harin
g et
c.
Business Analysts Report Developers
Data Discovery Analytics Dashboards Reports Embedding
Analytic WorkspacesAnalytic environments
Analytic FabricConnectivity layer
Data Professionals
25%
Business Professionals
75%
BusinessApplications
Communication& Collaboration
Platforms
© Copyright 2000-2015 TIBCO Software Inc.
![Page 28: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/28.jpg)
Immediate Long-Term Competitive AdvantageValue to the Organization
TIBCO is the only analytics platform that provides business value across this Analytics Spectrum
Self-service Dashboards
Measure Diagnose Predict Optimize Operationalize Automate
Analytics Maturity
Predictive and Prescriptive Analytics APIs and CEP
From Dashboards to Value
![Page 29: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/29.jpg)
Big Data Analytics
© Copyright 2000-2015 TIBCO Software Inc.
![Page 30: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/30.jpg)
Data a Insight a Action
Data Access & Prep
Exploratory Data Analysis Features Visual
DashboardModel & Predict
Deploy Model
Test & Learn
Channel
Churn
Loyalty
Campaign
Filter
Map
Merge
Shape
Propensity
Affinity
Improve Guided -------- Deploy -------- In-LineExplore Data
Aggregate
Prepare DataBusiness Case
Increase Productivity
Grow Revenue
EnsembleForest
RegressionAdditive ModelsSegment
Visualize
Pricing
Promotion
ChallengerModels
At Rest
In Motion
Value Theses
Reduce Risk
ROI
Purchase
Dashboard Updates
Fast DataBig Data© Copyright 2000-2015 TIBCO Software Inc.
![Page 31: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/31.jpg)
TIBCO’s Enterprise Runtime for R (TERR)
• TIBCO has rewritten R as a Commercial Compute Engine • Latest statistics scripting engine: S a S-PLUS® a R a TERR• Runs R code including CRAN packages
• Engine internals rebuilt from scratch at low-level• Redesigned data objects, memory management• High performance + Big Data
• TERR is licensed from TIBCO• TERR Installs with Spotfire Analyst / Desktop and other TIBCO products (CEP, Stat Services)• Spotfire Server can manage all TERR / R scripts, artifacts for reuse • Standalone Developer Edition: www.TIBCOmmunity.com • Supported by TIBCO
© Copyright 2000-2015 TIBCO Software Inc.
![Page 32: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/32.jpg)
Spotfire and TERR local TERR on server
Spotfire-TERR – Local and Server
• Build models on data using local TERR engine embedded in Spotfire
• Build models on big data directly in TERR on server and display results in Spotfire
• Run TERR as parallel sessions on Hadoop cluster, controlled and visualized in Spotfire
Data Source TERR TSSS
Spotfire
Results
ODBCJDBCSDCFile
DataFunction
Larger Data
Modeling
Spotfire
LocalTERR
ODBCJDBCSDCFile
Data
Data Source
Both Spotfire and TERR can load data from any ODBC or JDBC compliant source or from Spotfire Data Connections (SDC) or Spotfire Information Links stored in the Spotfire library. © Copyright 2000-2015 TIBCO Software Inc.
![Page 33: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/33.jpg)
Date
R P
acka
ges
1/1/2002 1/1/2003 1/1/2004 1/1/2005 1/1/2006 1/1/2007 1/1/2008 1/1/2009 1/1/2010 1/1/2011 1/1/2012 1/1/2013
5000
4500
4000
3500
3000
2500
2000
1500
1000
500
0
Number of R- or SAS posts to Stack Overflow by week. (copyright by r4stats.com)
Number of contributed packages on CRAN(http://cran.r-project.org/)
> 6,000 Packages !
R Community
© Copyright 2000-2015 TIBCO Software Inc.
126 R User Groups in US and EMEA 6,000 User-Contributed Packages Very Active R Community
![Page 34: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/34.jpg)
Contextual Analytics- Right click- Forecasting
Contextual Analytics- Menu - Machine Learning
Simple Predictive Analytics in Spotfire
© Copyright 2000-2015 TIBCO Software Inc.
![Page 35: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/35.jpg)
Extensible Predictive Analytics – Expressions
Lines by TERR( contourLines(x,y) )
Color by TERR( kmeans(x1,x2) )
Interactive Spotfire Analytics with R/TERR- Expression – on the fly R code- Points: kmeans(), …- Lines: contourLines(), spline(), …- Expression Functions – sharing
© Copyright 2000-2015 TIBCO Software Inc.
![Page 36: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/36.jpg)
Analysis Workflows – Data Functions
Interactive Spotfire Analytics with R- Data Function- Robust Cluster Analysis- Any Analysis in R / CRAN
Variables driving segments- Random Forest
Revenue by product- Color by segment
![Page 37: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/37.jpg)
Analysis Workflows – Route Optimization
![Page 38: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/38.jpg)
Analysis Workflows – Route Optimization
![Page 39: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/39.jpg)
Predictive Analytics Dashboards
Mock-Up Only
Fictitious data
![Page 40: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/40.jpg)
Predictive Analytics
Customer Analytics Workflows
Anna NowakowskaPeter Shaw
![Page 41: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/41.jpg)
Immediate Long-Term Competitive AdvantageValue to the Organization
TIBCO is the only analytics platform that provides business value across this Analytics Spectrum
Self-service Dashboards
Predictive and Prescriptive Analytics
Measure Diagnose Predict Optimize Operationalize Automate
Analytics Maturity
Event Processing
From Dashboards to Value
![Page 42: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/42.jpg)
BIG DATAAT REST
FAST DATAIN MOTION
Insight to Action
![Page 43: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/43.jpg)
Spotfire Data Access
DATASOURCES
XMLRDBMSFlatFiles CubesSpread-
sheetsHadoop & Big Data
stores
AnalyticalDWs e.g.Exadata
Event Data Streams
ActiveSpaces
In-MemoryLoad data from source in to memory
In-DatabaseLeave data in DBDynamically load and discard data to visualize
On-DemandDynamically swap data in and out of memory.
SQLMDX
10100110
![Page 44: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/44.jpg)
Custom GUI-driven data access via SDK
SiebeleBusiness
Local data sources
AccessExcel STDF
Drag-and-drop
MySQL
SQL ServerOracle
Information Services(join, transform, reusable,
parameterized, dynamic query for in-memory use)
Databases
JDBC/ODBC
HadoopSFDC
PostgreSQL
TeradataNetezza
Etc.XML
RDBMS
FlatFiles
Spread-sheets
WebServices
OracleE-Business
RDBMSRDBMSRDBMS
SAP BWSAP R/3 DATA
FABRIC
Salesforce
ODBCOLE DB
SqlClient
Direct connection
OracleTeradataAsterMS SSAS
Teradata
Direct Query(dynamically query and retrieve data
for visualization and analysis)Databases
MySQLEtc.
OBIEE
NetezzaHadoop
© Copyright 2000-2015 TIBCO Software Inc.
Spotfire Data Access
![Page 45: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/45.jpg)
Winner of 2014 Strata Cloudera AwardFor Best Advanced Analytics Application
Hadoop & Spark
![Page 46: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/46.jpg)
TERR on the nodes of Hadoop Cluster
TERR in Action
• Hadoop cluster compute• TIBCO Cloud Compute Grid• TIBCO Streambase• TIBCO Business Events• KNIME• Lavastorm• Rstudio• Teradata• TIBCO Statistics Services• TIBCO Spotfire
Hadoop & Spark
![Page 47: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/47.jpg)
![Page 48: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/48.jpg)
Non Geographic Data – Map Chart Layers
© Copyright 2000-2015 TIBCO Software Inc.
![Page 49: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/49.jpg)
Non Geographic Data – Interactive Spotfire Charts
Airplane Seating Chart
Football Field Seating Chart
© Copyright 2000-2015 TIBCO Software Inc.
Spotfire Interactive Charts created by TERR script
![Page 50: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/50.jpg)
Spotfire API’s
Spotfire MapChart & GeoAnalytics
Andrew BerridgeMathew Lee
![Page 51: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/51.jpg)
Optimize pricing Check for
fraud
Make offer to customer
Restock inventory
Reroute transport
Give customer service
Proactively maintain machines
Fast Data Analytics – Interventions
© Copyright 2000-2015 TIBCO Software Inc.
![Page 52: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/52.jpg)
Spotfire – Getting Started
![Page 53: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/53.jpg)
Spotfire Education
![Page 54: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/54.jpg)
Spotfire Education
![Page 55: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/55.jpg)
Contact – Follow me on Twitter
Thank you!Michael O’Connell, PhDChief Data ScientistTIBCO [email protected]@MichOConnellhttp://about.me/moconnell+1-919-7401560
© Copyright 2000-2015 TIBCO Software Inc.
![Page 56: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/56.jpg)
![Page 57: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/57.jpg)
Creating a TERR data function in
Spotfire
Peter Shaw
© Copyright 2000-2014 TIBCO Software Inc.
![Page 58: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/58.jpg)
© Copyright 2000-2015 TIBCO Software Inc.
• Example shown here: Customer Churn
• Quick look at data
• Create data function in RStudio to draw curve on scatter plot
• Linear
• Quadratic
• Apply model to new data: Current customers.
• Create new column: Probability of churn
• Use this to drill-down to find at-risk customers
Outline
![Page 59: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/59.jpg)
© Copyright 2000-2015 TIBCO Software Inc.
R code
For this demo, the data is read into the R environment directly.Here Rstudio is configured to use the TERR engine as will be used in the data function.Alternatively, the data function can use a save() command to save any incoming objects to a disk file, and then these can be loaded into the interactive R environment.
![Page 60: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/60.jpg)
© Copyright 2000-2015 TIBCO Software Inc.
Data function development: linear model
![Page 61: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/61.jpg)
© Copyright 2000-2015 TIBCO Software Inc.
Quadratic model
![Page 62: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/62.jpg)
© Copyright 2000-2015 TIBCO Software Inc.
Streamlined data function for prediction
![Page 63: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/63.jpg)
© Copyright 2000-2015 TIBCO Software Inc.
• Thanks to Ujval Kamath and Ian Cook for developing early form of this demo
Thanks
![Page 64: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/64.jpg)
TIBCO Advanced Analytics Meetup
Product Update Including APIs
Andrew Berridge, Michael O’ConnellTIBCO Data Science
© Copyright 2000-2014 TIBCO Software Inc.
![Page 65: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/65.jpg)
© Copyright 2000-2014 TIBCO Software Inc.
65
Product Updates and APIs
• IronPython and APIs• Why Use IronPython with the Spotfire APIs?• Custom Sort Order API Example• IronPython Authoring Improvements in Recent Versions of Spotfire
• Spotfire Updates• Styling and Themes• Annotation and Collaboration
Agenda
![Page 66: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/66.jpg)
© Copyright 2000-2014 TIBCO Software Inc.
66
Two Books of Interest
A Picture is Worth a Thousand Tables• Graphics in Life-Sciences• Many useful lessons and analysis
examples for other industries
TIBCO Spotfire – A Comprehensive Primer• Covers how to use Spotfire• Practical real-world examples• A big section on IronPython, including documentation, examples
and code snippets• Covers predictive, geoanalytics and many other areas of Spotfire
![Page 67: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/67.jpg)
© Copyright 2000-2014 TIBCO Software Inc.
67
Why Use IronPython with the Spotfire APIs?Apply Customizations and Automate Multiple Tasks With a Single Click!• Apply customizations:
• Change axes
• Create new visualizations
• Set colorings, update color rules
• Produce analyses customized for users
• Extend features of Web Player (Consumer)• Roll up multiple user actions into a single click
• Work with data:• Set custom sort orders
• Set filters, mark data with “where” clauses
• Load data, refresh data
Using IronPython Automation Services extension, automate IronPython scripts with Automation Services
![Page 68: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/68.jpg)
© Copyright 2000-2014 TIBCO Software Inc.
68
Custom Sort Order API
Introduced in Spotfire 7.0• Important and not well known!
• In the past, it was not possible to programmatically set a custom sort order
• This could lead to unexpected sorting:• If not all values are known during analysis authoring;
• Then the data is refreshed, any new values will not be sorted accordingly
• API now allows sort order to be set (e.g. via an algorithm or external lookup
table)
• Can automate this via Automation Services Run Script extension; or via an
OnLoad IronPython script (triggered from JavaScript)
![Page 69: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/69.jpg)
© Copyright 2000-2014 TIBCO Software Inc.
69
Significant Improvements Since Spotfire 6.0
• Improved debugging
• Line numbers are shown when exceptions are thrown (when using the script
editor)
• New dialog for managing scripts, accessed from Edit->Document
Properties menu
• One click to “Trust All” scripts (IronPython or JavaScript)
IronPython Authoring Improvements
![Page 70: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/70.jpg)
© Copyright 2000-2014 TIBCO Software Inc.
70
Demo!
IronPython Authoring Improvements
![Page 71: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/71.jpg)
© Copyright 2000-2014 TIBCO Software Inc.
71
Custom Sort Order API
Spotfire Desktop Client only GUI for altering the sort order…
Here we see fruits sorted in size order
Refresh the data, for example, to add “Plum”, then it will automatically appear at the bottom of the sort order
New API allows us to set a custom sort order
![Page 72: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/72.jpg)
© Copyright 2000-2014 TIBCO Software Inc.
72
Custom Sort Order API
Demo!
![Page 73: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/73.jpg)
© Copyright 2000-2015 TIBCO Software Inc.
73
Annotate Visualizations; Comment on and Discuss Visualizations
• New ability to attach annotations to visualizations
• Annotations can be styled and placed anywhere on the visualization
• Collaboration allows conversations between users
• Conversations are recorded alongside the visualizations
Spotfire 7.5 Updates – Collaboration and Annotation
![Page 74: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/74.jpg)
© Copyright 2000-2014 TIBCO Software Inc.
74
Spotfire 7.5 Updates – Collaboration and Annotation
Demo!
![Page 75: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/75.jpg)
© Copyright 2000-2015 TIBCO Software Inc.
Spotfire 7.0 Updates – Theming and StylingSpotfire can now be themed and styled to suit YOUR design!
• Every aspect of the visual styling is customizable
• Set colors and fonts
• Background images, styles and colors
• Borders, visual layout
• Apply the style of one DXP file to another
![Page 76: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/76.jpg)
© Copyright 2000-2015 TIBCO Software Inc.
Spotfire 7.0 Updates – Theming and StylingExamples
![Page 77: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/77.jpg)
© Copyright 2000-2014 TIBCO Software Inc.
77
Demo!
Spotfire 7.0 Updates – Theming and Styling
![Page 78: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/78.jpg)
© Copyright 2000-2014 TIBCO Software Inc.
78
Spotfire 7.5 Updates – Infographics
![Page 79: TIBCO Advanced Analytics Meetup (TAAM) November 2015](https://reader035.vdocuments.us/reader035/viewer/2022070210/587278041a28abc7068b4a7b/html5/thumbnails/79.jpg)
79
© Copyright 2000-2014 TIBCO Software Inc.
Thank you!