Rockbuster Stealth LLC is a movie rental company that used to have stores around the world. Facing stiff competition from streaming services such as Netflix and Amazon Prime, the Rockbuster Stealth management team is planning to use its existing movie licenses to launch an online video rental service in order to stay competitive
The Rockbuster Stealth Management Board has asked a series of business questions and they expect data-driven answers that they can use for their 2020 company strategy. Here are the main questions they’d like to answer:
● Which movies contributed the most/least to revenue gain?
● What was the average rental duration for all videos?
● Which countries are Rockbuster customers based in?
● Where are customers with a high lifetime value based?
● Do sales figures vary between geographic regions?
Data query using SQL. will be used to answer complex business questions for each task. The results of the analysis will be presented to Rockbuster management, for which it need to visualize data in an easy-to-consume way.
The data set used containing information about Rockbuster. film inventory, customers, and payments, among other things. working with data from the online video streaming industry for this project, provided by Career Foundry Institute.
The visualizations for the project were created in Tableau Public. https://public.tableau.com/app/profile/eduardo.sanchez.duran/viz/Rockbuster_campaigne2020_3_10/countgeographical