Challenge #145: SANTALYTICS 2018 - Part 1

[TylerNa]

Part 1 completed. Looking forward to next week.

Spoiler

[Verakso]

Here is my findings, it was fun to apply some of that knowledge I have gained over the year, so here is my shot at it

Spoiler

Santalytics workflow and findingsWhen I read the documentation on the calculation of the Fundraising Efficiency, then is is described as the "charity's fundraising efficiency by determining how much it spends to generate $1 in charitable contributions" which in my mind means that the lower that number is, the better, and that's why I have listed the three charities this way

Since we where suggested to come up with our own ranking criteria, then I also took a look at travel, which I believe is travel cost,

If we look at advertising, the I think it also would make sense to look at travel (cost), and choose a charity, that spend less on this,

I am just saying, it we took travel into the list of criteria, then the above list would change.

Happy Holidays

/Thomas.

[calampert]

Here's my solution: 

[Inactive User]

My Solution

[PeterP]

Spoiler

Here's my solution with a festive theme. :)

[mbarone]

Here is our solution from the Rochester, NY User Group!

[kelly_gilbert]

My results are similar to most of the others:

Spoiler

When looking at my own state (Georgia), I was surprised that three of the four organizations meeting the criteria had $0 in advertising and promotion expenses.

  

My solution workflow:

Spoiler

Since some organizations had more than one 990 filed in 2017, I used the most recent tax period for each EIN. This did not affect the results for Colorado.

[ultrarunner]

I didn't know Dynamic Rename could do so much until I checked the spoilers. I revised my original workflow to adopt Dynamic Rename. It is not 100% mine, but it is a good learning experience. I can't wait for the next challenge!

[AJauniskis]

Part 1 done. Looking forward to the next one.

Spoiler

[jwlong91]

Fun challenge!  I decided to make an analytic app that allows a user to select the State they would like to see charitable organizations for that meet the criteria listed in the challenge.

Spoiler