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.  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  • The technical constraints posed by the tools on which EFSA relies for these  activities are the following at present:  B. Tasks 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.  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