I have been trying to create Grafana dashboard for visualization and I have been using Excel for data analysis. I figured out it would be best for me to use “What-if-analysis” in Excel to answer my project question but for that I need to show analysis on live data or else it would not make much sense for me to present analysis of the outdated data. I am not sure if its possible but I really want to embed live data into excel sheet to get the most recent data points the way we get in Grafana.
I have access to the two datasets I have been working on through Kibana as well as through Grafana. I could get some data in csv format from Kibana but I want to live stream that data from Kibana into Excel.
I would really appreciate any guidance on this as soon as possible.