BigQuery Portfolio

I was introduced to Google’s BigQuery during their Data Analytics Professional Certification and have included some screenshots demonstrating my work there. The public data I used here only contained one table which I divide into other tables in order to calculate profit and the number of movies each director had on the list. I then joined the two tables to be able to sort by number of movies or profit. Lastly, I exported the data to Google’s Data Studio but the two y-axes have different measures and I was unable to sync them so it’s a bit misleading. All in all, I find Tableau more readable for the visualization component.