My municipality is working on a transparency portal and ArcGIS Hub seems to be the favorite solution to this. I have a good amount of the skeleton completed so far but there are some more pointed questions I still have.
The desire is to host department specific KPIs on the home page of the hub site (summary statistic element). Think of things like police response times, number of utility dispatches etc. Many of our departments do not have GIS integration and may keep their data as spreadsheets. Is there any good way of connecting to these databases using something like Power BI, or will these datasets have to be added as content items to our ArcGIS Online to be integrated?
Trying to avoid having to manually type in new KPIs in the stat cards every month or from having to re-sync/re-add these datasets as Content items constantly.
If you can use something like Power BI to interface Hub with other datasets, what does that look like? Any good guides on doing that?
Let me know if any clarification is needed, I am still figuring out deliverables and "wants" as we go as well.
Thank you!
