Spot f i re Dec is ionSi t e 8 .0Audio: 1-888-967-2253

Conf : 407709

Spot f i re Dec is ionSi t e 8 .0Audio: 1-888-967-2253

Conf : 407709

Dylan CotterApplication Specialist, Business Development

Dylan CotterApplication Specialist, Business Development

AgendaAgenda

• Spotfire DecisionSite Introduction

-Company Update

-DecisionSite Analytic Applications and Benefits

• Oracle Features Used

• Demonstration

-Leveraging Oracle Technologies within DecisionSite

• Summary & Q/A

Spot f i re Overv iewSpot f i re Overv iew

• Leader in Guided Analytic Applications and Services• 800+ Global 2000 Customers; 30,000+ users• 160+ World Wide Employees- Sales and Support• Headquartered in Somerville, MA and Göteborg, Sweden• Dominant in life science

- All major Pharmas + 250 Biotechs- Discovery: Proteomics, Genomics, HTS, Lead

Optimization, ADME/Tox- Development: Clinicals, Pilot, Manufacturing, Supply-

chain, Sales/Marketing

• Leader in Guided Analytic Applications and Services• 800+ Global 2000 Customers; 30,000+ users• 160+ World Wide Employees- Sales and Support• Headquartered in Somerville, MA and Göteborg, Sweden• Dominant in life science

- All major Pharmas + 250 Biotechs- Discovery: Proteomics, Genomics, HTS, Lead

Optimization, ADME/Tox- Development: Clinicals, Pilot, Manufacturing, Supply-

chain, Sales/Marketing

Dec is ionSi t e Plat formDec is ionSi t e Plat form

• Powerful data access- access to many data sources

• State of the art visualizations- multiple, linked, dynamic plots

• Easy to use- intuitive UI, Guides

• Extend analysis methods- deploy new algorithms or tools

• Develop new Analytic Applications- support future analysis processes

• Share decisions- dynamic, interactive reports

Produc t Overv iew

• Access to any data- One-click data retrieval to

ad-hoc querying- Integrated- Multiple sources- Unified data view

• Continuous data exploration and analysis

- Linked Visualization- Dynamic filtering- One-click analytic formulae

and computations- Drill down to details

Dec is ionSi t e Post ersDec is ionSi t e Post ers

• Enable teams to collaborate around data driven decisions

- Across geographies, - Across time zones- Across boundaries- Across disciplines

• Extends the value of Guided Analytics across the enterprise to facilitate better, faster team decision-making

• Manages decisions as company assets creating Decision I.P.™

• Interactively filters data via range sliders, check boxes, or radio buttons with dynamic detail drill down

Spot f i re is used ac ross t he ent i re L i fe Sc ienc e Value ChainSpot f i re is used ac ross t he ent i re L i fe Sc ienc e Value Chain

• Making highly informed risk-based decisions requires

- Early establishment of a 360 view of candidate compounds- Analytic approach supporting an iterative, exploratory process

• Making highly informed risk-based decisions requires

- Early establishment of a 360 view of candidate compounds- Analytic approach supporting an iterative, exploratory process

ClinicalADME/ToxLead

OptimizationLead

DiscoveryTarget

Identification

Target Validation

Hit Identification

Lead Promotion Safety Report

CompoundProperties

AdaptationResults

ADME Properties

FDA

FDAAdverse Events

1. H igh-Throughput Sc reening1. H igh-Throughput Sc reening

• Spotfire configuration- High Throughput Screening

• Shared users- Biologists in primary & secondary

screening• Solution Business Impact

- Automated workflow/processing of high throughput screening data

- Multiple views and slices of the processed data revealing inconsistencies

- Best practices for analyzing HTS data are institutionalized

- Better quality/confidence leads delivered to secondary screening and medicinal chemistry

• Spotfire configuration- High Throughput Screening

• Shared users- Biologists in primary & secondary

screening• Solution Business Impact

- Automated workflow/processing of high throughput screening data

- Multiple views and slices of the processed data revealing inconsistencies

- Best practices for analyzing HTS data are institutionalized

- Better quality/confidence leads delivered to secondary screening and medicinal chemistry

2. Lead Ident i f ic at ion2. Lead Ident i f ic at ion

• Spotfire configuration- Chemogenomic analytics

• Shared users- Toxicologists, pharmacologists,

chemists

• Solution Business impact- Identify compounds with similar gene

expression signatures (“fingerprints”) - Incorporate chemical structure,

clinical chemistry and histopathology data into the analysis to better define relationships between compounds

- Use compound relationships to anticipate toxic behavior in unknown compounds

• Spotfire configuration- Chemogenomic analytics

• Shared users- Toxicologists, pharmacologists,

chemists

• Solution Business impact- Identify compounds with similar gene

expression signatures (“fingerprints”) - Incorporate chemical structure,

clinical chemistry and histopathology data into the analysis to better define relationships between compounds

- Use compound relationships to anticipate toxic behavior in unknown compounds

3. Com pound Prof i l ing3. Com pound Prof i l ing

• Spotfire configuration- Lead Discovery

• Shared users- Medicinal Chemists

• Business impact- Compounds profiled across

departmental and domain borders- Chemists get insight into biology,

biologists insight into chemistry- Best practices for compound

selection can be institutionalized- Better quality leads delivered to

ADME/Tox / pre-clinical areas

• Spotfire configuration- Lead Discovery

• Shared users- Medicinal Chemists

• Business impact- Compounds profiled across

departmental and domain borders- Chemists get insight into biology,

biologists insight into chemistry- Best practices for compound

selection can be institutionalized- Better quality leads delivered to

ADME/Tox / pre-clinical areas

4. Func t ional Genom ic s4. Func t ional Genom ic s

• Spotfire configuration- microarray data analysis

• Shared users- Biologists in target discovery

• Business impact- Identify data sources- Select methods of data

transformation- Incorporate appropriate tools

analysis to test hypothesis- Add known information to extend

the analysis- Identify subsets of genes for

further study- Decision process involves

identifying subsets of genes for further study, accept or reject hypothesis and share conclusions

• Spotfire configuration- microarray data analysis

• Shared users- Biologists in target discovery

• Business impact- Identify data sources- Select methods of data

transformation- Incorporate appropriate tools

analysis to test hypothesis- Add known information to extend

the analysis- Identify subsets of genes for

further study- Decision process involves

identifying subsets of genes for further study, accept or reject hypothesis and share conclusions

5. Cl in ic a l Tr ia ls – Phase I , I I , I I I5 . Cl in ic a l Tr ia ls – Phase I , I I , I I I

• Spotfire configuration- Adverse Event Analysis

• Shared users- Clinical trial/data managers,

statisticians, and medical monitors

• Business impact- Identify types/frequency of adverse

events

- Outliers indicating errors in data recording

- Explore frequency/severity of adverse events, demographic influences, statistically significant dependencies between event type and dosage

- Issues in clinical trials can be detected earlier

• Spotfire configuration- Adverse Event Analysis

• Shared users- Clinical trial/data managers,

statisticians, and medical monitors

• Business impact- Identify types/frequency of adverse

events

- Outliers indicating errors in data recording

- Explore frequency/severity of adverse events, demographic influences, statistically significant dependencies between event type and dosage

- Issues in clinical trials can be detected earlier

6. Pharm ac eut ic a l Sales & Mark et ing6. Pharm ac eut ic a l Sales & Mark et ing

• Spotfire configuration- Pharmaceutical Sales & Marketing

• Shared users- Business analysts, brand/product

managers, sales/marketing managers

• Business impact- Leverage very expensive IMS into

analytic environment- Drive informed sales force

deployment decisions- Integrate IMS / prescription data,

patient demographics, physician data, and GIS data

- Market and sell in area where effect is optimal

• Spotfire configuration- Pharmaceutical Sales & Marketing

• Shared users- Business analysts, brand/product

managers, sales/marketing managers

• Business impact- Leverage very expensive IMS into

analytic environment- Drive informed sales force

deployment decisions- Integrate IMS / prescription data,

patient demographics, physician data, and GIS data

- Market and sell in area where effect is optimal

Extend the Analysis:- Validate microarray results

with rtPCR- Compare gene expression

with protein expression- Chemogenomics: integrate

chemistry support- Toxicogenomics: integrate

Toxicology data

Analy t ic Appl ic at ions Suppor t Many NeedsAnaly t ic Appl ic at ions Suppor t Many Needs

Chemogenomics

Protein expression

Toxicogenomics

Compare microarray and rtPCR data

Orac le Feat ures Used Today

• Spotfire DecisionSite Server supports Oracle Enterprise/Standard Databases:

- Oracle 10g

- Oracle9i Release 2 (9.2.0.x) and Release 1(9.0.1)

- Oracle8i Releases 8.1.7 and 8.1.6.

• DecisionSite’s Information Interaction Services can use Oracle as as federated database access Query and Join Engine for multiple and disparate database access

• Storage of the Meta Layer of Disparate data sources as an Information model that is a business representation of data sources

Orac le Feat ures Used Today

• Use of Oracle SQL functions for data manipulations

• Oracle Chemistry cartridges in combination with partner companies provide:- Chemical Storage technologies- Chemical content repositories- Integration capabilities- Screening data repositories

• Enhanced Information Link APIs for Oracle name resolverservice provides row level security to data retrieved for analysis

Dec is ionSi t e 8 .0 Arc h i t ec t ureDec is ionSi t e 8 .0 Arc h i t ec t ure

Information Interaction Services

Information Interaction ModelInformation Links

Application Manager

Web Service APIs

DB2SQL svrMySQLJDBC SPI

csv,txt other

DecisionSite Server

Reusable Components

HTTP/COM HTTP/SOAP

Applications

Guides

Security & Administration

Custom

LDAPWinNT

Oracle

Java

Tools

Posters

Guides

Analysis

Import Agent

JDBC

LibraryApplication Manager

DecisionSite Client Other Application Clients

Calculations

Filtering

Visualization

Excel Email Intranet . . .

JAAS SPI

Browser APIs App Manager APIs

Calculations

In form at ion In t erac t ion Serv ic esInform at ion In t erac t ion Serv ic es

Implement a solution that allows for rapid report development and reduces reliance on IT developers to create and deploy reports.

• Administrators create query environments without having to program

• Can publish queries and/or query elements to the right user user communities without programming

• Allow users to Focus on analysis and decisions instead of data retrieval

• Utilize Oracle SQL Functions for Data Manipulations

• Implement Oracle row level securtity

• Administrators create query environments without having to program

• Can publish queries and/or query elements to the right user user communities without programming

• Allow users to Focus on analysis and decisions instead of data retrieval

• Utilize Oracle SQL Functions for Data Manipulations

• Implement Oracle row level securtity

In form at ion L ink sInform at ion L ink s

• Allow users to access the data they need to do their jobs without knowing how to program databases

• Load (and reshape) data with a single click

• ask questions to refine data returnedE.g.

- Ask the user to select Business Units and Markets over a data range

• Allow users to access the data they need to do their jobs without knowing how to program databases

• Load (and reshape) data with a single click

• ask questions to refine data returnedE.g.

- Ask the user to select Business Units and Markets over a data range

How to implement a solution that allows for rapid report development and reduces reliance on IT developers to create and deploy reports ?

Dem oDem o

• Guided Workflow for Lead Identification

• How to Create an Information Model and Link

• How to Capture and Share the Analysis Process

Dem oDem o

• Retrieve Data- Screening, Chemical Properties, and Structure

• Visualize and Browse data• Explore “drug-ability” of compounds

- Which ones have drug-like properties?- Which ones are potent for our target (leukemia)?

• Explore selectivity and structure of findings- How do compounds with a similar structure compare?

• Report results of analysis

• Do it!

• Retrieve Data- Screening, Chemical Properties, and Structure

• Visualize and Browse data• Explore “drug-ability” of compounds

- Which ones have drug-like properties?- Which ones are potent for our target (leukemia)?

• Explore selectivity and structure of findings- How do compounds with a similar structure compare?

• Report results of analysis

• Do it!

Sum m arySum m ary

• Powerful data access- access to many data sources

• State of the art visualizations- multiple, linked, dynamic plots

• Easy to use- intuitive UI, Guides

• Extend analysis methods- deploy new algorithms or tools

• Develop new Analytic Applications- support future analysis processes

• Share decisions- dynamic, interactive reports

Sum m arySum m ary

• Spotfire DecisionSite is the preferred analysis environment for 18,000+ scientists and ultimate database front end for highly interactive visual analytics and data trending providing the “exploratory flexibility” that doesn’t come from BI/reporting or Statistics

• Guided Analytics are rapidly emerging as the best way to deploy complex, analytic applications to a “mainstream” (non-expert) user base

• Oracle’s Data Mining tools and Text Mining Option provide rapid insight for large volumes of data in the database and combined with Spotfire DecisionSite’s interactive visual environment serve as the optimal analytic solution

• Spotfire offers many tools to support the Application Developer- Connection with data warehouse and other disparate sources- Integration with other applications

• Spotfire DecisionSite is the preferred analysis environment for 18,000+ scientists and ultimate database front end for highly interactive visual analytics and data trending providing the “exploratory flexibility” that doesn’t come from BI/reporting or Statistics

• Guided Analytics are rapidly emerging as the best way to deploy complex, analytic applications to a “mainstream” (non-expert) user base

• Oracle’s Data Mining tools and Text Mining Option provide rapid insight for large volumes of data in the database and combined with Spotfire DecisionSite’s interactive visual environment serve as the optimal analytic solution

• Spotfire offers many tools to support the Application Developer- Connection with data warehouse and other disparate sources- Integration with other applications

Cont ac t In form at ionCont ac t In form at ion

Thank you for your attention!

www.spotfire.com

dylan.cotter@spotfire.com

Thank you for your attention!

www.spotfire.com

dylan.cotter@spotfire.com

/freedom to wonder_power to decide

• Abstract: Spotfire is an independent software vendor (ISV) that leverages the Oracle technology platform to provide interactive visual analysis software. Spotfire DecisionSite’sinteractive visual analytics speeds data analysis for decision-makers across the organization, helping them make decisions faster, more easily and with increased confidence.

In this eSeminar, we will show you how data analysis groups in research and development such as cheminformatics, bioinformatics, and computational chemistry can leverage Oracle technologies with Spotfire’s DecisionSite 8.0. We will show how DecisionSite's Information Services provides unified access to your data through an intuitive information model where users can perform ad-hoc querying using easy point-and-click Information Links. Information Links give users role-based access to data without the need to know query languages or underlying database schemas and take advantage of many Oracle features including Oracle Chemical Cartridge integration, SQL functions for data manipulation, and row level security for data retrieved for analysis.

We will present how DecisionSite’s high-impact visualization and analytic capabilities incorporating Oracle technologies let users examine the chemical and biological dimensions of their data and perform a wide array of numerical and structural analysis. We will show how to capture the ad hoc analysis processes from an organization’s domain experts for sharing in re-usable Guided Analytic Applications and how DecisionSite Posters make analytic decisions a core company asset.

• Abstract: Spotfire is an independent software vendor (ISV) that leverages the Oracle technology platform to provide interactive visual analysis software. Spotfire DecisionSite’sinteractive visual analytics speeds data analysis for decision-makers across the organization, helping them make decisions faster, more easily and with increased confidence.

In this eSeminar, we will show you how data analysis groups in research and development such as cheminformatics, bioinformatics, and computational chemistry can leverage Oracle technologies with Spotfire’s DecisionSite 8.0. We will show how DecisionSite's Information Services provides unified access to your data through an intuitive information model where users can perform ad-hoc querying using easy point-and-click Information Links. Information Links give users role-based access to data without the need to know query languages or underlying database schemas and take advantage of many Oracle features including Oracle Chemical Cartridge integration, SQL functions for data manipulation, and row level security for data retrieved for analysis.

We will present how DecisionSite’s high-impact visualization and analytic capabilities incorporating Oracle technologies let users examine the chemical and biological dimensions of their data and perform a wide array of numerical and structural analysis. We will show how to capture the ad hoc analysis processes from an organization’s domain experts for sharing in re-usable Guided Analytic Applications and how DecisionSite Posters make analytic decisions a core company asset.