I have experience creating dashboards and reports in Power BI as well as in Google Data Studio. I will take a view or tables from your data source and create a dataset for the dashboard and reports. With flexible filters, you can drill down the reports in terms of calendar, location, etc. Please check the image of such dashboards and reports.