Gainesville Opportunity Center

The Gainesville Opportunity Center (GOC) is using R to create reports, including listings, summaries, billing data, email lists for solicitation, board reports, and graphics. These reports will be accessible from Flourish, the hosted GOC data system by Form Communities

A dashboard is being built using Shiny to organize reports and other data presentations from Flourish. The dashboard will be hosted by Form Communities.

Modules

The GOC has implemented 10 Flourish modules:

1. Members. Just Members. Prospects are in Contacts.
2. Contacts. All Members are contacts, but not all contacts are Members. Contacts include donors, volunteers, community partners, staff, and many others.
3. Gifts. All gifts, including in-kind.
4. Attendance. All attendance, including staff, visitors, and volunteers.
5. Outreach. Outreach to Members.
6. Employment. One record per "employment" -- start/end with a specific employer. Employers are in Contacts.
7. Supports. One record per support -- Members and a Staff Member participating in a clubhouse activity.
8. Goals and Plans. One record per goal with associated plan. Members have multiple goals.
9. Progress Notes. One progress note per month per goal.
10. Users. The users of the system, including access roles.

Dashboard

The GOC Dashboard has 3 widgets, 49 reports, 8 plots, 10 table viewers, 1 technical figure, and 11 downloads.

Some highlights:

• Members with staff assignments showing attendance, supports, goals, and progress notes
• Sign in sheets, attendance and outreach reports
• Donations by year, campaign, top donors
• Billing reports for grants
• Payroll reports for staff
• Productivity reports
• Board reporting
• System information including database record counts, and field usage by table