Designing a global metaverse — In the second episode of Build Out, Colt McAnlis and Reto Meier were given the challenge of designing a global metaverse. Take a look at the video to see what they came up with, then continue reading to see how you can learn from their explorations to build your own…

Designing an autonomous, learning smart garden — In the first episode of Build Out, Colt and Reto — tasked with designing the architecture for a “Smart Garden” — supplied two very different concepts, that nevertheless featured many overlapping elements. …

Crime Distribution in San Francisco — Map all the SFPD incidents since 2010 and the Tenderloin stands out as a place you probably want to be careful if you’re visiting The City. I wondered how different types of crime are distributed around the City by the Bay — so I fired up BigQuery and used…

Using the NOAA GHCN and GSOD datasets — The analysis in today’s Today I Learned with BigQuery was performed by @savio_lawrence using BigQuery, Tableau, and the NOAA GHCN and GSOD datasets to see what observations we can make about changes in the average temperatures recorded at weather observation stations around the world. Before we dive-in, note that while…

San Francisco. Fog City. The City by the Bay. No matter what you call it, those 47mi² are home to over 800,000 people about whom we can draw outrageous conclusions using the new San Francisco public dataset in BigQuery. Thanks to the City and County of San Francisco’s SF…

The New York City public dataset contains all the 311 complaints made since 2010. Let’s see how the city has improved — and gotten worse — over the past 6 years. The graph below highlights the 311 complaints, with significant call volume, with the biggest increase / decrease between…

Importing data for analysis with Google BigQuery — Originally published on the Google Cloud Big Data and Machine Learning blog The NYC 311 dataset in BigQuery indicates a dramatic increase in complaints about rats, starting in 2013.

Using Google BigQuery to explore how weather affects NYC — Originally published on the Google Cloud Big Data and Machine Learning blog With over 150GB of New York City public data, parsing it all for patterns and insights is a challenge. One solution? …

Originally published on the Google Cloud Big Data and Machine Learning blog Google BigQuery lets you process your first terabyte of data, every month, at no cost. This allowance is automatically applied to each project, so if you’re already using BigQuery you’re already taking advantage. If you’re new to BigQuery…