data mart movies

You recently started working as a data analyst. Your company is planning to rank Top 10 movies. Using the attached dataset, perform following tasks.

  • Analyze the data.
  • Build the scoring model to produce top 10 movies.
  • Design the new Data Mart that supports score as well.

You are not required to build the data mart in the database.

You need to submit the activities below in a Word document.

  • List of important data field for scoring process.
  • A scoring model to determine the Top 10 movies.
  • Data Mart design with scoring.