Public Dashboard Creation

[gabodor]

I have been tasked with creating a public facing dashboard.  This dashboard cannot interact directly with our database so I would build an excel spreadsheet that would populate the dashboard.  We want to refresh it every 2 weeks with the most current data.  We would like for there to be sliders so that people can narrow by time, location, and other types of general parameters.  Our license is through the university we are housed in though I am not sure exactly what is needed for this dashboard.  Where can I find trainings to help me do this?

Thank you,

Gari

[masonreed11t]

Power BI is a good fit for this. Use Excel as the data source, add slicers for dates, locations, and other filters, then refresh the file every two weeks. I'd recommend checking your university's Power BI licensing and starting with Microsoft Learn's free Power BI training resources.

[nidhigk]

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-excel-stunning-report

A step by step solution you an explore.

https://learn.microsoft.com/en-us/credentials/certifications/data-analyst-associate/?practice-assess...
The Microsoft Learn PL 300 training takes you through the steps end to end.

Dashboard in a Day is another option you can explore.

[ahadkarimi]

Hi @gabodor, you can find training and resources to help you create and manage your dashboard at: https://learn.microsoft.com/en-us/training/paths/dashboard-in-a-day/