Now I Lay Me Down to Sleep is seeking to enhance its data reporting capabilities by developing a one-click reporting system for key performance metrics. The company has already created a template and wireframe for the report, but currently lacks the integration of data into this framework. The goal of this project is to enable seamless data flow from the existing database into the pre-designed report template, allowing for efficient and accurate performance analysis. This project provides an opportunity for learners to apply their knowledge of database management, data integration, and user interface design. The tasks involved are closely related and can be completed by a team of learners specializing in information technology or computer science. The project is designed to be completed within 120 hours, ensuring a focused and manageable workload.

The primary deliverable for this project is a fully functional one-click reporting system that integrates key performance metrics from the database into the existing report template. Additional deliverables include documentation detailing the data integration process, a user guide for operating the reporting system, and a presentation demonstrating the system's functionality. The project will culminate in a final report summarizing the outcomes and any recommendations for future improvements.

We would like to get this dashboard up and running so we do not need to rely on manual data analysis and reporting. We currently have 33,185 user records and 70,433 session log records (our deliverable to families). We will work with the development resources to grant access to our github repo and web application staging environment (all which lives in our AWS cloud environment) and any other internal tools/resources necessary.

The below is an initial summary but further specs are in the attached Tech Specs document (https://docs.google.com/document/d/1YwkO9jFknETCWLjY4sTYAIq73AH7mlg-LZIOv6W6xGI/edit?tab=t.0#heading=h.dvf234tkceeu) "smartCard-inline")

Overall Stat Chart, Monthly, Year to Date and Custom Period:

total sessions

average sessions per active photogs (sessions/photogs who actually logged)

volunteers EOY

total # of photogs

% photogs shooting sessions

number applications

number approvals

Target Cities Reports for Monthly, Year to Date and Custom Period

increased volunteer base by %

Sessions taken vs not taken

percent increase of accepted sessions

Volunteer Stat Chart (data count for each role) Monthly:

Interested

Pending Review

Declined

Approved Pending VSA/Dues

In Training

Active

On Break

Removal Requested

Bad Email

Expired

Suspended

Training:

Active Photographers with completed Affiliated Photographer training

Active Digital Retouch Artists with completed DRA training

Active Area Coordinators with completed AC training

For Area Coordinators, they should see ONLY their area statistics.

Point in Time Stats:

graph of months and total photog sessions

graph of months and total retouch sessions

Applications Pending Review

Pie graph of active volunteers roles

volunteer map similar to this (if possible): https://www.google.com/maps/d/u/1/edit?mid=1Yj2dp3fFjCIrqxvAp3cnSSD1GNM

volunteers trained vs not complete by role (pull from talentLMS)

One Click Reporting

Logged Sessions for user input timeframe returning names instead of IDs and removing duplicates. Very basic sample without join for names or removal of duplicates:

SELECT photographer_id, dispatcher_id, assistant_id, dra_id

FROM sessionlogs

WHERE date_sent >= '2021-01-01' AND session_date >= '2020-07-01'

Anniversaries for user-specified date that returns all volunteer names and city, state, country with registration dates for that month.