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.
Create a new S3 bucket or select an existing one.
Upload the CSV file to the S3 bucket, ensuring proper access permissions are set.
Here both the file has been uploaded to our Bucket name (visualizedata-using-amazon-quicksightproject)
Now the the next step is copy the Bucket name and paste it on manifest.json
so the follwing update will appear in manifest.jason file.
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.
Now for sign up provide your gmail and also select S3 Bucket to allow access
Now select the Bucket you want Quick sight to be able to access
Now after creating account the following screen will appear
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
Now the next step is provide data-source name and provide the url of your manfiest.json file you have uploaded on Bucket
Now click on visualize to finish dataset creation
Now select the format interactive sheet and click on create
Now you can ready to do different visulaizations like in this case
So the first visualization we have do in this case on word cloud Best Amazon selling products brands
We can also compare the price of different selling brands
and in the last we can also compare with availability
After completing the project make sure you have terminate the Quick sight the following screen will appear after terminating your Quick sight account
Top comments (0)