During March-April of 2019 Vartas Oy provided Tehy with a prototype for analyzing and storing user data in the cloud. The goal was to test the new generation of cloud technology in data management and to produce visual statistics of members.
The end result was a solution built on Microsoft Azure and Power BI platforms which migrates member data from Tehy:s on-premise database to a cloud based one, serves the data through API interfaces to programs and presents the member count and division graphically in Tehy:s intranet and Teams channels. Additionally there were Power Bi analytics reports made for finer studying of the numbers (inside use).
The project was made in collaboration with the Tehy IT Department and ITaito Oy. Vartas was in charge of the Azure database, API interfaces, graphic embedding software and Power BI implementation.
Technologies: Azure On-premise Data Gateway, Azure Logic Apps, Azure Functions, Azure SQL, Vue.js, GraphJS, .NET Core Web API, SharePoint, Power BI