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