Adopting Tibco Spotfirein Bio-Informatics

Herwig Van Marck

Footer

Tibotec – VircoWho we are and what we do

• Virco applies advanced technologies to improve the diagnosis and management of infectious diseases

– Virco TYPE HIV-1– VircoNet– Antivirogram

• Tibotec aims to discover innovative and effective drug candidates against a range of life-threatening infectious diseases

–HIV

–Tuberculosis

–HCV

Footer

People & locations

Employees• Tibotec & Virco 550

• Drug Discovery• Drug Development• Virco• Shared Services

Facilities• Tibotec, Virco

Mechelen, Belgium• VircoLab, Inc

Raritan, NJ; Durham, NC • Tibotec, Inc. Yardley, PA• Tibotec Pharmaceuticals Ltd

Cork, Ireland

Footer

Correlation Analysis (dummy data)

Footer

Overview

• Advantages TIBCO Spotfire over DecisionSite– Improved formatting

• Better use of display real estate• Output closer to a report

– Custom expressions– Details visualisations– Multiple data tables– Column from marked– Text area for annotations and shortcuts– Tags

• Disadvantages– No support for chemical structures yet

Footer

Custom Expressions

• Avoid columns that are only used in a particular visualisation to clutter the data

• Different labels for different visualisationsCount() as [# viruses per bin]

• AggregationCovariance([pFC],[pFC (2)]) / (StdDev([pFC]) * StdDev([pFC (2)])) as

[Correlation]

Footer

Details visualisations

• Data selection depends on marked data in other visualisation– Use trellis to provide title

Footer

Using Multiple Data Tables

• Different data sources– One-to-many relations between different data tables

• Same data in different pivot state• Refreshing data or using files as templates• Cartesian product

Footer

Using Multiple Data Tables: Cartesian product

• Duplicate the source data by adding a data table using the “Existing data table …” option

Footer

Multiple Data Tables: Cartesian product

• Create the Cartesian product by inserting columns with the “Existing data table …” option

Footer

Using Multiple Data Tables: saving

• Use “Linked …” when saving so data from existing data tables stays linked

• “Setting for Linked Data” allows you to specify which tables to fix

• Non linked data sources can always be replaced with new data

Footer

Column From Marked

• Column used on an axis depending on what you mark in a different visualisation– Used together with details visualisation to provide axis labels

"pFC " & [DRUG] as [pFC DRUG]

Footer

Text Area

• Extra information on the analysis

• Shortcuts to specific selections and markings

• To improve the overall layout

Footer

Using Tags

• Editable labels– Use Tag Collection column as the “Labels by” column– Configure the key columns !

Footer

Simple Structure Viewer

• Uses the map chart– WMF image background• Powerpoint slide saved as WMF

– Auto-zooming details visualisation• Coordinates of 2 corners in separate data table

Footer

Questions?