Building reporting tool

Hi all, hope this discussion is suitable for this channel.

I am working on building an internal reporting tool for our organization. Our main goal is to build a dashboard for few application metrics. Not too fancy, just something that can be easily understandable by the end user.

Our input data will be numerous json structure data collected after making the api calls. We have some idea how we would like our end product to be. To store the data, we have two options – use Elasticsearch Stack, get the data – store in elastic search – index – logstash – build dashboard on kibana/grafana. Second option, store data in a relational db – index – use superset to build dashboard. Data is not too important, if we loose some data, we can make an api call and collect the lost data. We are mostly looking to use free/open source tools in the process.

I know noSql is a natural choice if we want to store json. But I am not sure if that fits the purpose here. Does anyone has an idea what can be a better approach to move forward.