Analytics Toolbox for BigQuery

Analytics Toolbox for BigQuery

Examples

In this section we provide a set of examples that showcase how to leverage the functions of our Analytics Toolbox to unlock advanced spatial analyses in your data warehouse platform. They cover a broad range of use cases with methods for data transformations, enrichment, spatial indexing in Quadkey and H3, statistics, clustering, spatial data science methods and more.

The Analytics Toolbox can be leveraged from the SQL Query editor in Builder, your data warehouse console, or in SQL and Python Notebooks using the SQL clients provided by the different cloud platforms.

    Applying GWR to understand Airbnb listings prices

    Geographically Weighted Regression (GWR) is a statistical regression method that models the local (e.g. regional or sub-regional) relationships between a set of predictor variables and an outcome of interest. Therefore, it should be used in lieu of a global model in those scenarios where these relationships vary spatially. In this example we are going to analyze the local relationships between Airbnb's listings in Berlin and the number of bedrooms and bathrooms available at these listings using the GWR_GRID procedure.

    Computing the spatial autocorrelation of POIs locations in Berlin

    In this example we analyze the spatial correlation of POIs locations in Berlin using OpenStreetMap data and the MORANS_I_H3 function available in the statistics module.

    Identifying amenity hotspots in Stockholm

    In this example we identify hotspots of amenity POIs in Stockholm using OpenStreetMap data and the GETIS_ORD_H3 function of the statistics module.