cix sr datamarts
Download
Report
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