How to build Covid 19 Dashboard in Kibana using elasticsearch and logstash

This video demonstrate how to build Covid 19 Dashboard in Kibana using elasticsearch and logstash.
This video use data from European Centre for Disease Prevention and Control.

[@somejohndoe3004]

Good comments, good sound quality, easy to follow tutorial. Nice work !

[@cloudykube8268]

I am glad you liked it. thanks

[@biswajitsingh8790]

Hey man ! Great vid on how to get started with kibana. I have a question here though. Suppose if i want real time updates on my dashboard how can we make that possible since in this example lets say the covid cases will vary every day so is there any way to project real time updates to the dashboard ?

[@cloudykube8268]

Hi Biswajit, I am glad you liked it. Apologies for responding so late. To get the real time update all you need to do is to find the proper source/input. for e.g. you may get the csv file updated using any scripts etc. (Very similar to how application logs are appended). or you can have it exactly like a log file where an app/program writes the updates for each country/city etc. once you configure the logstash input, it will keep sending the updates to elasticsearch and you will have the real time data updated in kibana dashboard. you can set the refresh time for dashboard as per your need. If you still need help, you can write me an email [e-mail]

[@venr9763]

Hi great video... when a new field is added to the existing index (see a new modelID appeared), auto-create those fields to existing dashboard/visualization or create new one to match the fields in the log, pick up new fields when they appear. What is the ideal solution for this scenario... Please help me

[@cloudykube8268]

Thank you, first of all to add a new field to an existing index, ideal way is to use PUT api. For visualization it really depends how u want to display/map a particular field value. Usually in a visualization u map and apply aggregation on one or more particular field so in that case u will hv to update the visualization manually.

[@onshammouda1976]

how created file covid_logsasth plz

[@rupalmukhi1254]

When you ran the logstash with the config file, how it starts pushing the data to kibana? Could you please explain? Do I have to do some linking between the logstash and Kibana on my end for the same?

[@cloudykube8268]

Hi, logstash start pushing the data to elasticsearch and elastic search creates the index defined in logstash config file. Kibana uses elasticsearch index to show the data in UI. You can watch my other video where I have explained how to setup elasticsearch and logstash.

[@rupalmukhi1254]

hey! Thank you for the quick response´. I will watch other videos as well. One more question, what if I do not have Ubuntu terminal with me? Can I run the same in SecureCRT?

[@cloudykube8268]

ELK stack works fine on windows as well. Its just a different installation steps. If you have remote ubuntu VM and u use securecrt to connect to it then it will be same as per my instruction.

[@cloudykube8268]

@@rupalmukhi1254 You can post your query to [e-mail]

[@Caraculop1]

Hi! i would love to do it the way you did but its just no working (i think because ubuntu) is there a chance you can help me? thanks!!

[@cloudykube8268]

Lola Delgado Sure, let me know the details, I will try to ans.

[@umahmuslimah]

Hello, can you help me? I don't know how to automaticly get the data log from a web into elk, my web using Apache.. my lecture told me to use script but i don't know

[@cloudykube8268]

Hi, Sure I can help you with that. Please drop an email to [e-mail] and I will explain how to ingest the data automatically.