Marketing Launch Strategy:

Rockbuster Films

Completed June 2023 (CareerFoundry)

  • The Rockbuster Stealth Management Board and Business Intelligence Department.

  • Rockbuster Data Set and Database

    • Relational database containing information about rentals, customers, employees, stores, films, payments, and addresses (provided by CareerFoundry program)

    • Subqueries, joins, and CTEs within SQL

    • Thorough commenting for collaboration, clarity, and organization

    • Relational Databases & Entity Relationship Diagrams (ERDs)

    • SQL: database querying, cleaning data, filtering data, summarizing with descriptive statistics, joining tables, sorting and grouping data, subqueries, Common Table Expressions, creating and accessing views

    • Data Dictionaries

    • Dashboard design

    • Presenting and visualizing SQL outputs in Tableau

    • Translating Business requirements

    • Global Marketing Content

    • Ad Hoc Reporting with Excel

  • SQL, PostgreSQL, pgadmin, DbVisualizer, Excel, Tableau, PowerPoint

Context and Objective:

Rockbuster Stealth is a movie rental service hoping to analyze its current video library to create a launch strategy for its transition to an online video streaming service. The analysis aims to answer key business questions to provide the company with marketing recommendations.

Understanding key business questions and priorities is essential to effective analyses.

Which movies contributed to the most and least revenue gain?

What was the average rental duration for all videos?

Which countries are Rockbuster customers based in?

Do sales figures vary between geographical regions?

Where are customers with a high lifetime value based?

A slide with the title "Recommendations", that lists inventory, regional, and customer recomendations for the company.

The Process

First, I familiarized myself with the data and created an extensive data dictionary to help stakeholders understand the data sets.

First, I familiarized myself with the data and created an extensive data dictionary to help stakeholders understand the data sets.

I also created an Entity Relationship Diagram in DBVisualizer to help navigate the relational database system within pgadmin.

I also created an Entity Relationship Diagram in DBVisualizer to help navigate the relational database system within pgadmin.

I executed SQL queries to clean data (addressed duplicates, non-uniform data, missing values), filter data, summarizing with descriptive statistics (including GROUP BY and ORDER BY clauses for complex questions), complete table joins and utilize Comm

I executed SQL queries to clean data (addressed duplicates, non-uniform data, missing values), filter data, summarizing with descriptive statistics (including GROUP BY and ORDER BY clauses for complex questions), complete table joins and utilize Common Table Expressions (CTEs)

I translated technical analytical steps into Tableau and PowerPoint visualizations and effectively summarized relevant findings in simple ways.

I translated technical analytical steps into Tableau and PowerPoint visualizations and effectively summarized relevant findings in simple ways.

I was able to answer all key business questions, utilizing treemaps, geospatial analysis, scatterplots, and stacked bar charts.

I was able to answer all key business questions, utilizing treemaps, geospatial analysis, scatterplots, and stacked bar charts.

To address ad hoc requests, I compiled a highly organized Excel technical report as a deliverable.

To address ad hoc requests, I compiled a highly organized Excel technical report as a deliverable.

After highlighting key insights, I used analytical thinking to suggest marketing strategy and complete follow up analyses.

After highlighting key insights, I used analytical thinking to suggest marketing strategy and complete follow up analyses.

Previous

Healthcare Staffing Distribution (Excel, Tableau)
Next

Music Industry: Taylor's Era (Python, Tableau)