Introduction of a data warehouse for reporting and statistics

[SandGrainOne]

Description

It should be easy to quickly look at and organize data about how the Altinn solution(s) are being used. To achieve this there is a need for a dedicated system that can collect data and transform it to optimize for statistical queries.

https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-analytical-processing

https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/data-warehousing

In scope

Identify possible products that can serve as a data warehouse for Altinn 3.
It should be easy to set up data collectors from CosmosDB, PostreSQL, Blob Storage, Application Insights, API Management and so on.

Out of scope

What's out of scope for this analysis?

Constraints

Constraints or requirements (technical or functional) that affects this analysis.

Ops requirements

Are there any requirements for monitoring? What is being built and what could go wrong? Are there any requirements related to backup?

Analysis

Lorem ipsum

Conclusion

Short summary of the proposed solution.

Tasks

• [ ] Is this issue labeled with a correct area label?
• [ ] QA has been done