Having billions of rows in the database and several slow data sources, requires special considerations when transporting and presenting the data. So how do you solve the performance challenge? Do you build a solid caching strategy and design a complex web solution? Alternatively, you can bring the data as close to the end user as possible and keep the web application simple.
In this session, we will explain our architectural approach to processing and presenting large data sets in a web application to the end customers. We will present to you the whole data flow: how we move the data to Azure SQL Database, transform it using Azure Databricks, use Azure Analysis Services to build the data model including business logic and KPI engineering and lastly implementation of row-level security. We will also show you how we visualize the data in the web application using Microsoft Power BI Embedded. This approach makes it possible to filter and aggregate the data very efficiently, thus helping to provide a rich user experience to your customers. We will compare our solution with other more traditional approaches and discuss the pros and cons of this implementation.
Irina is a Software Engineer passionate about modern web development. Currently, Irina is a Solution Designer at Vattenfall AB, Sweden, working with a portal for large corporate customers. In her spare time, she enjoys spending time with her family and friends, skiing, travelling, reading, playing brain games.