Web app dashboards need to load data. Obviously.
But when should that data be loaded? Better yet, when should that data be calculated?
In a legacy, multi-tenant application, my team was faced with optimizing various dashboards and analytical data, that was being calculated via Linq to SQL and then loaded....on page load.
Enter Azure Functions. We were able to use them to pre-calculate our data between various tenants, and reduce our page load-time to around 1 second, with minimal financial implications. I'll present a high-level overview of the issue and how it was solved using queue-triggered and timer triggered azure functions.