I have been collecting DVD’s since 1999 with my first purchase of a DVD was Bad Boys for £20 I now have 750+ DVD’s in my collection. I have been using an app on my iPhone called My Movies which is a great app and gives every user what they would want when collecting movies, tv series etc.
I wanted more control over the data, so using the My Movies app it has a CSV export feature, which provides 65 columns providing a massive dataset for every film or tv series etc added to the collection. I decided to create my own dataset from the data provided I upload my DVD collection into Google Sheets then connected it to Google Big Query.
From the 65 columns of data available I have streamlined it to 12 columns
Which provides the ability to cut and slice the data in many ways.
Using the available data I have created different views in Big Query which can be found on GitHub which has allowed me to create a Looker Studio Dashboard sharing key insights and data from my DVD collection.
Happy to add anyones email address to the Big Query table who wish to query my dvd collection, I did have the table set to public but to avoid any unnecessary costs I have moved it to private.
