Challenge #197: Customer Density Reporting

A solution to last week's challenge can be found here.

Hi, yeah...if you could go ahead and produce those reports on our customer densities… that would be great. The Bobs put more directions inside. Thanks a bunch.

bill lumbergh.jpg

challenge_197_start_file.yxmd

Challenge - Report Outputs - 5-8.pdf

Challenge - Report Outputs - 0-5.pdf

challenge_197_solution.yxmd

Reporting

Join

Spatial Analysis

Preparation

Advanced

Intermediate

Transform

Spatial

Accepted answers

All comments

NicoleJohnson

Are there supposed to be PDF examples attached to the instructions for this challenge? Instructions mention "See PDFs attached to post" but there are none attached... thanks! 🙂

Kenda

Hi @AYXAcademy

Could you post the PDF's for the output, please? 🙂

AYXAcademy

@NicoleJohnson @Kenda Updated!

NicoleJohnson

I believe you have my stapler...

Spoiler

My workflow solution:

And a copy of the oh-so-important TPS report:

Cheers! 🙂

TPS Report Output - 5-8 Mile Radius.pdf

TPS Report Output - 0-5 Mile Radius.pdf

challenge_197_NicoleJohnson.yxmd

Kenda

Spoiler

With appropriate cover sheet, of course!

Admittedly, I've never seen this whole movie from start to finish... whoops

challenge_197_start_file.yxmd

neilgallen

because I need to justify my existence and don't want someone asking me what it is I do around here... no time for fancy cover sheets.

Spoiler

challenge_197_NGA.yxmd

Blake

Spoiler

We need to talk about your flair.

challenge_197_start_file_BH.yxmd

Challenge197.pdf

ddiesel

My solution:

Spoiler

challenge_197_end_file_ddiesel.yxmd

JReid

Spoiler

Why does it say paper jam when there is no paper jam?!

challenge_197_start_file.yxmd

avilagon

Done! Pretty fun.

Btw, that was my first experience using Spatial Objects.

Challenge 197 - Resuelto.yxmd

RWvanLeeuwen

Nice challenge albeit an easy one

Spoiler

challenge_197_start_file_Autosave - RWvL.yxmd

JoseAlcorta

It was pretty intresting, this was my first practical experience with spatial objects and it is a interesting subject, looking forward to new challanges!

challenge_197_start_file.yxmd

OllieClarke

simple tabular report for me

Spoiler

challenge_197_OC_solution.yxmd

0-5.pdf

5-8.pdf

JORGE4900

Transformed number into text to be able to visualize as sample with many digits.

Spoiler

challenge_197_Jorge4900.yxmd

mheinze

Spoiler

Learning from this challenge is to leave your calculation (customer density) as a string in order to match the decimal places indicated in the report specification. Creating it as a double results in a 6-decimal place maximum in the table tool and converting the double to a 15 decimal place string results in a trailing zero on the Home Office Radius 0-5 Customer Density.

challenge_197_complete_mh.yxmd

patrick_digan

Spoiler

Cover Sheet

Workflow

Data

challenge_197_start_file.yxmd

RolandSchubert

My solution

Spoiler

challenge_197_solution_rsc.yxmd

Challenge - Report Output RSC -0-5.pdf

Challenge - Report Output RSC -5-8.pdf

BradWerner

Spoiler

f463b39ea33256cd7f606405d4d81ca2769429e06e2e5df4b46a8031c517862c.jpg

challenge_197_BradWerner.yxmd

JustinBabbitt

This was fun, and right in my wheelhouse!

Spoiler

challenge_197_End_file_JTB.yxmd

Customer Density Report -Radius_ 0-5.pdf

Customer Density Report -Radius_ 5-8.pdf

terry10

New Year's resolution - to get back in the habit of doing weekly challenges!

Challenge_197 Report Outputs5-8.pdf

challenge_197_terry10.yxmd

Challenge_197 Report Outputs0-5.pdf

This one was super fun!

Spoiler

I started to do it just by calculating distance and doing math, but changed to buffers when I realized I'd want to do that anyway for the areas.

challenge_197_EW.yxmd

markcurry

My solution

Spoiler

challenge_197_mark.yxmd

nivi_s

Solved!

Spoiler

Unfortunately without the TPS cover - even though I got the memo.

challenge_197_solved_NS.yxmd

RobertW

I feel like I could condense the split paths since it's the same...

Spoiler

challenge_197_start_file.yxmd

dho111

Spoiler

Having too much fun with Maps!

challenge_197_start_file_dho111.yxmd

sonyakasenkramer

Definitely working on spatial tools in the New Year. But I did it with minimal peeking.

Spoiler

challenge_197_TPS.yxmd

Laszlo_D

Challenge 197 Report Output5.pdf

challenge_197_solution_LD.yxmd

Challenge 197 Report Output5-8.pdf

TonyA

Happy New Year All!!!Knocked this one out on the plane coming back from vacation.

challenge_197_TonyA.yxmd

TonyA

Happy New Year All!!!

Knocked this one out on the plane coming back from vacation.

challenge_197_TonyA.yxmd

philipmannering

Took me a while... you see it's not that I'm lazy, it's that I just don't care

Spoiler

Challenge 197 - Customer Density Reporting.yxmd

Challenge 197 - Output.pdf

SueDonim

Sorry, no flair for me. The boss says he's going to need me to come in on Saturday and he's going to need me to go ahead and come in on Sunday too.

Spoiler

Process
- Create spatial points
- Create trade areas
- Append 5 and 8 mile trade areas
- Find the outer ring (5-8 mile trade area) using spatial process tool
- Find customers where target touches or intersects universe (the trade areas)
Repeated process for both 0-5 and 5-8 miles....
- Calculate trade area in square miltes
- Summarise (group by customer segment and area count number of customers
- Calculate customer density
- Sort and clean-up
- Create and render table as pdf

challenge_197_SueDonim_Solution.yxmd

Naledi

Never knew that you could make multiple trade areas just by separating them with a comma! Great tip, thank you.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703