Tools: SQL, Tableau. Link to full project

Challenge: "Rockbuster," a fictional movie rental company, needs insights to inform launch strategy for their new, online streaming service. Descriptive SQL analysis to answer specific business questions, formatted as a concise presentation covering the performance of their video library and customer base for existent DVD-based rental service. Set up a relational database environment using PostgreSQL, extracted an ERD for analysis to create a data dictionary and identify keys. Conducted CRUD operations and filtering and aggregating data. Cleaned, and summarized data statistics for EDA. Used the joining of tables, subqueries and common table expressions to offer highly nuanced understanding of global customer distribution and spending by country and city, as well as identifying the top 5 lifetime value customers across the planet. Created spatial and multivariate statistical visualizations.