search

edgi-govdata-archiving / fiscal

Monetary flows within EDGI and visualizations of how money moves through the organization
0 stars 0 forks source link

Create overview visualization of EDGI money flow #1

Open shapironick opened 7 years ago

shapironick commented 7 years ago

edgi finances overview 9 2

Here is an initial image of how money moves through EDGI.

I created it using draw.io and here is the current xml

shapironick commented 7 years ago

to do: add in LD and UCSC as direct support for C & G. Also maybe segregating between AB, TR and RB's work as one is squarely web monitoring and the other two are largely web monitoring but also seemingly some C&G work (related to FIOA).

dcwalk commented 7 years ago

This is super cool! (and was really illuminating for me)

Thoughts on visualization:

And then a couple questions: -what does green text v. red for dollar amounts mean? -Is "Public Lab Total" the amount that has gone through PL? (if so maybe there is a word other than 'total' to represent that?)

shapironick commented 7 years ago

Thanks @dcwalk for the great feedback! I've tried to respond to all of your feedback in this current version. Does this seem ok? edgi finances overview 9 5 1 2

Here is the file. you can just upload it to draw.io to make changes as well.

Blackglade commented 7 years ago

just a suggestion, but instead of making a dynamic javascript visualisation, it might make more sense to just display all this info on a page and vastly simplify it... like a live updating infograph.

Something along the lines of THIS. It would be much easier to maintain and update.

dcwalk commented 7 years ago

Good point @Blackglade !

Maybe eventually we could set up a static page like we do for the 100 days report (e.g., fiscal.envirodatagov.org), though if it is static it will be much easier to have on the wordpress site (e.g., `envirodatagov.org/fiscal) I'm going to move this convo to a new issue tho, as I am getting ahead of myself and I think it would be good to iterate on display here?

dcwalk commented 7 years ago

there-was-an-attempt

I was procrastinating and gave it a go. Just realized that draw.io allows saving to GitHub, why don't we store the drafts in here? I've opened a PR with my version so there is access to that file while we iterate, but please @shapironick add yours in if I've gone too far down a tangent

shapironick commented 7 years ago

Oh this is is great @dcwalk ! thanks for the sprucing and clarifying. I think it would be ideal to also have disclosure of scale of payments made by collaborators like TRU, USC, QRI etc for this to be complete. I'm going to also try to add individual donations on there as well.

Great that you initiated the PR. i wasn't sure of the security issues involved in giving draw.io access to my account and our repo so was holding off on doing the pr. but glad that seems ok!

Also thanks @Blackglade thats a really nice example and something to work towards. right now i think the primary audience for this is internal as most people just didn't know how money was distributed, and so that we could make better decisions about where we spend money. then i think something like that static viz would be perfect going forward!

shapironick commented 7 years ago

financial-overview 1

Here is the latest. I'll present it tomorrow at the weekly meeting.

shapironick commented 7 years ago

Stephanie noted on the phone just now that we should note where reoccurring costs lie. It may be complicated as most costs are not disambiguated like in the administrative section.

dcwalk commented 7 years ago

agreed! I'm wondering if we want something like source data #2 to cover that, and then make these sort of static visualizations aggregate? (i.e., this says "July 2017" so I'm assuming this is total costs until then) I think we'd need a separate visualization to just capture monthly flows?

shapironick commented 7 years ago

yay @sknutson47 just joined GitHub!