Portfolio Project - Nearest McDonald's Locations
This portfolio project is a dashboard which will show the two nearest McDonald's locations based on your zip code (United States only). For this portfolio project, two data sets were uploaded to Google BigQuery: a data set on US zipcodes, which also contains the respective latitude and longitude coordinates, as well as a data set on all McDonald's locations worldwide (updated last in 2022).
• I've joined these data sets in BigQuery, and filtered out all but the United States.
• Based on the latitude and longitude coordinates per zip code, I have calculated the distance to other McDonald's locations and have filtered on the nearest two.
• To add both the user input and the McDonald's locations into one map, a data union was needed, which isn't natively supported by Looker Studio. As an alternative, I've created a full outer join and used the coalesce function to consolidate the data from both sources into one.
◦ Edit: I've improved the performance considerably by moving the data union into BigQuery rather than using a fake union in Looker Studio. The difference in performance can be checked below. You can switch between the old and new version by clicking the numbers 1 and 2 on the top left side. Page 1 contains the old version and page 2 contains the new version.
I've created this self-guided portfolio project during my participation in the award-winning Looker Studio Masterclass, hosted by none other than Siavash Kanani, giant in the analytics industry.
Note: If you would like to see a full screen version, click here.