DEV Community

Cover image for Visualize Data using Amazon Quick Sight
SAFI-ULLAH SAFEER
SAFI-ULLAH SAFEER

Posted on

Visualize Data using Amazon Quick Sight

In today's world of big data, it's crucial to use clear and effective visualizations to make smart decisions. Amazon Quick Sight, a tool from Amazon Web Services (AWS), helps turn complex data into easy-to-understand visual reports. This project explores how to use Amazon Quick Sight to analyze a large dataset of Amazon best sellers, demonstrating how AWS services can handle and make sense of large amounts of data.

The dataset, comprised of 50,000 records detailing Amazon's top-selling products, was initially sourced from Bright Data. This rich collection of information offers a snapshot of consumer preferences and market trends. To facilitate analysis, the dataset was first stored in an Amazon S3 bucket, a secure and scalable storage solution provided by AWS. Amazon Quick Sight was then employed to create interactive dashboards and visualizations, enabling a deeper understanding of the data.
Step-by-Step Procedure for Visualizing Data with Amazon Quick Sight:

Download and Prepare the Dataset:
**
Obtain the CSV dataset file from Bright Data, containing 50,000 Amazon best seller records.
Here is the link of Bright data:
https://docs.brightdata.com/introduction
Ensure the dataset is clean and formatted correctly for analysis.
**Upload the Dataset to Amazon S3:

Log in to the AWS Management Console.
Navigate to the Amazon S3 service.

Image description

Create a new S3 bucket or select an existing one.
Upload the CSV file to the S3 bucket, ensuring proper access permissions are set.

Image description

Here both the file has been uploaded to our Bucket name (visualizedata-using-amazon-quicksightproject)

Image description

Now the the next step is copy the Bucket name and paste it on manifest.json

Image description

Image description
so the follwing update will appear in manifest.jason file.

Image description

Now after setup S3 the next step is :

Set Up Amazon Quick Sight:

Access Amazon Quick Sight from the AWS Management Console.
Sign up or log in to your Quick Sight account.
Configure necessary permissions and settings for your Quick Sight environment.

Image description

Now for sign up provide your gmail and also select S3 Bucket to allow access

Image description

Now select the Bucket you want Quick sight to be able to access

Image description

Now after creating account the following screen will appear

Image description

Image description

Now the next step is:
Create a New Data Source in QuickSight:

In Quick Sight, go to the “Datasets” section and choose to create a new dataset.
Select “S3” as the data source.
Provide the S3 bucket path where your CSV file is stored.
Configure the dataset options, such as file format and delimiter, if require

Image description

Now the next step is provide data-source name and provide the url of your manfiest.json file you have uploaded on Bucket

Image description

Now click on visualize to finish dataset creation

Image description

Now select the format interactive sheet and click on create

Image description

Now you can ready to do different visulaizations like in this case

Image description

So the first visualization we have do in this case on word cloud Best Amazon selling products brands

Image description

We can also compare the price of different selling brands

Image description

and in the last we can also compare with availability

Image description

After completing the project make sure you have terminate the Quick sight the following screen will appear after terminating your Quick sight account

Image description

Top comments (0)