Criterion 4. Case proposal for handling a hypothetical case study (max 130  – minimum threshold 85 points) A. Briefing and Background information  24  • Data on feed, including information about type, size and the year of sampling  of feed samples collected in a specific European area (identified by NUTS  nomenclature) and • data on wild-animal population found dead, including the species, the  geographical coordinates expressed as latitude and longitude together with the  cause of death including chemical contaminants found in the carcase. In addition to the above points, the tenderer should provide a case proposal to handle the  hypothetical case below. Case study – define and implement a plan for data integration with SSD2 and prepare  web-based scientific reports. EFSA Scientific Data Warehouse for chemical contaminants is based on SSD2 data  model. The SSD2 is designed to harmonise the transmission of data from data  providers to EFSA covering several data collection domains, namely: food additive  occurrence data, chemical contaminants occurrence data, pesticide residues  occurrence data, residues of veterinary medicinal products. The EFSA Scientific Data Warehouse is complemented by different Data Marts that  allow data to be aggregated and reported for specific needs and with different  historization purposes (e.g. snapshotting, slowly changing dimensions of type 2 etc.).  The actual dimension of the scientific data warehouse is around 437 GB and growing  of an estimate 30 GB every year.  As the scientific data warehouse architecture makes use of different decoding levels  for specific data points, the controlled terminology, an additional data layer of 110 GB  with a constant dimension, is used to decode the elements of the star schema’s  dimensions.  In this simulation (please note that the streams we will describe do not exist and are  merely used to evaluate data connection and collection capacity) EFSA scientific data  needs to be complemented with new data which can be considered structured and  unstructured.  The new hypothetical data streams will include:  Data on feed samples are considered sensitive and are submitted via the DCF by official  data providers, and data on wild animals is scraped from websites and is considered  non sensitive.  The estimated amount of data is around 50 GB, growing every year by 15 GB.  In this simulation the data will be then used by EFSA staff to address issues related to  feed and will be made available to the public in an aggregated dashboard form through  a BI tool and an interactive application to allow interactive visualisation and data  exploration. 