Build Advanced Analytics and Dashboards with Amazon QuickSight - Virtual Workshop

As of January 2024, this content has been updated and can be accessed here: community.amaz...
If you are new to QuickSight or someone looking to build advanced calculations in QuickSight, this workshop is for you. It will provide step by step instructions to grow your dashboard building skills from basic to advanced level. You will learn how to setup QuickSight in your AWS account, import and prepare data, and build advanced visuals to analyze data in a meaningful way. The session requires an Enterprise author account and leverages a data file available here. learnquicksigh...
Content link: www.kaggle.com...

[@ambhat3953]

Basic Features 11:50 Create Dataset 15:20 Filter at datatable level 17:55 Row level security 19:40 Switch Datasource/Join Datasource 22:55 Calculated field (constant) 27:05 Start visualisation (line graph) 33:05 Add forecast 36:15 Bar graph 36:35 Donut Chart 38:55 KPI Chart 45:15 Filter Date 47:05 Add reference line/constant line 49:35 Create a table 51:30 Conditional Formatting 53:50 Conditional Formatting (With Icon) 56:45 Auto-Insights (Quicksight generated insights) 58:05 Add/Edit auto-insights to dashboard 1:03:00 Text insight 1:06:36 Adding interactivity (action filters) 1:09:00 URL actions 1:11:05 Parameters 1:17:25 Adding icons/emoticons 1:18:35 Themes/Fonts/Custom Colour 1:25:15 Publish and Share 1:28:15 Export to CSV/xls ------------------- More features 1:31:40 Parameters revisited 1:35:00 Calculated fields (ifelse) 1:39:30 Add drill down option 1:41:20 Calculated fields (dateDiff) 1:44:45 Filter revisited (Slider) 1:50:05 Anomaly detection 1:58:10 Email the report 2:00:40 Anomaly detection (Revisited) 2:03:10 Table Calculation (Pivot table, Table Rank) 2:10:30 Table Calculation (Percentage) 2:13:00 Calculated Fields (runningSum) 2:19:20 Calculated Fields (truncDate) 2:21:10 Level Aware Aggregations (PRE_AGG) 2:32:45 Level Aware Aggregations (PRE_FILTER) 2:33:50 Calculated Fields (percentOfTotal)

[@Mrotromasnuevo]

This is the most helpful comment.

[@kevalpatel163]

Appreciated

[@jonathandelossantos9332]

Doing the lord’s work. Or Amazon’s I suppose.

[@khushboomohitnahar7531]

It would be a jargon for me if heard somewhere else, But here you have explained so systematically and in a simple manner. Very well presented by Sapna Maheshwari 👏🏻👏🏻😊😊

[@sagnikmukherjee5108]

Thanks so much for such an awesome workshop. It perfectly shows the capabilities in Quicksight.

[@benrandom742]

Super helpful! Thank you very much for uploading this workshop!

[@abdulfazul]

A very logical and systematic presentation of the QuickSight Functionality. Use of the provided Patient-Info was helpful in following the creation of each visual. I would strongly recommend this Workshop to anyone who want to understand the feature of QuickSight, especially by creating their own visuals.

[@Sid2harth]

Made Level Aware Aggregations quite intuitive for me. Thanks so much Sapna! Appreciate the clarity.

[@iivector8994]

wow this is amazing, sapna maheshwari is great

[@DigsWigs2022]

Absolute best. Thank you.

[@deepakkumarnaik3567]

Awesome!!!!!

[@estebanarroyave3033]

Hello! I've a question. On 1:41:20 is to created a table, which contain a Page size button. How I can to insert it to my tables? Ty for answer.

[@rishi.girdhar]

Very good session, covered lot of ground. How can I integrate the Dashboard with a SaaS web application where a customer can see/interact with only their data?

[@habibgohar]

Hi, Great Video! Can anyone please advise if QuickSight supports or enables the user to 1) Free Text Search 2) Modify the x/y Axis in graphs / charts 3) Link or drill down to external applications 4) View the dashboard / data while load or refresh is running 5) View log file and Troubleshoot error (for Developers only) Your earliest response will be highly appreciated. Thanks

[@ahmedameen5387]

I have this error when try to access the link : This XML file does not appear to have any style information associated with it. The document tree is shown below. any one can help ?

[@sapnavishal]

Link updated in the description box

[@shamstabrez2986]

content is very gd no doubt but plz improve sound quality

[@kirthikka952]

I am not able to see "analyse contributions to revenue" is it not visible in my version?

[@mdshoyeb8924]

Suppose I added few calculated columns in my Development data set, now if I want to make sure the same calculated columns are added on my production dataset. Do I need to do the steps 2 times in both my dataset?? Is there any option to change the source server and db, so that that calculated columns are just copied when I change the source from dev to prod. Can you help?

[@mistisparadise369]

What are the formats Dashboard/Analyses can be downloaded in Quicksight .Can we download the entire dashboard in PDF format along with scrolling data if there is tabular data

[@purushothambv]

Hi Can we have new Dataset link , Old one here is not working .

[@arpchakra5840]

When I click share, I can't see any names from my organization...how to solve it?

[@alexei6557]

Hello, I need to make different access rights for different categories of people. For example, there's a general director who should have access to all visualizations and several different regional directors who should have access to only the region they manage. Accounts should be protected by login and password credentials. Is Quicksight the right tool for that? Many thanks for your help.

[@ashybaby4549]

It's Row level security. Refer video at 17.55

[@urmishapothiwala4666]

Can i add custom shapes as in Tableau? To create picto-graphs

[@silpadas6840]

can we do radio buttons ?

[@poswalcreations]

can you send the link for this patient dataset, so that we can follow along.

[@sapnavishal]

Link updated in the description box

[@yasink18]

Can I use layout for mobile?

[@banji007]

How can I download the data set. Is it available ?

[@funkyguy2208]

download from learnquicksight.workshop.aws/en/business-level-up/exercises/operationalize-quicksight-analysis.html

[@robertl9269]

Wow turn off your notifications during a recording... so distracting how do you not do this before you start

[@priyamoroliya7442]

can't see that dataset download link. can you send it again

[@sapnavishal]

Link updated in the description box

[@priyamoroliya7442]

Thank you 👍🏻

[@andrewhallinson9923]

Download file no longer works :(

[@sapnavishal]

Link updated in the description box