William Preddy

“Rockbuster Stealth LLC” Analysis

• Objective-
  • Perform regional and customer-based analysis of Rockbuster Stealth’s database, using SQL, to derive insights and suggest strategies for launching a global streaming service. (Project brief)
• Skills-
  • Reading Entity Relationship Diagram (ERD)
  • Creating Data Dictionaries
  • Database Querying
  • Filtering Data
  • Data Cleaning and Summarizing
  • Joining Tables
  • Constructing Subqueries
  • Using Common Table Expressions

• Data-
  • “Rockbuster” data set– provided by CareerFoundry

• Tools-
  • Excel
  • PowerPoint
  • PostgreSQL
  • Tableau
  • DbVisualizer

Process Highlights

Problem: There was no basic data known about movie library.

Solution: Performed data summarization queries.

Problem: The cities with the most customers were unknown.

Solution: Joined multiple tables and used “GROUP BY” function.

Data insights

(To view more SQL code, click here)

Rockbuster’s clientele is very regionally diverse.

The average duration of a movie rental is 6 days.

Asia & Pacific is region with the largest contributor to revenue.

The top 10 movies do not correlate to any genres.

Recommendations

PowerPoint reporting (Final report)

• Rewards Program
  • Incentivize shorter rental durations (less than 6 days) to encourage quicker rental turnover.
• Invest More in Asia
  • Allocate more marketing funds to the regions that bring in the most revenue.
• Translate Movie Library
  • Because of Rockbuster’s diverse clientele, invest in dubbing or subtitling the entire movie collection.