Posts by

Helen McKenzie

Helen McKenzie
Helen is CARTO's Geospatial Advocate where she works to get the data science community excited about thinking about “where?” Whether it's electric vehicle Site Selection, analyzing caffeination deprivation or choosing the next Eurovision Song Contest venue, Helen's posts are all about opening your eyes to the possibilities of geospatial.
Self-service spatial analytics with user-defined parameters

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.

Location Intelligence
Improving Customer Experience in Telecoms with Geospatial

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.

Use cases
A Guide To Using GTFS Data

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

Spatial Data
How Geographically Weighted Regression works

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.

Spatial Data
How To Optimize Location Planning For Wind Turbines

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.

Use cases
5 maps you didn't know you could create with SQL

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!

Cartography & Visualization
How to use Location Intelligence to grow London's brunch scene

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.

Use cases
Finding that Spatial someone: using analytics to find love

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.

Use cases
Women in STEM: reflections & advice from CARTO's experts

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

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.

News
How to get your colleagues & clients excited about geospatial

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

Location Intelligence
22 of the best maps, visualizations & analysis from 2022

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!

Data Visualization
How to calculate spatial hotspots and which tools do you need?

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.

Data Processing
The Ultimate Guide to OpenStreetMap & BigQuery

The Ultimate Guide to OpenStreetMap & BigQuery

A guide to the pros & cons of OpenStreetMap geospatial data, and how to access it via Google BigQuery

Spatial Data
Migrating spatial analytics from PostgreSQL to Snowflake

Migrating spatial analytics from PostgreSQL to Snowflake

A step-by-step guide to migrating PostgreSQL geospatial workflows to the Snowflake Data Cloud using CARTO.

Technology
What we learned: #SDSC22 New York

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.

News
IoT Analytics & Geospatial Data: How It Works

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.

Use cases
How to create and use Isolines with CARTO

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.

Data Processing
CARTO’s Ultimate Guide to Spatial Joins & Predicates with SQL

CARTO’s Ultimate Guide to Spatial Joins & Predicates with SQL

Get started with Spatial SQL with this guide to using spatial relationships.

Data Processing
How to create Google Street View pop-ups with CARTO

How to create Google Street View pop-ups with CARTO

CARTO's guide to using Google Street View images in your map pop-ups!

Cartography & Visualization
Using Location Intelligence to combat The Great Resignation in Logistics

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.

Use cases
Venue Suitability Analysis for the Eurovision Song Contest with CARTO

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

Use cases
Sistema.bio's Story: Optimizing field operations 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.

Use cases
COVID, mapped: The analytics behind an epidemic

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.

Use cases
Exploratory Data Analysis: UK retail centres

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

Spatial Data
Super Charged Site Selection for Electric Vehicles

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.

Use cases
Analyzing Sentiment & Footfall in Post-COVID Berlin

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.

Spatial Data
Cost of Living Crisis: Location Intelligence for Energy Efficiency

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.

Spatial Data
How Yale Climate Connections Uses Spatial Visualization for Community Engagement

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.

Use cases
Ghost Kitchens: Predictive Location Intelligence

Ghost Kitchens: Predictive Location Intelligence

“CARTO uses Location Intelligence to predict locations of one of the hottest trends in food delivery - ghost kitchens."

Spatial Data
Hexagons for Location Intelligence: Why, When & How?

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."

Spatial Data
Understanding Retail Store Clusters with Local Outlier Factor Analysis

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."

Spatial Data
Dark Store Site Selection: How Geospatial Data Can Help

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.

Spatial Data
Analyzing NYC Caffeine Deprivation through Location Intelligence

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."

Use cases
International Women’s Day: Mapping Financial Inequality by Gender

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. "

Use cases