Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #145: SANTALYTICS 2018 - Part 1

Highlighted
Alteryx Community Team
Alteryx Community Team

santalytics-2018-badge_small.png

We're excited to introduce the first part of our annual #SANTALYTICS challenge — an all-inclusive, non-denominational, secular, festive excuse for some friendly competition using Alteryx.

If you are just checking out Santalytics for the first time, please read the announcement blog for the inside scoop: #SANTALYTICS 2018

 

SANTALYTICS 2018 - Part 1

 

In the spirit of the season, the Community team would like to donate to a local Colorado charity and we need your help! In today's challenge, you'll help us find a worthy charity, and in next week's part II, you'll help us determine exactly how to spend the money.

We need you to analyze publicly available IRS data. There are three key datasets:


Blend and analyze the data to determine which charity we will donate to given:

  • It needs to be in Colorado (see State field)
  • It should benefit people (see Grants to individuals? field)
  • They should actively be raising funds (see Fundraising activities? field)
  • We should be allowed to donate items, not just cash (see Deductible non-cash contributions? field)
  • The charity should be small and flying under the radar (Number of employees < 300; Advertising and promotion < $1,000)
  • But making a big impact (Total contributions > $5,000,000)


Once you've narrowed down the list based on the above criteria, rank the remaining charities based on fundraising efficiency and select the top charity! (see Fundraising expenses and Total contributions fields)

 

Extra credit: Come up with your own ranking criteria to identify a worthy charity in your neck of the woods!

 

2018-12-17 update: our particular solution here.

Highlighted
16 - Nebula
16 - Nebula

I've selected...

Spoiler
A Precious Child Inc.

Capture.PNG
Highlighted
14 - Magnetar
14 - Magnetar
Spoiler
Part I = Complete! Here are the top charities that I found using the given criteria.
Capture1.PNG
Highlighted
11 - Bolide

Cheers!

Spoiler
Here's my solution. Also, I had to download a different dataset from the IRS website. I think the one that links is the "Form 990 EZ Extract" and the one I had to use was "Form 990 Extract".
Challenge_145.PNG
Challenge_145_1.PNG
Highlighted
14 - Magnetar
14 - Magnetar

'Tis the season for my favorite analytics challenges!!! My solution for Part 1...

 

Spoiler
WeeklyChallenge145.JPG

NOTE: I had to connect to the Form 990 file directly from the IRS website since the one linked as the "download Form 990 Extract here" link appears to be the EZ version, which doesn't have the fields we need... 🙂

 

Cheers!

NJ

Highlighted
Alteryx Community Team
Alteryx Community Team

Thanks @JoBen & @NicoleJohnson I've fixed the link!

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

My solution!

Highlighted
8 - Asteroid

Here are my top 3

 

gif_temp.gif

 

 

Spoiler
Challenge_145_Spoiler.JPG
Highlighted
6 - Meteoroid

A good exercise.  

Highlighted
7 - Meteor

So here it is. I got a little hung up on the calculation for Average Fundraising Efficiency since its across 3 years and from what I could see in the data only 2 non-profits had that much data. I pulled in 3 years worth of data from the IRS site and bucketed the averages from there. I'm still learning Alteryx so I'm sure there may be some errors in my tool use but I wanted to get this out there.

 

Based on my data I would select Denver Scholarship foundation. 

 

Also, I did have issues with the IRS dataset not showing the correct fields for the challenge so I downloaded the correct one directly from the site.

Spoiler
Santa Part 1.JPG