Transform Your Data with an Incredible Power BI Dashboard

Table of Contents

1. Introduction
2. Creating the Amazon Prime Video Dashboard
   1. Setting the Background
   2. Creating a Field Map for Total Titles by Country
   3. Creating the Donut Chart for Movies and TV Shows
   4. Creating the Area Chart for Total Movies and TV Shows by Release Year
   5. Creating the Horizontal Bar Chart for Ratings by Total Shows
   6. Creating the Horizontal Bar Chart for Genres by Total Shows
   7. Adding the Cards
   8. Customizing Each Card
3. Conclusion

Creating the Amazon Prime Video Dashboard

In this tutorial, we will be creating a dashboard for Amazon Prime Video using Power BI. The dashboard will include various visualizations such as bar charts, maps, donut charts, and cards. We will start by setting the background color and then move on to creating the different visualizations step-by-step.

Setting the Background

To set the background color of our report, we will go to the "Format" tab and select "Report" and then "Page". From there, we can choose the "Canvas background" option and select a custom color. In our case, we will use the color code #1922D2 with zero percent transparency.

Creating a Field Map for Total Titles by Country

The first visualization we will Create is a field map that shows the total number of titles by country. We will use the "Field Map" visualization and drag and drop the "Show ID" column into the tooltip. To count the distinct shows by country, we will select "Count Distinct" for the "Show ID" column and choose all countries. We will also remove any null values.

To format the field map, we will set the style to "Dark" and use conditional formatting for the fill colors. We will select the "Gradient" format style and choose "Show ID" as the count distinct value. For the highest value, we will use the color code #008AE1. This visualization will give us an overview of the countries with the highest number of titles.

Creating the Donut Chart for Movies and TV Shows

Next, we will create a donut chart to showcase the distribution of movies and TV shows. We will select the "Donut Chart" visualization and use the "Type" column as the category. We will also add the "Show ID" column as the value using the count distinct function.

To format the donut chart, we will set the title to "Movies and TV Shows" and Align it to the center. We will choose a white background and a border with rounded corners. We will also customize the colors for the movie and TV show slices using the color codes #00A8E1 and #008AE1, respectively.

Creating the Area Chart for Total Movies and TV Shows by Release Year

We will now create an area chart to display the total number of movies and TV shows by release year. The x-axis will represent the release year, and the y-axis will show the count distinct of show IDs. We will add the "Type" column to the legend to differentiate between movies and TV shows.

To format the area chart, we will use a white background and white values for the x-axis and y-axis. We will set the title to "Total Shows by Release Year" and align it to the center. We will also customize the line colors for movies and TV shows using the color codes #00A8E1 and #008AE1, respectively. Adding a border with rounded corners will give the chart a polished look.

Creating the Horizontal Bar Chart for Ratings by Total Shows

Now, let's create a horizontal bar chart to Visualize the ratings distribution of the total shows. We will use the "Horizontal Bar Chart" visualization and set the ratings as the y-axis and the count distinct of show IDs as the x-axis.

To format the horizontal bar chart, we will choose a white background and a border with rounded corners. The title will be "Ratings by Total Shows" aligned to the center. We will set the values, text, and data labels to white as well. This chart will provide insights into the distribution of ratings among the shows.

Creating the Horizontal Bar Chart for Genres by Total Shows

Another visualization we will create is a horizontal bar chart to display the distribution of genres among the total shows. We will follow a similar process as the previous chart, but this time, the y-axis will represent the genres, and the x-axis will show the count distinct of show IDs.

To format the horizontal bar chart, we will use a white background and a border with rounded corners. The title will be "Genres by Total Shows" aligned to the center. We will set the values, text, and data labels to white. This chart will provide insights into the popularity of different genres among the shows.

Adding the Cards

To enhance the dashboard further, we will add informative cards that display key metrics. We will create six cards in total, each representing different metrics such as total titles, total ratings, total genres, start date, end date, and total directors.

To format the cards, we will use a custom background color, a white border with rounded corners, and white text. Each card will have a specific metric value displayed in a large font size. We will align the text to the center and place the cards in a visually appealing layout.

Customizing Each Card

After adding the cards, we can customize them individually to provide more Context and improve the visual appeal. We can change the colors of the parts to match the overall theme and adjust the size and positioning of the cards to ensure they fit well within the dashboard layout.

Conclusion

In this tutorial, we learned how to create an Amazon Prime Video dashboard using Power BI. We explored various visualizations such as field maps, donut charts, area charts, and horizontal bar charts. We also added informative cards to display key metrics. With these visualizations, we can analyze and extract insights from the data to understand the distribution and popularity of different shows on Amazon Prime Video.