Data Prep with AWS QuickSight

Only in rare occasions, your data will be ready to visualize right out of the box. But don't worry, in QuickSight you can perform most of the transformations you'll need. It provides a very simple yet powerful interface to make your dirty data cleaner, better, and ready to turn into amazing Dashboards.
Find the resources here:
Covid-19 data: ourworldindata.org/coronaviru...
Coordinates by Country: gist.github.com/tadast/8827699
Do you want to be a Data hero with Quicksight?. Check our Hands-on Course on Udemy:
www.udemy.com/course/the-comp...

[@hanychurchman6482]

Amazing!!! Very good! Thanks for sharing

[@jorgeluiscuba8648]

Always useful, thanks 🙏🏼

[@ezhankhan1035]

Thanks for this Video! As a Tableau user primarily, noticed a lot of nice similarities here!

[@eniermolinaramirez6048]

very good video. !!! this is de way !!!

[@gemab.110]

Cool!

[@deepakbirar1203]

very nice video How to connect local file to quicksight and to update quciksight dataset real time or periodically? can you please make explanatory video on this

[@rusdxb]

Thank you for video. I have a question : When excluding fields and lets say it's athena as a datasource , does it mean it will not send a query to athena for those columns , and it is more optimized to do so ? So it will be faster and cheaper in general.

[@nisraeli]

Where can I get the consolidated file with the latitude and altitude from ?

[@wetubewithpablo]

hi, great reasoning. I too had a question, I need to append 2 different data sources, first, sales data of tier 1 cities from SQL database & and sales data of tier 2,3 cities from Excel. Doing “add data” only gets me to join other datasets but I am unable to find a way to append data sources. Columns & data types are identical in both data sources.

[@datadoozers296]

Hi, @Abhishek Mani Thanks for your question. I'm not sure if I fully understood your question, but you probably can do a Cross Data Source Joint. If you are interested in mastering your Quicksight Skills, you may consider taking a look at the Hands-on Couse we just release on Udemy with the latest features. www.udemy.com/course/the-complete-quicksight-course-2022-from-zero-to-expert/?referralCode=9EEBD96B7479D7C192E2

[@ashokkumar-lq3hz]

how do you do vlookups in quicksight ?

[@abhishekmani5030]

Thanks for the video, I have a question- I have a invoice table and a contact table which have contacts for those invoices in case I want to follow up. Contact table have multiple contacts associated with one invoice. Now when I am joining the data it’s creating the duplicate rows which is messing up the numbers. How to deal with it.

[@oleksandryatsenko5245]

I believe in that case it's need to use grouping by invoice, if you want to use any or all of contacts related to single invoice. It looks like there is special group of fields in analyze, for adding named "group by". But I think that QuickSight should resolve this case correctly and you will get invoice data in rows and and all the contacts as values. But at the level of data set there will be duplication of course, as a result of joining, where each rows of contacts will be associated with the same invoice, according to relation.

[@wetubewithpablo]

@@oleksandryatsenko5245 hi, great reasoning. I too had a question, I need to append 2 different data sources, first, sales data of tier 1 cities from SQL database & and sales data of tier 2,3 cities from Excel. Doing “add data” only gets me to join other datasets but I am unable to find a way to append data sources. Columns & data types are identical in both data sources.

[@MeenaSivan]

audio quality is bad - its fading in and out