Transcript cix sr datamarts

Global Spotfire Rollout:
One Year Later at GlaxoSmithKline
Spotfire Users Conference – October 2003
Presentation Outline
 One Year Later: How we did at GSK
 Review – Deployment Process and Issues
 DecisionSite Development – Process, Progress and

Issues
Retrospective – Lessons Learned
– Enterprise Support
– What is important to Users?
 Spotfire: Large Organization Conceptual Framework
 Summary & Questions
Global Spotfire Rollout: One Year Later at GSK
Global Rollout – How did we do?
Rollout Scope
 Three Organizations – R&D Discovery
 User Community - Diverse
 Site Distribution - Worldwide
 Timeframe – Mid-Summer 2003
Global Spotfire Rollout: One Year Later at GSK
Global Rollout – How did we do?
Results – One Year Later
 User Uptake: 1500+ Installs
 User Training: 800+ Trained
 User Distribution – Worldwide
 Infrastructure – 4 Server installations
 Timeframe – Early Fall 2002
 Server Logs tell the Story:
– 30,000 tool hits
– 6,000 DecisionSite Data Accesses
Global Spotfire Rollout: One Year Later at GSK
Global Rollout – How did we do?
One Year Later – Server Logs
DecisionSite Queries Per Week
Global Spotfire Rollout: One Year Later at GSK
Global Rollout – The Process
 Get the Money
 Install and Configure the Servers
 Configure the Client
 Lots of Testing
 Rollout
– Installation
– Communication
– Training
– Support
Global Spotfire Rollout: One Year Later at GSK
Global Rollout:
Getting the Money – Four Simple Steps
1. Enlist the support of a Very Senior Vice
President
2. Attach the request to a $XXX million dollar
strategic capital program
3. Structure the deal to capitalize most of the
expenditure
4. Create a Benefits Model
Global Spotfire Rollout: One Year Later at GSK
Global Rollout: Configuration
 Server Configuration: Processors, Storage,
Solaris, Oracle, Weblogix, Spotfire
 Client Configuration: Four desktop configurations
 Client Configuration Issues:
– Prior installs
– Sensitivity to IE security configuration
– DLL conflicts
Global Spotfire Rollout: One Year Later at GSK
Global Rollout: Communications,
Training and Support
 Communications: E-mail, Posters, Web notices


– “Cascade” e-mails most effective
Training: Informal Seminars, Formal Training, On-line
Training
– Smaller, informal seminars most effective
Support: Install issues, configuration issues
– Three-level model
– Majority – basic install and access
– Level three – complex install issues
– Training and Knowledge Base
Global Spotfire Rollout: One Year Later at GSK
DecisionSite Development: Issues,
Process, and Progress
 Context: The post-merger GSK environment has
some very specific characteristics:
– Data access and integration is “the” issue
– True global Discovery teams
– Biologists vs. Chemists
 Thus: In GSK DecisionSites, Data Access and
Integration is Key
 So: In scoping DecisionSites, we focused on
Data infrastructure and Data Access
Global Spotfire Rollout: One Year Later at GSK
DecisionSite Development: A “Phase 1”
DecisionSite at GSK
 One Guide: Get Data



– Pre-compiled and User Defined Queries
– Between 6 and 14 Query types
– Accessing between 19 and 200+ data sources from a
matching Data Mart
– Add compound properties and clustering
Data Integration Tools: Lookup properties, assay details,
Chemical Structure Visualization tools: looking at
structures, and compiling lists
Default set of Visualizations
Global Spotfire Rollout: One Year Later at GSK
DecisionSite/Data Mart Delivery Architecture
How Do They Work?
Global Spotfire Rollout: One Year Later at GSK
DecisionSites and Data Marts:
Progress on Delivery
 Increased Speed, Functionality, Quality  Project Delivery History
Time
Kinase
Delayed Delivery, Quality Problems
7TM
2X Data, 4X Queries, + Quality
Re-think:
IC1
IC2
- Process
- Scoping NR 1
- Organization
• ~ 8 Week Deliveries
• Good Quality
• Good Functionality
• Good User Engagement
Global Spotfire Rollout: One Year Later at GSK
NR 2
Pro1
Pro2
Tr1
DecisionSite Development: Process
Global Spotfire Rollout: One Year Later at GSK
GSK Deployment – Retrospective
Lessons Learned
 Funding: Jump on the moving wagon
 Configuration: Watch out for IE
 Deployment: Use the Very powerful tools
 Training:
– Don’t overestimate your audience
– Chemists and Biologists are Different
 DecisionSites: “Its about the DATA, stupid”.
– Data and tools come first
– Use the Resources section for Links
Global Spotfire Rollout: One Year Later at GSK
Spotfire: A Large Organization
Conceptual Framework
=
Global Spotfire Rollout: One Year Later at GSK
Decisions
X
Training
Tools & Models
Data
X
Spotfire Implementation Conceptual
Framework: Phase 1 – Data Access
=
Global Spotfire Rollout: One Year Later at GSK
Decisions
X
Training
Tools & Models
Data
X
Implementation Conceptual Framework:
Phase 2 – Model Deployment
=
Global Spotfire Rollout: One Year Later at GSK
Decisions
X
Training
Tools & Models
Data
X
Implementation Conceptual Framework:
Phase 3 – Decision Management
=
Global Spotfire Rollout: One Year Later at GSK
Decisions
X
Training
Tools & Models
Data
X
Summary – Strategic Blueprint
 Focus initially on delivering
integrated data – the carrot to get
users involved with Spotfire
 Invest in effective training – Spotfire
is powerful right out of the box
 Follow up with models and guides
that support decisionmaking
Global Spotfire Rollout: One Year Later at GSK
Acknowledgements –
Cheminformatics DecisionSite Team

CiX Management
– Steve Calvert, Fran Stewart, Deborah Jones-Hertzog

CiX User Representatives
– Dana Vanderwall, Andy Whittington, Deanna Garrison, Dan Svoboda,
James Roberts

CiX Data Mart Team
– Dan Ferko, Steve Chapman, Clark Bradley
– Paul Konstant and Julia Tseng - DBA support

CiX Technical and Development Team
– Terry Francis, David Turanski, Nate Fichthorn, Ryan Provencher

CiX Quality Team
– Sunny Hung, Richard Bolton



DIT Training Team: Xiaohong Gu, Kate Harvey, Paul Slater
Spotfire Support Team: Trish Ward, “Spotfire” Dan Nathan
User Management Sponsors and User Representatives (many!)
Global Spotfire Rollout: One Year Later at GSK
Contact Information, and Questions
 Larry Cone
 Independent Spotfire Consultantcy –
focus on data integration solutions
 [email protected]
 610-964-9843
 Questions and Answers
Global Spotfire Rollout: One Year Later at GSK
Questions?
Global Spotfire Rollout: One Year Later at GSK