Portfolio

SQL deliverables

• Which movies contributed the most/least to revenue gain?

• What was the average rental duration for all videos?

• Which countries are Rockbuster customers based in

• Where are customers with a high lifetime value based?

• Do sales figures vary between geographic regions?

• Write moderately complex SQL queries to answer business questions.

• Present SQL results to business managers by creating visualizations and telling a compelling story.

• Present SQL results to your technical colleagues using Excel and by creating a data dictionary.

Note

This data set contains fictitious information about Rockbuster’s film inventory, customers, and payments, among other things.

Visualization

This Tableau Story clarifies deliverables with a storyboard.