Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #145: SANTALYTICS 2018 - Part 1

mbogusz
9 - Comet
Spoiler
God bless you Dynamic RenameGod bless you Dynamic Rename

 

viveknshah
8 - Asteroid
Spoiler
challenge_145_shvive.png

Ho! Ho! Hope for a better future for everyone! 

SueDonim
8 - Asteroid

First big dataset I've worked with.  Very cool - and soooo much easier than in Excel

 

Spoiler
Perhaps should have linked the data to the field names in Excel, but I sidestepped by searching for and renaming the relevant fields by hand.

Process:
- Filtered charity names for State (Field 4) = CO
- Filtered 990 data with flag from formula tool (combining criteria with ANDs to set prospect flag
- Joined data to names/addreses
- Calculated fundraising efficiency ratio and sorted the 3 final prospects

Yielding "A Precious Child Inc." as the winner.

MySolution.PNG
OllieClarke
15 - Aurora
15 - Aurora

I chose:

Spoiler
A Precious Child Inc.
challenge 145.png

n.b. the yxzp was too large to post, so I've gone for the workflow without files
Karam
8 - Asteroid

Nice one!

 

Spoiler
Challenge 145.PNG
RWvanLeeuwen
11 - Bolide

I narrowed it down to three candidates of which I manually selected one that I am most epathetic with:

Spoiler
Healthcare is my go to charity here :)Healthcare is my go to charity here :)
gracec97
8 - Asteroid
Spoiler
Challenge 145.JPG
danicahui
8 - Asteroid
Spoiler
Challenge 145 2019-12-06.jpg
nivi_s
8 - Asteroid

Solved!

 

Spoiler
nivi_s_0-1577492252952.png
apabonok
8 - Asteroid

Hello! This is my solution.

 

challenge_145_apabonok_spoiler.png