Data Analysis on AWS- Glue, Athena, Quicksight

Data Analysis on AWS- Glue, Athena, Quicksight

Data Analysis on AWS- Glue, Athena, Quicksight

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

Language: english

Note: 3.8/5 (28 notes) 2,185 students

Instructor(s): Harshit Srivastava

Last update: 2021-12-21

What you’ll 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

 

Requirements

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

 

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 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.

 

Who this course is for

  • 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

 

Course content

  • Introduction
    • Introduction
  • Creating a S3 bucket
    • Create a S3 bucket and add dataset
  • Setting up AWS Glue crawler
    • Create a Crawler using AWS Glue
    • Configuring output database name for crawler
    • Customize Schema, find table details in Glue and Log groups in Cloud Watch
  • Performing SQL queries using AWS Athena
    • Run SQL Queries on Athena and store output in S3 bucket
    • Create and Save Custom Query in AWS Athena
  • AWS Quicksight
    • Getting Started with Quicksight
    • Importing dataset and understanding group and values
    • Creating Treemap and Customizing charts
  • Data Preparation
    • Data Preparation- Editing Dataset before creating Charts
    • Create a Calculated Field using Functions- ceil and concat
    • More calculated fields
    • Creating Filters and Excluded list
  • Data Visualization
    • Map Chart and Conditional Formatting
    • Pivot table
    • Word Cloud
    • Funnel chart

 

Data Analysis on AWS- Glue, Athena, QuicksightData Analysis on AWS- Glue, Athena, Quicksight

 

Don’t miss any coupons by joining our Telegram group 

Udemy Coupon Code 100% off | Udemy Free Course | Udemy offer | Course with certificate