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

Video Description

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