Building a dynamic Dashboard using AWS QuickSight

Whether you're new to Quicksight or have some experience using it, this video is for you. Use these public datasets to create a stunning Dashboard to analyze Covid-19 Data.
Find the resources here:
Covid-19 data: ourworldindata.org/coronaviru...
Coordinates by Country: gist.github.com/tadast/8827699
*You will need to join these data sources and perform some simple transformations to match the dataset we used in this video. Check this video in the Data Doozers channel to learn about it: • Data Prep with AWS Qui...
Do you want to be a Data hero with Quicksight?. Check our Hands-on Course on Udemy:
www.udemy.com/course/the-comp...

[@ezhankhan1035]

As someone who is primarily a Tableau user, this was incredibly helpful, informative and easy to follow. A fantastic way to practice all these skills - thank you both!

[@surbhirastogi5492]

Thank you for creating such a detailed video.

[@hanychurchman6482]

In love with this Dashboard, Pretty cool the Action with the links. thanks for sharing!.

[@billybobbain]

I have watched this twice and it is a great tutorial on Quicksight. Thank you!

[@spagopinath]

Very informative tutorial. Covered most of the functionality of Quicksight. Thanks a lot :)

[@CoNVertibleJay]

Best tutorial on QS. Great job and thank you!

[@richardaustin4480]

Brilliant, answered so many questions I had. Just hope I can remember the answers. Subscribed.

[@alejandromartindelcampo6468]

Great instructor, Suscribed! Thanks for all the info and good vibes :)

[@claudiabofill5234]

Great video! Very good professors.

[@zeniagarcia7945]

Very helpful video! Thanks for sharing ❤️

[@tracyhauser8753]

I am a business analyst for a training team at a tech company so I see a lot of training. This was so impressive and exactly what I needed. Just when I thought I knew everything there was to know about Quicksight, you taught me like 20 additional things! I can't wait to start revamping my dashboards to be more dynamic. Thanks again!

[@datadoozers296]

Thanks for your comment, Tracy. We're glad to help!

[@emmanueldiaz6378]

Great video, very detailed!!👍

[@soumyashalini6070]

Thanks for this effort. Highly informative

[@maisamali3087]

beautifully explain great job.... thank you so much I had a data analyst interview the company give me a task to make a dashboard and this video helped me a lot

[@datadoozers296]

Great to heard that!! Thanks for your feedback!.

[@kookybadger156]

The location now works for other countries. Thanks for your videos, watched a few now and they're really helping with getting to grips with QuickSight.

[@datadoozers296]

Nice! Thanks for letting us know!

[@swatiyadav9588]

Great Video!

[@PGariano]

This video is great and very informative! I've used other visualisation tools before but was struggling to find a good tutorial on how to do things in QuickSight. This video explained how to do everything I was struggling to get information on. The only improvement I can suggest is the audio. There is a slight high pitched buzz in the background.

[@datadoozers296]

Thanks for your feedback! We will work on it!

[@wandacontreras9567]

Great video 👏🏻

[@surfjah9980]

very good, the man knows

[@jorgeluiscuba8648]

excellent 👏👏👏

[@diegorsaraiva]

Very useful, thanks a lot for sharing.

[@datadoozers296]

Glad it was helpful!

[@Patrick-hl1wp]

awesome tutorial 👍

[@hamletespinosasantos7908]

excellent

[@jatinnandwani6678]

Thanks so much

[@sergiorubiano3878]

Gracias!!!!!!

[@lehandro69]

Great vid

[@Dr.Farewell]

Thank you for the video tutorial, do you know if you are able to use the map graph by just using addresses in the US?

[@chotuvohra1808]

This is a very informative video. I just needed one help. I wanted to know how to automatically change the format of the metric i select when i use the metric to display parameter. For Example if i select a metric which has a percentage format i want the number to display as a percent instead of a whole number like total cases. Is there any way to do that

[@arsalanahmed8353]

It would be useful if you guys provided the dataset you used.

[@moemihagiyama7111]

Very helpful video!! I have 2 questions though.... Is there any way to set dynamic title based on the value filtered by action filter? Also, when we use an action filter for the map, it deactivates unselected locations instead of hiding. Can we show same way when we select one location from the control?

[@datadoozers296]

Hi Moemi. Those are two very good questions. We don't know a way to set up dynamic titles for the visuals targeted in a Filter Action. For dynamic Titles you need to hold the 'dynamic' value in a Parameter, and in this particular scenario the Filter action is triggered from a Dimension instead. Check this video, if you haven't, about Dynamic Titles and Tooltips kzbin.info/www/bejne/Y3-bqpJ8frGFaNk and if you come up with a solution then please share. What you could do as a workaround is creating a Word Cloud visual with the Dimensions that you want to control dynamically, and filter that by the Filter Action, sort of like we did in the Vaccination sheet with the Country Name (see more details here: kzbin.info/www/bejne/foLIo32eg5qrmbM) Also, we don't think that it is possible to 'highlight' the Dimensions filtered by a Control, unfortunately that's not the way in which regular filters work in Quicksight. Thanks for your questions!

[@moemihagiyama7111]

@@datadoozers296 Thank you for the reply! I haven't figure it out the way but I checked your other videos and loved them!! Thank you for making informative videos :) I will let you know if I can figure it out my problem in the future.....

[@dianacerecero5577]

Great Job! I just have a question, if I want a one filter from country and then another filter that depends of the first for example I select the continent Asia and then in the second filter I want to see only the countries from Asia it is possible?

[@ambhat3953]

yeah possible as long as they are not a calculated field

[@PushpendraSingh-yp6xl]

Hi, in visual type table I have more then 60 data fields , I just want to fixed initial five dimension data fields , so when I see other measure fields , my first five data fields should be fixed. Please help on this.

[@siddhishah6809]

How to display last refresh date/time on dashboard so that the user who has view access can see it?? Right now only owner can see date and time on dashboard.

[@MegaLobo000]

Hola excelente video. Disculpa te consulto porque tengo 2 cuentas diferentes de Quicksigth, pero no se como puedo unificar los análisis en uno solo. Saludos

[@datadoozers296]

Hola Jesus. Si tienes dos cuentas diferentes, no creo que exista una solución 'sencilla' para unificar todo en una de las cuentas. Puedes revisar esta documentación, tal vez funcione en tu caso: aws.amazon.com/premiumsupport/knowledge-center/quicksight-cross-account-template/ Déjanos saber si esto ayuda a solucionar tu problema. Gracias!

[@abrahamgomez653]

Looks like AWS serviced for Big Data and Analytics

[@scarlet73]

How do we hide cols based on cell values

[@user-qf7fb5by1n]

In metric to display calculation field, Is total cases per million automatically suggested?

[@gwrp9820]

my latitude and longitude are not being recognized as geocodes hence i cant plot it on map, do you have any idea how to resolve that?

[@yingzeli8422]

the resources are free to load？

[@user-tn1rs4pu4p]

can we hide tabs but use them when we try to navigate from one tab to another ?

[@pallavishirolkar5564]

Please help me to find this dataset

[@priyankakurkure7417]

When are you guys going to provide the data set you used in this video?

[@datadoozers296]

Hi Priyanka. A link to the dataset is provided in the Description of this video. Thanks for your comment!

[@priyankakurkure7417]

@@datadoozers296 Hi guys, I am asking related about the 'covid-data-with-geocodes' dataset, have you guys posted that as well or is there going to be a video on the Tableau prep you did on the 'owid-covid-data' and 'countries_codes_and_coordinates.csv'.

[@datadoozers296]

Working on it... We're trying to put together something that everyone can automate for free and adapt to their environment regardless of the BI tool(s) they invested on. Stay tuned!

[@nisraeli]

@@datadoozers296 any updated on it ?

[@waleedabujaish4635]

shame on you

[@zaffer2024]

wasted my time. NOt useful if you are Indian.

[@karelbofill3302]

How exactly is this not useful for Indian people?