In Dec. 2015, the Centre for Tropical Livestock Genetics and Health (CTLGH) was launched at the International Livestock Research Institute (ILRI) Nairobi Campus in Kenya. CTLGH partners from The Roslin Institute, Scotland’s Rural College (SRUC) and ILRI gathered to kick start the Centre’s research programmes funded by the Bill & Melinda Gates Foundation (BMGF). These programmes will focus on the identification of optimal genotypes for dairy cattle and poultry production in Africa, establishing precision breeding technologies to improve livestock productivity and tolerance to tropical diseases and pests, and on creating open data and biological sample resources.

A second BMGF award to Royal (Dick) School of Veterinary Studies (R(D)SVS) of £5.5M to support evidence-based interventions in livestock, further increased the collective commitment to address global challenges and establish international partnerships. It this second grant award that is in scope for the provision of University of Edinburgh (UoE) IT/IS consultation.

This project (under SEBI Programme 2) was initiated following the initial setup of the Tableau server, with the aim of entering into a more formal partnership with UoE Information Services to deliver a data analytics capability for SEBI, and to establish the long term sustainability of the platform. 


This project will deliver the technical components to support the development of the SEBI Community Of Practice (COP). This initially includes the Single Sign On capability for Tableau server(s), and a database repository for the COP data sources. Subsequent deliverables include a web presence for SEBI partners, a process for transforming source data for ingest to the data repository, and an Operating Level Agreement (OLA) with the UoE partners providing and supporting the technical components of the service. The scope does not include direct support to SEBI partners and users but is proposed as a fixed cost model to provide management and operational running of the platforms underpinning the SEBI service.


Objectives, Deliverables and Success Criteria

Objective Deliverable Success Criteria Priority 
O1. Implement Tableau platform

D1. Ensure Tableau platform is fit for purpose for use throughout the duration of the grant.



Single Sign On Authentication for SEBI COP partners


Review of Tableau infrastructure, fault tolerance, and business continuity options

Must have



Should have


O2 Implement database repository D2. Install a database repository server to be used to collate grant data. This server will also be used to provide data to Tableau for analysis, reporting and visualisation. It is proposed that a single, minimal spec MS SQL Server instance be deployed initially to provide the means for the Data Coordinator and Data Analyst to store data, and to provide a primary data source for Tableau. The infrastructure should be reviewed under Objective 3 to ensure



Tableau platform connected to database repository.


Database utilised for grant information as well as data for analysis and presentation by Tableau.



Must have


Must have


O3 Implement Data Transformation Processes D3. Develop transformation processes to ensure data is fit for use from source to ingest into database.

At least one means of partners submitting source data to the repository.

Standardised data schema exists.

Must have

Should have

O4 Implement an external facing web presence

D4. Act as a public facing web site, providing:

  1. Relevant and necessary grant award information
  2. Relevant organisation and contact information
  3. Public/open access information

Single point of reference for partnership access, facilitating:

  1. Data sharing
    • Secure upload
    • Secure download
  2. Partner specific support and guidance



Interested parties can access necessary information on grants, organisational contacts etc.


Partners have means of secure upload and download of data.







Must have



Should have




O5 Provide support for technical components of SEBI service D5. Agreement on operational support model. This is likely to be a model based on a one year fixed cost to IS to provide management and operational running of the platforms underpinning the SEBI service (reviewed annually).

SEBI Project Sponsor, IS USD and IS Apps Section Heads clear on roles and responsibilities.



Review ongoing arrangements (annually)

Agree arrangements for long term sustainability of service.



Must have



Must have

Should have





09-Dec-2016 End of Planning
23-Dec-2016 Establish interim support arrangements
06-Jan-2017 Implement Database platform
16-Jan-2017 Establish external web presence
27-Jan-2017 Data Analytics Authentication
14-Apr-2017 Deliver Data Transformation workflows
28-Apr-2017 Agree long term support arrangements
30-Jun-2017 Closure


Project Info

SEBI - Data Collection and Modelling
MVM Research (MVMRES)
Management Office
Project Manager
Colin Watt
Project Sponsor
Andrew Peters
Current Stage
Project Classification
Start Date
Planning Date
Delivery Date
Close Date
Programme Priority
Overall Priority