# 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)