DARIAEngineering / dcaf_case_management

Rails-based case management system for abortion funds
MIT License
87 stars 243 forks source link

CMD Reporting MVP #634

Open mebates opened 8 years ago

mebates commented 8 years ago

Real time reporting for the Case Manager Directors.

Notes from user interviews: https://github.com/colinxfleming/dcaf_case_management/wiki/Data-Reporting-Management-notes

Need to work to define the MVP based on the data we're currently collecting, then perhaps a second release after we have full budgeting functionality. Go team!

mebates commented 8 years ago

@mjrich check out our first hit at reporting needs! can datakind help?

mebates commented 8 years ago

First stab at a very-very MVP "DCAF Data Center", based on data I know we can immediately display. Obviously the MD and VA values will be "null" until we start those call lines. We have a lot more reporting to display, so we'll probably have to work in some navigation options.

dcafwireframe091316_data center

Patients Contacted = each unique patient to which one call was made, even if we didn't reach them New patients Contacted = each new patient to which a first call was made, even if we didn't reach them

Do you like the name "Data Center"? Any other ideas? Other thoughts on the layout?

lwaldsc commented 8 years ago

I love this so much!

Is there a way to add a CM's personal stats in there as well?

Something like DC/MD/VA/You

I know that's something a couple CMs have mentioned wanting to have and something we've briefly mentioned in the past.

On Tue, Sep 13, 2016 at 10:14 PM, Mollie Bates notifications@github.com wrote:

First stab at a very-very MVP "DCAF Data Center", based on data I know we can immediately display. Obviously the MD and VA values will be "null" until we start those call lines. We have a lot more reporting to display, so we'll probably have to work in some navigation options.

[image: dcafwireframe091316_data center] https://cloud.githubusercontent.com/assets/6223901/18497755/21fcaa76-79ff-11e6-917a-a57bc1ef6d6b.png

Patients Contacted = each unique patient to which one call was made, even if we didn't reach them New patients Contacted = each new patient to which a first call was made, even if we didn't reach them

Do you like the name "Data Center"? Any other ideas? Other thoughts on the layout?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/colinxfleming/dcaf_case_management/issues/634#issuecomment-246885343, or mute the thread https://github.com/notifications/unsubscribe-auth/AKFqsOE8vDVr1V8hTmvCGYfoyc1at2XSks5qp1h7gaJpZM4J8TUq .

NerdyGirl537 commented 8 years ago

This looks great. A quick question about the "new patients contacted": is that counting all the callers entered in the CM App? If not, I'd love to see a summary of how many calls came in during the week.

Also, I noted that this is for the CMDs. Would it be available for the CMs?

For naming, perhaps "Call Line Summary"?

And just a random note for realism: we usually send between 6 and 12 pledges a week.

lwaldsc commented 8 years ago

Ahhhhhhhh I missed that it was for the CMDs only. I do think the CMs would like a version of this though, including their own personal stats. Maybe not as detailed? Not an urgent request, obviously, but something nice if the coding isn't difficult.

On Wed, Sep 14, 2016 at 11:18 AM, NerdyGirl537 notifications@github.com wrote:

This looks great. A quick question about the "new patients contacted": is that counting all the callers entered in the CM App? If not, I'd love to see a summary of how many calls came in during the week.

Also, I noted that this is for the CMDs. Would it be available for the CMs?

For naming, perhaps "Call Line Summary"?

And just a random note for realism: we usually send between 6 and 12 pledges a week.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/colinxfleming/dcaf_case_management/issues/634#issuecomment-247048477, or mute the thread https://github.com/notifications/unsubscribe-auth/AKFqsITwTUl_KnKgMpkpEO7md33oIwz-ks5qqBBHgaJpZM4J8TUq .

colinxfleming commented 8 years ago

Making a quick note before I forget to make sure we account for the info that nnaf asks us for every year

On Wed, Sep 14, 2016, 11:20 AM Lisa notifications@github.com wrote:

Ahhhhhhhh I missed that it was for the CMDs only. I do think the CMs would like a version of this though, including their own personal stats. Maybe not as detailed? Not an urgent request, obviously, but something nice if the coding isn't difficult.

On Wed, Sep 14, 2016 at 11:18 AM, NerdyGirl537 notifications@github.com wrote:

This looks great. A quick question about the "new patients contacted": is that counting all the callers entered in the CM App? If not, I'd love to see a summary of how many calls came in during the week.

Also, I noted that this is for the CMDs. Would it be available for the CMs?

For naming, perhaps "Call Line Summary"?

And just a random note for realism: we usually send between 6 and 12 pledges a week.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub < https://github.com/colinxfleming/dcaf_case_management/issues/634#issuecomment-247048477 , or mute the thread < https://github.com/notifications/unsubscribe-auth/AKFqsITwTUl_KnKgMpkpEO7md33oIwz-ks5qqBBHgaJpZM4J8TUq

.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/colinxfleming/dcaf_case_management/issues/634#issuecomment-247049280, or mute the thread https://github.com/notifications/unsubscribe-auth/ADsA9KvPIr0zdijGTdrFpB7xjUVbfOPUks5qqBDSgaJpZM4J8TUq .

colinxfleming commented 8 years ago

Dug through my email and couldn't find them, so kicked them on to the board. In a nutshell, there's some stuff we need to report on for the annual report and to NNAF (stuff like 'how much got spent', 'how many patients', basic counts and crosstabs). I think a serious way to drive wider adoption might be to roll some of this stuff in early. (I'm also curious as to how much crossover there is.)

colinxfleming commented 8 years ago

The annual report is here. Probably none of this is relevant for a CMD dash, though, so I'll move it to another issue.

mebates commented 7 years ago

I'll take a look at the annual report data to see if there's anything we can incorporate. We prioritized weekly reporting needs for MVP, per these notes.

Though the target audience for this is CMDs, I discussed with the group that anyone would be able to see this screen, so I don't mind the idea of adding 'you' column under the "Past 30 days" and "Year to Date" headings. I like "Call line summary" for a title @NerdyGirl537 !

colinxfleming commented 7 years ago

Spun building the basic view into its own form so we can whip up a frame quick!

yudonoodles commented 7 years ago

Hi all,

I'm attaching two wireframes I made for the Call Line Summary Page. I annotated the wireframes, let me know if you want clarification on those. I can do more based on your feedback. I am presenting two options for the page.

Option 1 fullsizerender

Option 2 fullsizerender 2

I wasn't too sure about what you were imagining for the budget bar, I put in a tracker of sorts that could go either above or below the data cards/modules.

mebates commented 7 years ago

Hi Serena - Nice work! I'm liking Option 1 best. When we last talked, I remember there being additional info that we were trying to pull into reporting, and we were trying to figure out how the information architecture might change because of that. Do you recall?

I think the dropdown with date ranges is great and will be very helpful to the team.

Don't worry about the budget bar; we have requirements for that documented elsewhere.

colinxfleming commented 7 years ago

paging @lapolonio to this -- if you aren't too deep on chartkick stuff (I'd still REALLY like to have that around) there's a bit of meat here! We can put this in our current reporting endpoint I think.

colinxfleming commented 6 years ago

Spinning this into a frontend task and promoting it to active, I think it's shovel ready.

colinxfleming commented 6 years ago

Marking futuretech since there's already a limited implementation of this in place.

colinxfleming commented 6 years ago

I'm going to start moving reporting related tickets into here.

colinxfleming commented 6 years ago

Per https://github.com/DCAFEngineering/dcaf_case_management/issues/1095 we should explore chartkick as a simplified library for graphs; we should also move the loads to be async actions if we haven't already.

colinxfleming commented 6 years ago

Reports requests that have come in so far via #877 :

1) Fulfillment rates by state
2) Fulfillment rates by clinic

We should also look into being able to autopull figures from DCAF annual reports, which line up with what NNAF asks from everyone. That's available at http://dcabortionfund.org/wp-content/uploads/2016/02/DCAF_Annual_Report_2015.pdf . There's a WIP PR at colinxfleming#966.

There's also some interest in number of calls over a given day, to figure out when things are heavier than what a CMD can handle on their own.

colinxfleming commented 6 years ago

Per #1201 :

The code lives in app/lib/reporting/patient.rb -- specifically, the first three methods in there. (The bottom three are more speculative/unimplemented shots at using mongoid's mapreduce.)

colinxfleming commented 4 years ago

This came up within the working group. @SerenaYudon 's option 1 should still be the central goal we're trying to implement here to start, but I'm increasingly agnostic on whether this should be in the rails service. Maybe we swap to postgres and then become a Mode Analytics client and embed dashboards? Maybe we stand up that shiny server or similar? Maybe we take advantage of that buckwild mongodb built-in mapreduce? Or maybe we start building day's activities as part of nightly cleanup and saving them in mongo? Lots of options, none of them clear, but we should put some time into this over the next year.

colinxfleming commented 3 years ago

We're on postgres now. Should we try and just set up an embeddable mode analytics dashboard?

colinxfleming commented 2 years ago

@alimortell2 I'm interested in your professional opinion here - can you take a gander at https://github.com/DARIAEngineering/dcaf_case_management/issues/634#issuecomment-322071974 (specifically, option 1) and tell me what you think? Do you feel like this is something where an embedded data studio report would work well, or is the complexity level here too high and we should do this natively within app instead? (Please hmu with questions!)

alimortell2 commented 2 years ago

This mockup should definitely be doable in Google Data Studio! I know it would work in Periscope and Tableau, so I'm pretty confident that GDS would be the same.

The bigger pain, as always, is the underlying state of the data and transforming it to be aggregated correctly by GDS, but I imagine that'd be the case within the app too. Is all of the data you need for this report already syncing into a database that can hookup to GDS?

On Sat, Dec 4, 2021 at 6:20 PM Colin @.***> wrote:

@alimortell2 https://github.com/alimortell2 I'm interested in your professional opinion here - can you take a gander at #634 (comment) https://github.com/DARIAEngineering/dcaf_case_management/issues/634#issuecomment-322071974 (specifically, option 1) and tell me what you think? Do you feel like this is something where an embedded data studio report would work well, or is the complexity level here too high and we should do this natively within app instead? (Please hmu with questions!)

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/DARIAEngineering/dcaf_case_management/issues/634#issuecomment-986111392, or unsubscribe https://github.com/notifications/unsubscribe-auth/AUX6OI7CAQ2ECWENN2S4LEDUPKO2PANCNFSM4CPRGUVA . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

colinxfleming commented 2 years ago

The data model is basically patient in the center, with a bunch of things related to that. I think (hope) it's fairly sensible!

I think for this you can generally ignore things that are not Patient or related to it. We also have a data dictionary at https://github.com/DARIAEngineering/dcaf_case_management/blob/main/docs/DATA_DICTIONARY.md though it might be a smidge out of date.

I'll hook up a postgres sync for you shortly.

colinxfleming commented 2 years ago

nevermind it's gonna take a bit, takes some cert generation magic to sync into data studio it looks like. Stay tuned.

colinxfleming commented 2 years ago

(also the data dictionary is actually the export, sorry - take a look at https://github.com/DARIAEngineering/dcaf_case_management/blob/main/db/schema.rb which is basically the create table statements)

colinxfleming commented 1 year ago

okay, this is shovel ready. @alimortell2 this is ready to go! I'll work with you to get you credentialed in googly cloud.

colinxfleming commented 1 year ago

if I can figure out what kate d's github is I'll cc her on this too, she expressed some interest in working on this