The data for my dashboard comes from ArcGIS Pro. I create a map in ArcGIS Pro with data from SQL Server and publish it as web layer to ArcGIS Online. then, I make the required changes in the map viewer and use this map as the input layer in the dashboard. I have to update this dashboard on a monthly basis.
I am looking at automating this workflow. Please let me know if you have tried automating a similar workflow before or have any suggestions for me.
I am looking at Data Model using Model Builder and Python scripts as a solution. Just starting on these two.