ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
Rockbuster Movie Analysis Client Requests
4
5
TABLE OF CONTENTS
6
Leo Finley
7
Compiled October 14th, 2023
8
9
Rockbuster Data Dictionary
10
Rockbuster ERD
11
Powerpoint Presentation
12
Tableau Storyboard
13
14
SheetClient Request
15
'01_Uptown_title_film_list'!A1Which films have "Uptown" somewhere in the title?
16
'02_film_length_rental_rate'!A1Which films have a length of over 120 minutes and a rental rate of $4.99?
17
'03_films_rental_duration_4_to_6'!A1Which films have a rental duration between 3 and 7 days?
18
'04_replacement_cost_less_14 99'!A1Which films have a replacement cost less than $14.99?
19
'05_films_G_or_PG'!A1Which films are rated either PG or G?
20
'06_G_PG_film_aggregates'!A1
What are the count of films, average movie rental rate, maximum rental duration, and minimum rental duration values for G and PG movies?
21
'07_film_table_non_numeric_stats'!A1Compile descriptive stats for numerical values in 'films' table
22
'08_film_table_numeric_stats'!A1Compile descriptive stats for non-numerical values in 'films' table
23
'09_customer_table_stats'!A1Compile descriptive stats for 'customer' table (all non-numerical)
24
'10_top_countries_cust_counts'!A1Find the top 10 countries for Rockbuster in terms of customer numbers
25
'11_top_cities_from_top_countrie'!A1Identify the top 10 cities that fall within any of the top 10 customers identified in step 10.
26
'12_top_5_customers'!A1
Find the top 5 customers in any of the top 10 cities who have paid the highest total amounts to Rockbuster (to aid in loyalty rewards).
27
13What is the maximum amount paid for each film?
28
'14_films_valued_under_avg_p'!A1Which films are valued lower than the average customer amount paid?
29
'15_short_movie_count_G_PG_PG13'!A1Which films are less than 100 minutes and also rated G, PG, or PG-13?
30
'16_top_cust_average_paid'!A1What is the average amount paid by the top 5 customers?
31
'17_all_cust_average_paid'!A1How many of the top 5 customers are based within each country?
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100