Rockbuster Stealth, a fictitious video rental company, currently operates as a brick-and-mortar shop with rental services throughout the globe. They are currently looking to switch to the more popular streaming service model and want recommendations on how to do so. My task was to look into their data warehouse using PostGRE SQL to identify two things: 1) find opportunities in their film collection for the transition, and 2) the top customers of their service and what countries they were located.
The first step in this process was to read the data dictionary of their data and manipulate it so that I can gather information on the inventory of films and their client base. This was done using JOIN commands on the various key variables in order to come up with the proper table and observations. It is from here that I am able to look through the information on the films to try and deduce some insight on how to improve the film collection. I also came across some issues in regard to the velocity of the data coming into the warehouse: it was only updated once, and some time ago. This led to my recommendation of implementing an updated and more reliable system to refresh the information on file.
The next item I needed to identify was the top customers and their country of origin. To accomplish this, we needed to JOIN more of the data over various tables, and then run a GROUPBY analysis and sort in order to get a list of the top 5 customers and what country they live in. With this information, I can recommend that they have a loyalty incentive program, and perhaps hold a launch party in the top 5 countries with their top customers.
Through this analysis, we can determine more efficient means of data collection and storage, film inventory and ways to improve this based on customer base, and top customers for future implementation of loyalty programs.
Rockbuster Stealth PowerPoint PresentationGithub Repository
