|Summary of the work||Design, develop an Azure SQL based database to capture our asset data with a mobile friendly PowerAPP interface for our surveying team and some critical PowerBI reports for management information & reporting.|
|Latest start date||Sunday 31 January 2021|
|Expected contract length||6-8 weeks|
|Location||South West England|
|Organisation the work is for||GreenSquare Group|
|About the work|
|Why the work is being done||This work will allow the Group to exploit it's refreshed asset data from its stock condition surveys that are being carried out.
The work must be completed by the end of March
|Problem to be solved||The data is currently being captured in a 3rd party SQL based database. Greensquare needs to build it's own Azure SQL database instance to replicate the table structures and allow migration of this data into our estate.
This data must be mapped, merged and migrated into the proposed solution.
It also requires the development of a simple PowerApp to allow surveying teams to interface with the database and the production of 1-5 PowerBI reports to support analytics.
This includes a front end application to view and interrogate the database.
As the the database will hold asset data on properties, with unique ID of which is held in another Progress based database, the database must be required to interface with this database to be uplifted when the property population changes.
We are very open to having innovative solutions based on the the CDS/Dataverse via PowerApps premium.
|Who the users are and what they need to do||As an asset management lead, I need to understand the current condition of all of my stock so that I can understand my investment planning.
As a surveyor, I need to be able to complete a survey on my mobile device that updates the database with the condition of the stock I find.
As a BI Engineer, I need to be able to extract the data into an Azure Data Warehouse to support PowerBI reporting and data modelling for predictive analytics.
As a database admin, I need to be able to ensure and monitor the size and efficiency of the Database for operational efficiency processes.
As a user of the data, I need a simple user friendly PowerApp application view to the data, so that at the most basic level users can search for a property and the data (and potentially repairs/maintenance/compliance responsibility) for that property can be returned in an easily digestible format. This is particularly useful for the Repairs and Maintenance teams, who need to do this kind of querying regularly - for example, they may decide not to repair some aspects of a kitchen if it's due to be replaced.
|Early market engagement|
|Any work that's already been done||Business requirements have already been captured both functional and non-functional.|
|Existing team||There is a business lead, surveying lead, a project manager and a data/BI Engineer support.|
|Address where the work will take place||Chippenham Wiltshire - however fully expect to be working remotely.|
|Working arrangements||Remote working during COVID-19|
|Additional terms and conditions|
|Skills and experience|
|Essential skills and experience||
|Nice-to-have skills and experience||
|How suppliers will be evaluated|
|How many suppliers to evaluate||5|
|Cultural fit criteria||
|Payment approach||Fixed price|
|Additional assessment methods|
|Questions asked by suppliers|