Project Overview

Queried a relational database using SQL to support the launch of an online streaming service. The analysis identified revenue-driving films, high-value markets, and regional sales trends to inform content strategy and customer targeting.

Tools Used

---

• PostgreSQL – Relational Database
• DbVisualizer – Entity Relationship Diagram
• Tableau – Visualisation
• Excel – Sharing Results
• Word – Data Dictionary
• PowerPoint – Presentation

Skills Demonstrated

---

• Database Setup
• Data Structure Interpretation | Data Dictionary Creation
• SQL Query Writing – Filtering | Sorting | Joining | Aggregating | Subqueries | CTEs
• Visualisation | Presentation

Data Sourced

---

This analysis uses a modified version of the DVD Rental dataset originally provided as a sample database for learning and testing SQL with PostgreSQL. The dataset was adapted and provided by CareerFoundry as part of their Data Analytics Course.

• Dataset – Film, inventory, customer, payment, and rental records

Key Insights

Existing Catalogue & Client Base

---

Insight.

Analysis

---

Insight.

---

Insight.

Key Takeaways

Recommendations

---

• Geographic Performance
  Asia is the best performing region and further investment in this region should yield substantial returns.

Oceania is the worst performing and strategies should be explored for expansion in this region.

• Catalogue Offering
  The catalogue currently only offers English language films and should be expanded to include more localised content.

• Customer Loyalty
  Development of a rewards program for loyal customers to encourage repeat rentals.

Links & Deliverables

---

• GitHub Repository — Entity Relationship Diagram | Data Dictionary | Query Output | Presentation
• Tableau Public – Visualisations