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 to stay competitive.
As a data analyst, I’ve been tasked to help the business intelligence department with the launch strategy for the new online video service. My first task is to load Rockbuster’s data into a relational database management system (RDBMS). Then, I’ll use SQL to analyze the data and answer any ad-hoc business questions.
Tools, Skills, Techniques
As this was my first time working with relational databases and SQL, I had some trouble at the beginning of the project understanding the syntax of SQL and the formatting. As I progressed through the project, I became more familiar with it.
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 to stay competitive.
As a data analyst, I’ve been tasked to help the business intelligence department with the launch strategy for the new online video service. My first task is to load Rockbuster’s data into a relational database management system (RDBMS). Then, I’ll use SQL to analyze the data and answer any ad-hoc business questions.
Tools, Skills, Techniques
As this was my first time working with relational databases and SQL, I had some trouble at the beginning of the project understanding the syntax of SQL and the formatting. As I progressed through the project, I became more familiar with it.
The dataset contains information about Rockbuster's DVD rental information and actor's information.
First, I installed PostgreSQL and loaded the Rockbuster database to utilize SQL for the analysis. I extracted the ERD to create a data dictionary of the database. During the data quality checks, I found no issues and therefore no cleaning was done to the database.
Conclusion
Recommendations
