DVD Rental Business Analysis using SQL

Links to Full Report:

GitHub version

Google Docs version (includes SQL query screenshots)

Project Overview/Scope:

This data analysis project aims to provide insights into the sales performance of a DVD rental company. By analyzing various aspects of the sales data, I seek to pinpoint specific patterns within the sales data and formulate data-driven recommendations based on these findings.

Business questions include:

Who are the staff making the highest sales?

Who are the customers spending the most on DVD rentals?

What patterns are showing up and what can they tell us?

Tools Used:

Excel, PostgreSQL, and PgAdmin4

After data analysis I've landed on the following summarized results:

1. Jon and Mike, the only two employees, have similar total sales amounts, with Jon's total sales marginally higher.
2. DVDs priced at $2.99 and $4.99 had the highest volume of sales, and $0.99 had the lowest quantity of sales.
3. Your top 10 customers have purchased $150-200 worth of DVD rentals in one year.
4. Among your top 10 customers, the most popular film category is family, followed by foreign, horror, sci-fi, and documentary.

Business Recommendations are as follows:

I’d recommend you consider prioritizing adding new DVDs priced at $4.99 and $2.99 to your inventory. DVDs priced at $0.99 should be de-prioritized in considering new inventory, as they are the least popular. The existing $0.99 films should still be promoted, in order to attract customers who are drawn in by low prices. Among your top 10 customers, who’ve spent around $150-200 renting with you, family is the most popular film category. In your next promotion event, I’d recommend highlighting family movies, and foreign, horror, sci-fi, and documentaries, which were also popular choices.