Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Data Analysis on AWS- Glue, Athena, Quicksight

person icon Harshit Srivastava

4.2

Data Analysis on AWS- Glue, Athena, Quicksight

Learn to create Glue Crawler, run SQL queries in Athena and create Visualization Charts using AWS Quicksight

updated on icon Updated on Jun, 2025

language icon Language - English

person icon Harshit Srivastava

English [CC]

category icon Development ,Data Science,Data Analysis

Lectures -22

Duration -1.5 hours

Lifetime Access

4.2

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

In this course, you would learn about various cloud services on Amazon Web Services or AWS Cloud computing platform. Here, you will learn to perform Data Analysis on a dataset to find various insights that can be used in making critical decisions based on the data. There are various methods for Data Analysis. You can write SQL queries to find relevant information from a dataset stored in a database. You could also use Business Intelligence tools such as AWS Quicksight to create Visualization charts and Analytics reports that can also be used to present insights in visually appealing ways using colorful charts with creative parameters.

In this course, you will be learning various AWS Analytics services, as below-

  • AWS Glue

  • Amazon Athena

  • AWS Quicksight

There are various steps involved, from data preparation and cleaning to analysis and visualization. Here in this course, you will learn to create a Crawler using AWS Glue that can span through the dataset kept in Amazon S3 or DynamoDB and detect the schema. This crawler could be used to create a database where you can run SQL queries using AWS Athena to find insights based on certain conditions and parameters defined. You could also customize records in a table using SQL queries and perform other operations as well. SQL is a Structured Query Language that is widely used for Data Analysis on databases, and we can use the same on the AWS cloud computing platform.

Moreover, you will also learn to create visualization charts and BI reports using AWS Quicksight. You will learn to create various kinds of Visualization charts in Quicksight, such as Treemap, word clouds, bar, pie charts, and much more. You would also learn to prepare your dataset before creating Visualization charts.

All these skills, when combined together can be used for Data Science projects as well.

Goals

  • You could create a Crawler using AWS Glue to create a dataset and find its schema
  • You could perform data analysis on a dataset by running SQL queries in AWS Athena
  • You could Prepare your dataset for finding Insights in AWS Quicksight
  • You could create Visualization Charts and BI reports in AWS Quicksight and find Insights

Prerequisites

If you are already familiar with the AWS cloud computing platform, it would be helpful.

Data Analysis on AWS- Glue, Athena, Quicksight

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction

1 Lectures
  • play icon Introduction 01:40 01:40

Creating a S3 bucket

1 Lectures
Tutorialspoint

Setting up AWS Glue crawler

3 Lectures
Tutorialspoint

Performing SQL queries using AWS Athena

2 Lectures
Tutorialspoint

AWS Quicksight

3 Lectures
Tutorialspoint

Data Preparation

4 Lectures
Tutorialspoint

Data Visualization

4 Lectures
Tutorialspoint

Advanced Chart

4 Lectures
Tutorialspoint

Instructor Details

Harshit Srivastava

Harshit Srivastava

I am Self-Taught developer who had worked on various platforms using varied languages, and involved in various Projects both Open Source and Proprietary.

I have developed Web and Android Applications, chrome Extension, worked on various frameworks, fixed bugs for some projects, and explored numerous others. I think education and learning should be free and open, not be bound with restrictions like attending classes or going to college, People from all age groups, gender, faith, race, nations, etc must get equal privilege. When entire world would act this way like being a single FAMILY, we would truly realize VALUE of Knowledge and Human Life.

Currently I am teaching more than 152,000 students from 189 countries across the world.

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515