Video 5.5 visualizing the sensor data using Amazon quick site. In this video, we learn the following importing data into spice, visualizing the data. I hope everyone is ready with your Amazon quick site account. So come let's start with importing our sensor data from Athena. Let's open up now before getting started. Open Athena, we'll run the query again.

Yes, this is the data that must be imported into quick site for analysis. Let's get back to Amazon quick site. Here on the left hand side select new analysis. Since we don't have a data set in quick sight, let's create a new data set. Select new data set here. As I have already mentioned that we will pull the data from Atlanta so here select Atlanta.

If you're taking data from s3, you can select this I will select enter enter any data source name I will give my ESP 32 underscore data sets, then we will check if the connection is valid or not. Select validate connection. Yes validated, and then select Create data source, the data source is created. Now, we need to choose the database from which our sensor data must be extracted. Choose the database that you created while making the glue table. My sp 32 underscore database.

It automatically shows you the table from which you can analyze your sensor data selected here by choosing Edit or preview data. You can see the data and also edit the data. Yes, this is the data that is exported from ethanol to spice. I don't want to edit my data. So here on the top, I will select Save and visualize. Yeah, we're almost done.

Here on the left hand side you can see the field list These are different types of inbuilt graph models. You can also create your own visual types here. Now, I'll select this type of visual in Quick Set, you can just drag drop and visualize the data. I want my temperature and humidity versus time graph. So, I will drag and drop humidity and temperature. Next I will drop the timestamp.

So it plotted the sum of humidity and temperature with respect to time. You can change the aggregates here. Okay, did you understand what this Some are averages, we have a lot of data collected, but we are plotting only a few values. So some indicates the sum of all the values in between two plotted intervals. Now, we can select other visual types here, like this. You can also personalize these graphs by changing colors, select and then here you can change colors similarly selected by And here you can see the exact average values of temperature at that point.

Now, try out different ways to personalize your own visual types. I'm ending this video here. In this video, we learned the following importing data into space visualizing the data. Congratulations, we almost reached the end of the course. In this section, we learned the following introduction to Amazon s3. Getting started with Amazon kinases, creating delivery stream with kinases, firehose, learning Athena and getting started with Amazon quick site, visualizing the sensor data using Amazon quick site