Streaming Service Content analysis

The purpose of this dataset is to test my data cleaning and visualization skills

Part 1.

Data Cleaning ( Excel & SQL)

What was done :

Treat the Nulls

Treat the duplicates

Populate missing rows

Drop unneeded columns

Split columns

Pat 2.

Data Visualization (Power BI)

After cleaning, the dataset is set for some analysis and visualization with Power BI

1. The Card shows the two categories of content in the dataset which are Movie and Tv show.

•      As we can see the majority of the content is Movie which takes **69.9% (6.13K)**
  

2. The Filled Map shows the the total amount of Movies and Tv shows per country within the given period of time(2008 - 2021). This can be noted by the size of the coloured circle in the map.

• We can see that the United State of America has the largest size, followed by India and the United Kingdom.

3.* The Stacked Bar chart shows the top 10 directors with most contents on the streaming service. This chart shows the count of Movie and Tv shows in their catalouge.*

• We can see that most of these directors contents are movies.
• We can also note that the duo of Raul Campos and Jan Suter are fond of working together and have directed 18 movies.

4. The Pie Chart shows the genres with the highest numbers on the popular streaming service.

We can see that Drama & International movies followed by Documentary have the highest number of contents on the streaming service within the period.

5. The Clustered Column Chart - Rating is a system to rate motion picture's suitability for certain audiences based on its content. This chart shows the top ratings on the streaming service

• We can note that most contents are rated TV-MA. TV-MA in the United States by the TV Parental Guidelines signifies content for mature audiences.

6. The Line Chart compares the Movie and Tv shows contents added all through the years.

• We can see that more movies have always been added.
• In 2013, the number of contents added for both were almost the same with Movies having 6 contents that year and Tv shows having 5.
• It shows that in the first 5 years, only movies were added.