Hi, just wanted to know is there a way in which the data fetched from statistical API can be used to generate dashboards or analytics using tools like Power BI or Tableau. Would I have to save the data into a database, if so how should I do that, since the statistical API does not allow that. Is there anyother way also to do this ?
Hi! Thanks for the question. You are correct that Statistical API doesn’t save into a database but into a json output. However, it is super easy to convert the output into a pandas dataframe using a little bit of Python.
There is a good example of this in the Sentinel Hub Python package documentation here. Once you have your Pandas dataframe you can build your dashboard.