Build an End-to-End AWS Project with QuickSight, DynamoDB, Athena, S3 & IAM | Hands-on Tutorial

The first 500 people to use my link https://skl.sh/tinytechnicaltutorials02251 will get a 1 month free trial of Skillshare!

This video is sponsored by Skillshare.

In this hands-on tutorial, I’ll walk you through how to use QuickSight to visualize data coming from a NoSQL database (DynamoDB).

I start by showing you how to sign up for QuickSight if you don’t already have an account. From there, I show you how to set up a DynamoDB table and add task items to it (JSON code provided). Then we connect Athena and DynamoDB via a Lambda connector, and configure appropriate permissions for QuickSight. Finally, we build out various data visualizations in QuickSight, pulling from the DynamoDB table via Athena.

IMPORTANT: Be sure to stick around to the end where I’ll show you how to delete your resources.

🌟***LINKS REFERENCED IN THIS VIDEO***🌟
• GitHub repository with code for DynamoDB items and IAM policies: https://github.com/tinytechnicaltutorials/quicksight-dynamodb
• DynamoDB basics: https://youtu.be/FQrN5aJWa_U
• Athena basics: https://youtu.be/Wkpl66NaqEA
• IAM basics: https://youtu.be/hAk-7ImN6iM

🌟***TIMESTAMPS***🌟
00:00 – Previewing the completed visualizations in Amazon QuickSight
00:29 – How much will this cost?
02:06 – What you need to follow along with the hands-on tutorial
02:29 – How to create a QuickSight account or subscription
04:08 – High-level diagram of what we’re building in this tutorial
04:26 – Creating a new DynamoDB table
04:49 – Setting the partition key and sort key in the DynamoDB table
05:31 – Adding new items to the DynamoDB table using JSON code
07:26 – Exploring options available for connecting to DynamoDB from QuickSight
08:31 – Introducing the Lambda Athena DynamoDB Connector
09:19 – How does AWS Glue fit into the Athena DynamoDB Connector?
09:37 – Setting up a new data source in Athena that uses the Lambda DynamoDB Connector
10:22 – What is a spill location in Amazon S3 when working with Athena and Lambda?
11:06 – Creating an S3 bucket as the spill location for Athena query results
12:13 – Testing that we can query the DynamoDB table from Athena
12:59 – Configuring the S3 location for Athena query results
13:51 – Why QuickSight needs additional permissions on Lambda and S3
14:42 - Updating IAM role policy permissions for QuickSight to invoke a Lambda function and access the S3 spill location
18:40 – Adding a new dataset from QuickSight, pulling from Athena
19:41 – Importing to SPICE or directly querying data
20:39 – Creating a donut chart data visualization in QuickSight to show task completion status
24:53 – Creating a horizontal bar chart visualization in QuickSight to show tasks by category
25:58 – Rearranging tiles on an interactive sheet in QuickSight
26:38 – Creating a table in QuickSight to show a list of tasks
28:11 – Adding a new task in DynamoDB and refreshing the data in QuickSight
29:53 – The final architecture diagram of what you build—nice!
30:17 – IMPORTANT!! Delete your resources