Posts by
Helen McKenzie

Self-service spatial analytics with user-defined parameters
Unlock Spatial Insights for non-expert users with User-Defined Parameters. Learn how to democratize geospatial data analysis for faster decision-making.
Improving Customer Experience in Telecoms with Geospatial
A guide to using geospatial to improve the Telecom customer experience, including network optimization, service personalization & targeted support.
A Guide To Using GTFS Data
Everything you need to know about GTFS data for transit analysis; where to source, data wrangling & how to turn it into GIS layers
How Geographically Weighted Regression works
Find out what Geographically Weighted Regression (GWR) is, how it works, when to use it & how to use spatial indexes in conjunction.
How To Optimize Location Planning For Wind Turbines
A guide to the different spatial data sources and techniques which can be used to optimize the site selection process for wind turbines.
5 maps you didn't know you could create with SQL
Did you know you can use Spatial SQL to create amazing maps and data visualizations? Learn how with these five examples!
How to use Location Intelligence to grow London's brunch scene
How to use Location Intelligence tools to establish new opportunities for specific restaurant types, based on geosegmentation and catchment areas.











Finding that Spatial someone: using analytics to find love
What role does location play in dating apps? This guide shares how spatial analysis can be used to optimize dating apps with real examples.
Women in STEM: reflections & advice from CARTO's experts
To mark Women in STEM day 2023, we interviewed experts across CARTO to hear advice and reflections on a career in STEM.











Calculating Routes at Scale using SQL on BigQuery
A guide to route optimization using Google BigQuery, a cloud-native & scalable alternative to PgRouting & Network Analyst.
How to get your colleagues & clients excited about geospatial
A guide to getting your colleagues & clients excited about geospatial technology and spatial analysis, with practical tips and advice
22 of the best maps, visualizations & analysis from 2022
A round-up of some of our favorite pieces of analysis, maps and visualizations using CARTO from 2022 in areas including retail, transport, climate & more!
How to calculate spatial hotspots and which tools do you need?
A comparison of the main spatial hotspot tools and which is best for your use case, including a guide on how to use and interpret these.
The Ultimate Guide to OpenStreetMap & BigQuery
A guide to the pros & cons of OpenStreetMap geospatial data, and how to access it via Google BigQuery











Migrating spatial analytics from PostgreSQL to Snowflake
A step-by-step guide to migrating PostgreSQL geospatial workflows to the Snowflake Data Cloud using CARTO.
What we learned: #SDSC22 New York
Miss the Spatial Data Science Conference in NYC? Here’s a quick recap as well as information about how to get involved in future events.











IoT Analytics & Geospatial Data: How It Works
We explore how IoT Analytics use cases are driven by geospatial data for catastrophe modeling, in smart cities & supply chain.
How to create and use Isolines with CARTO
Follow our guide for creating isolines & trade areas, the cloud-native spatial data science platform, as well as how to use these to derive actionable insights.
CARTO’s Ultimate Guide to Spatial Joins & Predicates with SQL
Get started with Spatial SQL with this guide to using spatial relationships.
How to create Google Street View pop-ups with CARTO
CARTO's guide to using Google Street View images in your map pop-ups!
Using Location Intelligence to combat The Great Resignation in Logistics
The Great Resignation means competition for staff is ever increasing. CARTO explores how spatial unemployment patterns can be used to tackle this.
Venue Suitability Analysis for the Eurovision Song Contest with CARTO
How to use Location Intelligence to pick the optimal venue for the UK's Eurovision Song contest with CARTO
Sistema.bio's Story: Optimizing field operations with CARTO
Understand how Sistema.bio is using CARTO to manage and plan their field operations to bring their sustainable biodigester to the world’s smallholders.
COVID, mapped: The analytics behind an epidemic
CARTO teams up with ZOE to analyze & predict the spatial patterns of COVID-19to develop a blueprint for understanding the spatial patterns of an epidemic.












Exploratory Data Analysis: UK retail centres
CARTO shares how you can use Exploratory Data Analysis to better understand your data and frame future analysis with CDRC’s latest dataset - UK Retail Centres
Super Charged Site Selection for Electric Vehicles
CARTO partners with CITD to understand how Location Intelligence can be used to drive stronger return on investment for Electric Vehicle charging stations.











Analyzing Sentiment & Footfall in Post-COVID Berlin
Follow along as Data Appeal uses CARTO’s Location Intelligence platform to evaluate tourism in Berlin post-COVID.
Cost of Living Crisis: Location Intelligence for Energy Efficiency
Improved availability & analytics of residential energy performance data will be a powerful tool to help during this crisis. Learn more & see it in action.
How Yale Climate Connections Uses Spatial Visualization for Community Engagement
See how Yale Climate Connections used CARTO to create a spatial visualization that shares local stories to help explain climate change.
Ghost Kitchens: Predictive Location Intelligence
“CARTO uses Location Intelligence to predict locations of one of the hottest trends in food delivery - ghost kitchens."
Hexagons for Location Intelligence: Why, When & How?
“CARTO explains how using hexagonal grids in your location-based analysis can lead to more efficient analysis and greater insight."
Understanding Retail Store Clusters with Local Outlier Factor Analysis
“See how Local Outlier Factor can be used as a tool for understanding the spatial patterns of retail store locations."











Dark Store Site Selection: How Geospatial Data Can Help
See how market leaders are doing dark store site selection using geospatial data & analytics with CARTO & Snowflake.
Analyzing NYC Caffeine Deprivation through Location Intelligence
“Curious about the number of coffee shops in NYC? Join us as we investigate the spatial patterns of coffee shops across the city."
International Women’s Day: Mapping Financial Inequality by Gender
“For International Women’s Day 2022, CARTO uses location intelligence to analyze financial inequality between gender in different countries. "