We created parameters (e.g. start date, end date, gender, age group) which will be passed to a python code which will extract the data accordingly from Microsoft SQL Server which is hosted on Azure.
Then we have another python code which is doing all the transformations and then we are doing the calculation for lost revenue.