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.  Basic requirements:  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:  25  B. Tasks • The technical constraints posed by the tools on which EFSA relies for these  activities are the following at present:  o SAS data integration for data integration processes   o Oracle for data storage   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.  Quality award criteria for case study Maximum  points achievable  (130  – minimum threshold 85 points)  4.1. Quality of the planning  30 – minimum 20 Provide your planning assumptions  and high-level project plan  containing: a decomposition of the project into phases   deliverables  and  work  packages   duration   effort  and  resource/profile allocation. 30 4.2. Quality of the implementation 50  –  minimum 30