Data Analysis on AWS- Glue, Athena, Quicksight

Data Analysis on AWS- Glue, Athena, Quicksight, available at $59.99, has an average rating of 3.4, with 21 lectures, 1 quizzes, based on 56 reviews, and has 3166 subscribers.

You will learn about You could create a Crawler using AWS Glue for creating 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 This course is ideal for individuals who are Anyone who is curious to learn Data Analysis on AWS Cloud or Students and IT professionals interested in learning AWS Glue, Athena and Quicksight or Anyone interested in learning Data Visualization and Data Preparation with AWS Quicksight or Interested in creating a Crawler in AWS Glue to create a dataset with schema or In running SQL queries using Amazon Athena It is particularly useful for Anyone who is curious to learn Data Analysis on AWS Cloud or Students and IT professionals interested in learning AWS Glue, Athena and Quicksight or Anyone interested in learning Data Visualization and Data Preparation with AWS Quicksight or Interested in creating a Crawler in AWS Glue to create a dataset with schema or In running SQL queries using Amazon Athena.

Enroll now: Data Analysis on AWS- Glue, Athena, Quicksight

Summary

Title: Data Analysis on AWS- Glue, Athena, Quicksight

Price: $59.99

Average Rating: 3.4

Number of Lectures: 21

Number of Quizzes: 1

Number of Published Lectures: 21

Number of Published Quizzes: 1

Number of Curriculum Items: 22

Number of Published Curriculum Objects: 22

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

You could create a Crawler using AWS Glue for creating 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

Who Should Attend

Anyone who is curious to learn Data Analysis on AWS Cloud
Students and IT professionals interested in learning AWS Glue, Athena and Quicksight
Anyone interested in learning Data Visualization and Data Preparation with AWS Quicksight
Interested in creating a Crawler in AWS Glue to create a dataset with schema
In running SQL queries using Amazon Athena

Target Audiences

Anyone who is curious to learn Data Analysis on AWS Cloud
Students and IT professionals interested in learning AWS Glue, Athena and Quicksight
Anyone interested in learning Data Visualization and Data Preparation with AWS Quicksight
Interested in creating a Crawler in AWS Glue to create a dataset with schema
In running SQL queries using Amazon Athena

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 taking 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 report that can also be used to present insights in visually appealing way using colorful charts with creative parameters.

In this course you would 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 would 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 for finding 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 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 cloud, bar, pie chart 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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Resources

Chapter 2: Creating a S3 bucket

Lecture 1: Create a S3 bucket and add dataset

Chapter 3: Setting up AWS Glue crawler

Lecture 1: Create a Crawler using AWS Glue

Lecture 2: Configuring output database name for crawler

Lecture 3: Customize Schema, find table details in Glue and Log groups in Cloud Watch

Chapter 4: Performing SQL queries using AWS Athena

Lecture 1: Run SQL Queries on Athena and store output in S3 bucket

Lecture 2: Create and Save Custom Query in AWS Athena

Chapter 5: AWS Quicksight

Lecture 1: Getting Started with Quicksight

Lecture 2: Importing dataset and understanding group and values

Lecture 3: Creating Treemap and Customizing charts

Chapter 6: Data Preparation

Lecture 1: Data Preparation- Editing Dataset before creating Charts

Lecture 2: Create a Calculated Field using Functions- ceil and concat

Lecture 3: More calculated fields

Lecture 4: Creating Filters and Excluded list

Chapter 7: Data Visualization

Lecture 1: Map Chart and Conditional Formatting

Lecture 2: Pivot table

Lecture 3: Word Cloud

Lecture 4: Funnel chart

Chapter 8: Conditional Formatting

Lecture 1: more on Conditional formatting

Lecture 2: Adding Title description and creating Visuals for KPIs

Chapter 9: Practice Quiz

Instructors

Harshit Srivastava
Cloud Professional | Content Creator | Edupreneur

Rating Distribution

1 stars: 2 votes
2 stars: 4 votes
3 stars: 13 votes
4 stars: 18 votes
5 stars: 19 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu