Challenge #43: Inspire Europe '16 Grand Prix (L2)

The link to last week’s challenge (challenge #42) is HERE

As a follow on from last week’s challenge here is the second lap of the Inspire Europe Grand Prix. Keep in mind that the participants only had 10 minutes to complete the race. Fasten your seatbelt and give it a try.

challenge_43_start_file.yxzp

challenge_43_solution.yxzp

Parse

Join

Spatial Analysis

Preparation

Advanced

Data Analysis

Intermediate

Spatial

Accepted answers

All comments

brianprestidge

Definately a case of 'make sure you read the question a couple of times on this one'! Nice!

Spoiler

My Answers

Screen Shot 2016-09-26 at 20.08.40.png

Answers:

LS8 (1385 Casulaties)
36.8442%
0.951%

TaraM

A solution has been posted

Spoiler

2016-10-03 09_04_20-Alteryx Designer x64 BETA - Race 2_question_Solution.yxmd.png

brianprestidge

Hi Tara

FYI - in your answer box in the solution workflow for % of accidents after 1st Sept 2015 you have 36.69% But in you workflow the results in the browse tool show 36.84% (same as mine).

Brian

GeneR

Thanks for letting us know @brianprestidge, Must be my fat fingers typing in the answer.

Gene

brianprestidge

My Pleasure - I reckon you were just testing if we checked the solution :-)

TaraM

thanks @brianprestidge. I dub you "Eagle Eye"

Eagle Eye

brianprestidge

Oooh, i quite like that - think i may have found a new avatar :-)

SeanAdams

Very similar solution to others

challenge_43_SeanSolution.yxmd

NicoleJohnson

My solution... Cheers!

Spoiler

challenge_43_NicoleJohnson.yxmd

estherb47

challenge_43_EHB_solution.yxmd

LordNeilLord

Solution

Spoiler

challenge_43_LNL.yxzp

nick_ceneviva

Solution attached and Answers Below:

Spoiler

1. LS8 with 1385 accidents
2. 36.84423 %
3. 0.95017 %

challenge_43_Ceneviva.yxmd

jamielaird

Here's my solution. The start file didn't contain any text inputs for the solutions so I've included them in each browse tool.

Spoiler

challenge_43_JL.yxzp

patrick_digan

Since I had unmatched records, I decided to use the whole dataset to answer questions where the postcode wasn't needed.

Spoiler

challenge_43_start_file.yxmd

Natasha

Solution

Spoiler

challenge_43_Natasha.yxmd

JoshKushner

I decided to spatial match where it touches or intersects a postal code area. (I'm a generous politician)

challenge_43_start_file.yxzp

samN

Looks like i did very similar things to many others.

challenge_43.yxmd

ggruccio

I had a few reccords that didn't match spatially in step 1...included them in the remaining steps....

challenge_43_gg_finish.yxzp

philipmannering

Second lap. Solution attached.

Spoiler

challenge_43 - Grand Prix 2016 L2.yxzp

LandonG

Solution attached.

challenge_43_start_file.yxzp

jasperlch

Solution attached.

challenge_43_JL.yxzp

msicak

misunderstood the last question and wanted to overcomplicate it. oh well, I'd probably make it on time otherwise.

Spoiler

challenge_43_MS.yxmd

dominiklz

Spoiler

this one took me a bit longer, I thought it was way more difficult than it actually as and started from scratch after a bit

challenge_43_Dominik.yxmd

dsmdavid

Count records, count them all. Though took me just a tad more than the 10 mins.

Spoiler

solved#43.yxzp

JosephSerpis

Challenge Completed

Challenge_43_Joe_Serpis.yxmd

data_rachel

Spoiler

Like others, I assumed questions 2 and 3 related to the full data set.

My solution

Here is my attempt; quite different to the posted solution - good to know the count records tool!

challenge_43_LB.yxmd

daniel_ferreira

Follow my solution file attached...

challenge_43_solved.yxmd

asabau

Nice one!

challenge_43_date filtering_file.yxmd

KOBoyle

Solution attached.

challenge_43_solution_KO.yxmd

yajing_wang

Spoiler

Spoiler:

challenge_43_my_way.yxmd

Abiramm1

@TaraM I ended up getting 36.69% and it's because after part 1, I reintroduced all the rows that didn't match to a postcode area since I presumed not having a postcode area didn't make it not in Leeds.

Just some food for thought

Weekly challenge 43 solution.yxmd

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335