Wellcome Trust Sanger Institute’s research teams use Tableau Desktop to identify samples in their pipeline or determine baselines for research projects. In Tableau Desktop, users pull data from the institute’s Oracle database to create Tableau workbooks. Teams share workbooks over Tableau Server—allowing them to easily track project progress. And with scheduled updates, researchers know they are using current data. Mark Sanderson, Advanced Research Assistant, explains how tracking samples now takes 30 minutes instead of three and half hours. What started on a few small teams has developed into a company-wide solution. The institute is in the process of creating team scorecards in Tableau so that managers can track team metrics and performance.
Tableau: Tell us about the Sanger Institute. Mark Sanderson, Advanced Research Assistant: The Sanger Institute is one of the world leaders in scientific research, specializing in genomes and bio-data. We produce an enormous amount and on a minute-by-minute basis. Tableau has really helped us. Tableau: How does Tableau fit into your workflow? Mark: So across the institute we have a very broad range of science being performed. I work in a team that runs a high throughput pipeline. We produced an enormous amount of data. We never stop, come rain or shine. And we use a specifically built Oracle database. Our database is fantastic for inputting data, for working out where samples are in the pipeline, and it's fantastic for getting reports out. But its visualization capability is quite limited. And although Excel is fantastic at what it does, Tableau can really add value to that by allowing us to visualize our data on almost a minute-by-minute basis, with our live connection from the server to our database.