Scribd
Upload
27 views3 pages

Amazon Prime Dataset Analysis Guide

The document outlines a step-by-step process for analyzing the Amazon Prime dataset using Power BI. It includes steps for uploading the dataset, cleaning and transforming the data, and creating various visualizations such as donut charts, area charts, and maps. Additionally, it provides guidance on building an interactive dashboard with formatting suggestions.

Uploaded by

UNNATI SAXENA
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
27 views3 pages

Amazon Prime Dataset Analysis Guide

The document outlines a step-by-step process for analyzing the Amazon Prime dataset using Power BI. It includes steps for uploading the dataset, cleaning and transforming the data, and creating various visualizations such as donut charts, area charts, and maps. Additionally, it provides guidance on building an interactive dashboard with formatting suggestions.

Uploaded by

UNNATI SAXENA
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Simplified Step-by-Step Process for the Experiment: Analysis of Amazon

Prime Dataset
Step 1: Upload the Dataset

● Open Power BI → Click Get Data → Excel → Select


Amazon_Prime_Dataset.xlsx.

● Load the data into Power BI.

Step 2: Data Cleaning & Transformation

● Go to Power Query Editor.

● Remove null or blank rows (Home → Remove Rows → Remove Blank Rows).

● Remove unnecessary columns (like Duration if not needed).

● Click Close & Apply.

Step 3: Visualizations
(i) Donut Chart – Percentage of Movies vs TV Shows

1. Select the Donut Chart visual.

2. Drag Type → Legend.

3. Drag Title → Values (Aggregation: Count).

4. Format labels to show percentage.

(ii) Area Chart – Content by Release Year and Type

1. Select Area Chart visual.

2. Drag Release Year → Axis.

3. Drag Type → Legend.

4. Drag Title → Values (Aggregation: Count).


5. This shows trends of movies and TV shows over the years.

(iii) Horizontal Bar Chart – Top 10 Genres

1. Select Stacked Bar Chart.

2. Drag Genre → Y-axis.

3. Drag Title → X-axis (Count).

4. In the filter pane, apply Top N filter → Top 10 by Count of Title.

(iv) Map – Total Shows by Country

1. Select Filled Map visual.

2. Drag Country → Location.

3. Drag Title → Values (Count).

4. The map now highlights which countries produce more shows.

(v) Text Table – Movie Descriptions

1. Select Table visual.

2. Drag Title and Description into the table.

3. Add a Slicer with Title so users can search and view specific movie descriptions.

(vi) Build an Interactive Dashboard

● Arrange all visuals neatly:

○ Donut chart on top.

○ Area chart and bar chart in the middle.


○ Map and text table below.

● Add slicers for Country, Genre, or Year to make it interactive.

● Format background color to light gray or gradient blue for a professional look.

You might also like