What it does & how it’s useful ?

Amazon QuickSight lets you create interactive dashboards and visualize data from different sources. It's useful for spotting trends, making informed decisions, and sharing insights with your team quickly and easily.

Amazon QuickSight offers several advantages:

1. Ease of Use: Intuitive interface for quick data visualization.

2. Scalability: Handles large datasets effortlessly.

3. Integration: Works seamlessly with other AWS services.

4. Collaboration: Share insights and dashboards easily.

5. Cost-Effective: Pay-per-session pricing model.

Download the dataset

1. Download netflix_titles.csv (right click, and select Save Link As). This file contains all the data we're analysing!

2. Download manifest.json (right click, and select Save Link As).

Store Dataset in Amazon S3

1. Open Amazon S3 console.

2. Select Create Bucket.

3. Name the bucket network-quicksight-project.

   

4. Keep rest of the setting as default and select create bucket.

5. Upload the CSV file and manifest.json file into bucket.

   

6. Copy the S3 URL of your netfilx_titles.csv file.

   

7. Now open the manifest file in text editor in your PC and Replace the URL in the file with the S3 URL of your dataset and Re-Upoad the manifest.json file into bucket and delete the old one.

   

Create a QUICKSIGHT Account

1. Search for Amazon Quicksight

2. Select Sign up for QUICKSIGHT

3. Enter your details for your QuickSight account - make sure the email you use is the same email for your AWS account.

4. Select Amazon S3

5. Select S3 Bucket.

6. Tick box the S3 Bucket you created earlier.

🚨 IMPORTANT STEP 🚨

Make sure you uncheck this Box

7. Select Finish (It will take some time).

8. After creating account select Go to Quicksight and you will get like this homepage.

   

Connect your S3 bucket to Amazon QuickSight

1. On left hand navigation bar select datasets and Click New datasets.

2. Then Select S3

3. Now earlier we had a file named manifest.json ,here we will use this file.

4. Open a new tab and go to AWS Console and go to S3.

5. Select the manifest.json and Copy the S3 URL

6. Now again go to AWS QUICKSIGHT.

7. In that now As you select S3 you will get a pop up "New S3 Data Source".

   Note: The source name is a label to remind you where the data came from.

8. Now in data source name write kaggle-data and in URL paste the S3 URL which we had copied earlier [manifest.json]

What is role of manifest file here ?

"The manifest.json file tells Amazon QuickSight where your data is and how to read it. It acts like a map, helping QuickSight understand and correctly display your data in charts and graphs. Without it, QuickSight might not interpret your data properly."

9. Select connect.

10. Select Visualize.

11. Select Create.

12. Select Interactive Sheet.

Create Your First QuickSight Visualisation

1. On left side you will see that the dataset are imported.

2. Drag fields in Visuals and select the visual you want to see example Donut , bar graph , Histogram, Pie etc.

3. Now time to Publish for that create Sheet 2 from sheet one make a duplicate to sheet 2 by clicking 3 dots at right corner of your visual and one by one do same to one visuals aslo and at end you will get result like this -->

4. Click Publish

5. After Clicking Publish give your dashboard a name which will be public so you can share. [Netflix analysis].

6. Click publish dashboard

7. Now click export at right corner of your page.

8. Click Generate pdf.

   It will create a pdf file which will be available on your PC as a copy of your file.

Hurrah! We've completed the project. Using the manifest.json file ensures that Amazon QuickSight can accurately understand and visualize your data, making your insights clear and impactful. Happy analyzing!

Got any queries, ideas, or need help? Drop a comment below!.