# Workflow templates ## How to use these templates The CARTO team has designed this collection of Workflows examples with a hands-on approach to empower users and ease the Workflows learning curve. These examples showcase a wide range of scenarios and applications: from simple building blocks for your geospatial analysis to more complex, industry-specific workflows tailored to facilitate running specific geospatial use-cases. Making use of these examples is very easy. Just click on "**New Workflow**" and "**From template**" in your CARTO Workspace to access the collection of templates. Once the workflow is re-created you will be able to modifying as with any other workflow, replacing the data sources and re-configuring the different nodes so it can be useful for your specific use-case. {% embed url="" %} ## Catalog of workflow templates ### Data Preparation * [Joining different datasets by a common column](https://academy.carto.com/creating-workflows/data-preparation#joining-different-datasets-by-a-common-column) * [Join two datasets and group by a property ](https://academy.carto.com/creating-workflows/data-preparation#join-two-datasets-and-group-by-a-property) * [Union of two data sources sharing the same schema](https://academy.carto.com/creating-workflows/data-preparation#union-of-two-data-sources-with-same-schema) * [Filter rows using a custom geography](https://academy.carto.com/creating-workflows/data-preparation#filter-rows-using-a-custom-geography) * [Generate a new column from a multi-column formula](https://academy.carto.com/creating-workflows/data-preparation#generate-a-calculated-column-from-a-multi-column-formula) * [Normalize a variable to an index between 0 to 1 ](https://academy.carto.com/creating-workflows/data-preparation#normalize-a-variable-to-an-index-between-0-and-1) * [Rank and limit a table](https://academy.carto.com/creating-workflows/data-preparation#rank-and-limit-a-table) * [Filter key columns and calculate an additional column](https://academy.carto.com/creating-workflows/data-preparation#filter-columns) ### Data Enrichment * [Enrich a set of buffers using Quadbin indexes](https://academy.carto.com/creating-workflows/data-enrichment#enrich-a-set-of-buffers-using-quadbin-indexes) * [Enrich trade areas using H3 indexes](https://academy.carto.com/creating-workflows/data-enrichment#enrich-trade-areas-using-h3-indexes) * [Enrich Point data with a custom source](https://academy.carto.com/creating-workflows/data-enrichment#enrich-point-data-with-a-custom-source) * [Enrich Polygon data with a custom source](https://academy.carto.com/creating-workflows/data-enrichment#enrich-polygon-data-with-a-custom-source) * [Enrich Grid data with a custom source](https://academy.carto.com/creating-workflows/data-enrichment#enrich-grid-data-with-a-custom-source) ### Spatial Indexes * [Polyfill a set of polygons with H3 indexes](https://academy.carto.com/creating-workflows/spatial-indexes#polyfill-a-set-of-polygons-with-h3-indexes) * [Aggregate point data into a Quadbin grid](https://academy.carto.com/creating-workflows/spatial-indexes#aggregate-point-data-into-a-quadbin-grid) * [Aggregate point data into an H3 grid](https://academy.carto.com/creating-workflows/spatial-indexes#aggregate-point-data-into-an-h3-grid) * [Use H3 K-rings to define areas of influence](https://academy.carto.com/creating-workflows/spatial-indexes#use-h3-krings-to-define-areas-of-influence) ### Spatial Analysis * [Find clusters of customers with K-Means algorithm](https://academy.carto.com/creating-workflows/spatial-analysis#find-clusters-of-customers-with-k-means-algorithm) * [Find points that lie within a set of polygons and add properties](https://academy.carto.com/creating-workflows/spatial-analysis#find-points-that-lie-within-a-set-of-polygons-and-add-properties) * [Aggregate point data into polygons](https://academy.carto.com/creating-workflows/spatial-analysis#aggregate-point-data-into-polygons) * [Generate Voronoi polygons from a set of points](https://academy.carto.com/creating-workflows/spatial-analysis#generate-voronoi-polygons-from-a-set-of-points) * [Custom SQL Select using 2 inputs](https://academy.carto.com/creating-workflows/spatial-analysis#custom-sql-select-using-2-inputs) ### Generating new spatial data * [Draw Custom Geographies](https://academy.carto.com/creating-workflows/generating-new-spatial-data#draw-custom-geographies) * [Create routes from origin/destination dataset](https://academy.carto.com/creating-workflows/generating-new-spatial-data#create-routes-from-origin-destination-dataset) * [Geocode street addresses into point geometries](https://academy.carto.com/creating-workflows/generating-new-spatial-data#geocode-street-addresses-into-point-geometries) * [Generate points out of Latitude and Longitude columns](https://academy.carto.com/creating-workflows/generating-new-spatial-data#generate-points-out-of-latitude-and-longitude-columns) * [Generate isochrones from point data](https://academy.carto.com/creating-workflows/generating-new-spatial-data#generate-isochrones-from-point-data) ### Statistics * [Identify hotspots of specific types of points of interest](https://academy.carto.com/creating-workflows/statistics#identify-hotspots-of-specific-point-of-interest-type) * [Space-time hotspot analysis](https://academy.carto.com/creating-workflows/statistics#space-time-hotspot-analysis) * [Spacetime hotspot classification: Understanding collision patterns](https://academy.carto.com/creating-workflows/statistics#spacetime-hotspot-classification-understanding-collision-patterns) * [Time series clustering: Identifying areas with similar traffic accident patterns](https://academy.carto.com/creating-workflows/statistics#time-series-clustering-identifying-areas-with-similar-traffic-accident-patterns) * [Computing the spatial auto-correlation of point of interest locations](https://academy.carto.com/creating-workflows/statistics#computing-the-spatial-auto-correlation-of-point-of-interest-locations) * [Applying Geographical Weighted Regression (GWR) to model the local spatial relationships in your data](https://academy.carto.com/creating-workflows/statistics#applying-gwr-to-model-the-local-spatial-relationships-in-your-data) * [Create a composite score with the supervised method (BigQuery)](https://academy.carto.com/creating-workflows/statistics#create-a-composite-score-with-the-supervised-method-bigquery) * [Create a composite score with the unsupervised method (BigQuery)](https://academy.carto.com/creating-workflows/statistics#create-a-composite-score-with-the-unsupervised-method-bigquery) * Detect Space-time anomalies ### Retail and CPG * [Estimate population around top performant retail stores](https://academy.carto.com/creating-workflows/retail-and-cpg#estimate-population-around-top-performant-retail-stores) * [Identify and analyze the commercial hotspots in an area](https://academy.carto.com/creating-workflows/retail-and-cpg#commercial-hotspot-analysis.-identifying-optimal-locations-for-a-new-pizza-place) ### Telco * [Estimate population covered by a telecommunications cell network](https://academy.carto.com/creating-workflows/telco#estimate-population-covered-by-a-telecommunications-cell-network) * [Mobile pings within Area of Interest](https://academy.carto.com/creating-workflows/telco#mobile-pings-within-area-of-interest) * [Population Statistics](https://academy.carto.com/creating-workflows/telco#population-statistics) * [Emergency Response](https://academy.carto.com/creating-workflows/telco#emergency-response) * [New tower site selection in Denver](https://academy.carto.com/creating-workflows/telco#new-tower-site-selection-in-denver) * [Competitor's coverage analysis](https://academy.carto.com/creating-workflows/telco#competitors-coverage-analysis) * [Path profile and path loss analysis](https://academy.carto.com/creating-workflows/telco#path-profile-and-path-loss-analysis) * [Path profile and path loss analysis with raster sources](https://academy.carto.com/creating-workflows/telco#path-profile-and-path-loss-analysis-with-raster-sources) ### Insurance * [Flood Risk Assessment](https://academy.carto.com/creating-workflows/insurance#flood-risk-assesment) * [Assess the damage of a volcano eruption in the island of La Palma](https://academy.carto.com/creating-workflows/insurance#assess-the-damage-of-a-volcano-eruption-in-the-island-of-la-palma) * [Insurance Underwriting](https://academy.carto.com/creating-workflows/insurance#insurance-underwriting) * [Coastal Flood Risk](https://academy.carto.com/creating-workflows/insurance#coastal-flood-risk) * [Calculate the risk score for a car's journey](https://academy.carto.com/creating-workflows/insurance#calculate-the-risk-score-for-a-cars-journey) ### OOH Advertising * [Identify the best billboards to target a specific audience](https://academy.carto.com/creating-workflows/out-of-home-advertising#identify-best-billboards-to-target-a-specific-audience) ### Templates for extension packages The following templates require that you have some extension packages installed in your connection. Read [this documentation](https://docs.carto.com/carto-user-manual/workflows/extension-packages) for more information. ### BigQuery ML {% hint style="success" %} For these templates, you will need to install the [**BigQuery ML extension package**](https://docs.carto.com/carto-user-manual/workflows/components/bigquery-ml). {% endhint %} * [Create a classification model](https://academy.carto.com/creating-workflows/bigquery-ml#create-a-classification-model) * [Create a regression model](https://academy.carto.com/creating-workflows/bigquery-ml#create-a-regression-model) * [Forecast](https://academy.carto.com/creating-workflows/bigquery-ml#forecast) * [Import a model](https://academy.carto.com/creating-workflows/bigquery-ml#import-a-model) ### Snowflake ML {% hint style="success" %} For these templates, you will need to install the [**SnowflakeML**](https://docs.carto.com/carto-user-manual/workflows/components/snowflake-ml) extension package. {% endhint %} * [Create a classification model](https://academy.carto.com/creating-workflows/snowflake-ml#create-a-classification-model) * [Create a forecasting model](https://academy.carto.com/creating-workflows/snowflake-ml#create-a-forecasting-model) ### Territory Planning {% hint style="success" %} For these templates, you will need to install the [**Territory Planning**](https://docs.carto.com/carto-user-manual/workflows/components/territory-planning) extension package. {% endhint %} * [Territory Balancing](https://academy.carto.com/creating-workflows/territory-planning#territory-balancing) * [Location Allocation - Maximize Coverage](https://academy.carto.com/creating-workflows/territory-planning#location-allocation-maximize-coverage) * [Location Allocation - Minimize Total Cost](https://academy.carto.com/creating-workflows/territory-planning#location-allocation-minimize-total-cost) --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://academy.carto.com/creating-workflows/workflow-templates.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.