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.
​Generating trade areas based on drive/walk-time isolines​
We generate trade areas based on drive/walk-time isolines from Snowflake console and from CARTO Builder.


​
​Geocoding your address data​
We provide an example that showcase how to easily geocode your address data using the Analytics Toolbox LDS module from the Snowflake console and from the CARTO Workspace.
​
​Creating spatial index tilesets​
We provide a set of examples that showcase how to easily create tilesets based on spatial indexes allowing you to process and visualize very large spatial datasets stored in Snowflake. You should use this procedure if you have a dataset that...
​
​A Quadkey grid of stores locations and simple cannibalization analysis​
We are going to demonstrate how fast and easy it is to make a visualization of a Quadkey grid to identify the concentration of Starbucks locations in the US.
​
​Minkowski distance to perform cannibalization analysis​
In this example we are going to showcase how to use the Minkowski distance to evaluate cannibalization across Starbucks stores in Los Ángeles, assuming that the ratio of cannibalization depends on the nearby store
​
​Computing US airport connections and route interpolations​
In this example we will showcase how easily we can compute all the paths that interconnect the main four US airports using the Analytics Toolbox.
​
​New supplier offices based on store locations clusters​
In this example we are going to use points clustering to analyze where to locate 10 new supplier offices in US so they can best serve all Starbucks locations.
​
​Analyzing store location coverage using a Voronoi diagram​
Voronoi diagrams are a very useful tool to build influence regions from a set of points and the Analytics Toolbox provides a convenient function to build them. An example application of these diagrams is the calculation of the coverage area...
​
​Enrichment of catchment areas for store characterization​
In this example we are going to characterize all Starbucks locations in the US by the total population covered by their catchment areas. We are going to define these catchment areas as a 3km buffer around each store.


​
​
 This project has received funding from the European Union’s Horizon 2020 research and innovation programme under grant agreement No 960401.
Running queries from Builder
Generating trade areas based on drive/walk-time isolines
Last modified 4mo ago