cancel
Showing results for 
Search instead for 
Did you mean: 

Challenge #70: Trade Area Drivetime Radii

MattD
Alteryx Alumni (Retired)

Challenge #70: Trade Area Drivetime Radii

The solution to last week's challenge is HERE!

 

Challenge 70.jpg

 

Today we’re challenged to find the total area (square miles) that we can move our company headquarters to such that it is an equidistant commute from 3 satellite offices. In order to do so, find the area that is shared by a 30 minute drive time radius starting from each of the satellite offices!

 

Be warned! You may arrive on different areas depending on the spatial data release that is used, in addition to the drivetime methodology selected. For the sake of comparison, use the above map as an estimation of the area if you are not using the Q2: 2016 TomTom US Peak Most Recent Vintage dataset. If you think you need a hint, expand the spoiler below!

 

Spoiler
This week's challenge is inspired by the methodologies covered in our Trade Area Tool Mastery article from the Knowledgebase. If you're having trouble, try mastering the Trade Area Tool first!

 

Former Alteryx, Inc. Support Engineer, Community Data Architect, Data Scientist then Data Engineer
Attachment
Download this attachment
Attachment
Download this attachment
Highlighted

Re: Challenge #70: Trade Area Drivetime Radii

Dont have access to drivetime data. But partially completed challenge. Might be helpful for someone.

Sapna Gupta
Attachment
Download this attachment
martinding
Pulsar

Re: Challenge #70: Trade Area Drivetime Radii

Don't have TomTom 2016 US, but I do have TomTom AU, so I improvised a little 

Spoiler
70.png

Attachment
Download this attachment
AndrewHoData
Asteroid

Re: Challenge #70: Trade Area Drivetime Radii

Don't have US drivetime data.

Do have Australian / New Zealand drivetime data.

Made dummy dataset in Australia to recreate the scenario instead.

Spoiler
AndrewHoData_0-1668568117483.png

 

Attachment
Download this attachment
mzajac
Meteor

Re: Challenge #70: Trade Area Drivetime Radii

Since I don't have the access to Drivetime Datasets, I have used a standard Radius Area in km.

 

Spoiler
mzajac_0-1668679521944.png
Attachment
Download this attachment
Ladarthure
14 - Magnetar

Re: Challenge #70: Trade Area Drivetime Radii

my solution without the drivetime data Smiley Happy

Attachment
Download this attachment
willstom24
Meteor

Re: Challenge #70: Trade Area Drivetime Radii

Here is my solution using distance rather than drivetime.

Attachment
Download this attachment
nravik
11 - Bolide

Re: Challenge #70: Trade Area Drivetime Radii

Not have the drivetime tools. Attached solution! Thank you.

Attachment
Download this attachment
DanielG
Quasar

Re: Challenge #70: Trade Area Drivetime Radii

Solved with a guesstimated distance of 11.75 which got me close enough to the sample result.

I left polygon in there to show what I came up with too.

Attachment
Download this attachment
bwins
Asteroid

Re: Challenge #70: Trade Area Drivetime Radii

don't have drivetime tools so I did an alternate version - under the advice of Charnley!

Spoiler
bwins_0-1670943948572.png

 

Attachment
Download this attachment
Liusaidhowen
Asteroid

Re: Challenge #70: Trade Area Drivetime Radii

My solution

Attachment
Download this attachment