Skip to content

LColdridge/R-PowerBI_Data_Visualisation_Project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

12 Commits
 
 
 
 

Repository files navigation

R PowerBI Data Visualisation Project

For this project, I used Rstudio to analyse and clean an open source dataset. This included, checking data types, dropping missing values, duplicates and outliers and rounding. I showcased summary statistics, a scatterplot and bar charts. Finally, I imported the clean data into Microsoft Power BI to create a visually pleasing dashboard.

Data:

Hollywood's Most Profitable Stories - Title, Genre, Studio, Profitability and Ratings

Objectives:

  • To analyse the performance of Hollywood movies
  • Create dashboard in Power BI to show client requirements

Dashboard:

Hollywood Movies Data - Power BI Screenshot 2023-04-01 193753 My dashboard shows:

  • The average Rotten Tomatoes ratings of each genre
  • The number of movies produced per year
  • The audience score for each film
  • The profitability per studio
  • The worldwide gross per genre
  • Studio comparison filter