content_image/496496.jpg content_image/496497.jpg content_image/496498.jpg
<img src='content_image/496496.jpg'>

<img src='content_image/496497.jpg'>

a BI tool and an interactive application to allow interactive visualisation and data exploration. 

For supporting data reporting EFSA will provide a tool to the data providers to map coherently their data with the ones of the proposed data model. 

## B. Tasks 

Basic requirements: 

• The technical constraints posed by the tools on which EFSA relies for these activities are the following at present: 

o Oracle for data storage, 

o SAS data integration for data integration processes, 

o Microstrategy as a BI tool and for creating dashboards, 

o SAS and R for data analysis, 

o R-Shiny for creating interactive visualisations, 

o Java and Knime for data reporting tools. 

• The new data streams must be made available through a common data store and integrated with EFSA controlled terminology, and from there to the data processing systems, considering the specific software component constraints listed in section above. 

• Data streams should employ mechanisms to minimise the impact of changes in the data source and in the data format in terms of the need to refactor the consuming systems of the data platform. 

• Security is a centralised process in EFSA therefore should be added as an analysis and implementation step. 

• The estimated effort for this request shall not exceed 190 person days as a full year equivalent. 

• The duration of the assignment shall not exceed 6 months. 

The tenderer is requested to prepare and design a case proposal covering the requirements described in the sub-criteria 4.1, 4.2 and 4.3 below: 

<img src='content_image/496498.jpg'>

