The team conducted a series of client workshops, interviewing stakeholders and users to garner the requirements and information to feed into the solution to meet the organisations objectives.
During these interviews it was clear that there were knowledge gaps in certain areas, we engaged with 3rd parties to bridge the gap and was able to seek further clarification.
We completed the discovery and analysis stage that clarified general capabilities, data integrity, data source mapping and an architectural overview. From these findings we designed a cloud hosted data warehouse incorporating best practice methodologies using the Azure Cloud technology stack, including automated data processing, archiving, and providing data in the required format for reporting.
We also performed a cloud readiness assessment and delivered a practical roadmap to facilitate the journey to cloud. This highlighted areas that needed prioritising, such factors included:
- The need for upskilling existing team to maintain the environment.
- Existing processes that can be transformed.
- Migration and reduction of on-site infrastructure.
- Integration of SAS products currently deployed in the organisation.