Company and organisational data explorer - toolkit sandbox

THIS IS A CONTRACT AWARD NOTICE The FRC's requirement is a supplier to develop a sandbox toolkit to allow the ingestion of XBRL data and files, processing, structuring, enhancement, and storage of the raw and iterative data sets. Use of the data would be through a set of data tools and connection to visualisation software and connection to SQL databases for analytics. Once developed, the supplier will support the FRC in running at least two design sprints (using Double Diamond framework - https://www.designcouncil.org.uk/our-resources/the-double-diamond/ - or similar) focused on certain use cases and enhancing the resultant data visualisations, dashboards and tools as agreed. The supplier will provide full support for the sandbox during the contract period (22 April 2024 to 28 Feb 2025) and assist the closure of the system at the end of the contract. The objective of the project is to: • Design and specify an Azure based data platform utilising Microsoft ETL tools, such as Synapse or Data Factory, with appropriate security and governance controls, including Cyber Essential Plus compliant. • Create a sandbox platform to ingest, store, process and visualise XBRL data (see Architecture Diagram for details) • The design will include network architecture, data orchestration architecture, security architecture, storage and encryption of raw and iterative data sets, and monitoring and event analytics. Encryption needs to meet AES 256 standards. Monitoring and event analysis needs to cover both authorised used and intrusion detection. • Work with the FRC and partners to run a series of design sprints (at least 2) focused on certain use cases and enhancing the resultant data focused on optimising the capabilities of the sandbox to meet specific user needs. • Support the sandbox platform for at least 10 months. • Deliver training to increase data management and data transformation skills using a Microsoft Azure Synapse (or latest Microsoft equivalent) environment.