DCLM Data Management System
A centralised reporting, analytics and performance-monitoring platform connecting local church reporting to divisional, regional, zonal and national oversight.
What it does
The DCLM Data Management System — developed as the DCLM Attendance Hub — supports data collection, consolidation and reporting across Deeper Christian Life Ministry, Ghana. It connects local church reporting with divisional, regional, zonal and national oversight, giving authorised users a common environment for managing ministry statistics. Attendance, membership, missions and programme reporting are brought into one application, with structured forms and validation controls supporting consistent submissions and dashboards providing visibility into organisational trends and outstanding reports.
The problem
Reporting across a large, multi-level organisation is only as reliable as the chain that carries it. When each level collects and consolidates its own figures, the national picture is assembled by hand, arrives late, and is difficult to verify. The problem was to give every level of the organisation one shared reporting environment — so a local submission, a divisional review and a national view all read from the same structured record rather than parallel spreadsheets.
What made it hard
- Reporting collected and consolidated separately at each organisational level.
- No shared structure for attendance, membership, missions and programme returns.
- National reporting dependent on manual aggregation of divisional submissions.
- Outstanding and overdue reports difficult to see before a deadline passes.
- Limited traceability of who submitted, reviewed or amended a record.
Problem analysis
- Modelled the reporting hierarchy directly in the application, so the organisational structure and the data structure are the same thing rather than reconciled afterwards.
- Separated capture from consolidation from analysis, so a submission can be validated at source while the national view remains consistent.
- Treated submission monitoring as part of the reporting surface rather than an afterthought — overdue returns are visible while there is still time to act.
- Designed access around the organisation's roles, so visibility follows responsibility and every record carries an audit trail.
Solution design
The platform is a React and TypeScript front end over a Python and FastAPI backend, with PostgreSQL as the system of record. Structured forms capture service attendance, membership, baptisms, weddings, retreats, crusades and workers' conferences, with validation applied at entry. Submissions are consolidated automatically through the organisational hierarchy, with drill-down views for reviewing individual reporting units. Dashboards surface organisational trends, submission rates and deadlines, and a strategic performance layer tracks selected five-year plan indicators — membership growth, convert retention, youth membership and children's attendance. Eight user roles, organisational access restrictions and audit records govern who can see and change what, and the application works across desktop and mobile browsers with Progressive Web App functionality.
- Client
- React and TypeScript application with responsive dashboards and Progressive Web App support for desktop and mobile.
- API layer
- Python and FastAPI services handling submission, consolidation, reporting and access control.
- Data layer
- PostgreSQL as the single system of record for attendance, membership, missions and programme data.
- Reporting engine
- Automatic consolidation through the organisational hierarchy, with drill-down into individual reporting units.
- Access and audit
- Eight user roles, organisational access restrictions and audit records over every submission and amendment.
- Analytics
- Dashboards for trends and submission monitoring, plus five-year plan indicator tracking.
Implementation
- Designed the application and database architecture around the organisation's divisional, regional, zonal and national structure.
- Built structured reporting forms for attendance, membership, baptisms, weddings, retreats, crusades and workers' conferences, with validation at entry.
- Implemented automatic consolidation and drill-down so each level can review the units beneath it.
- Built submission monitoring for completed and overdue reports, reporting rates and deadlines.
- Added strategic performance tracking for selected five-year plan indicators.
- Implemented eight user roles, organisational access restrictions and audit records.
- Developed the reporting workflows, analytical dashboards and implementation plan for a controlled pilot and phased deployment.
Key features
- Integrated reporting for attendance, membership, baptisms, weddings, retreats, crusades and workers' conferences.
- Automatic consolidation through the organisational hierarchy with drill-down views.
- Submission monitoring for completed and overdue reports, reporting rates and deadlines.
- Strategic performance tracking for five-year plan indicators.
- Eight user roles, organisational access restrictions and audit records.
- Desktop and mobile support with Progressive Web App functionality.
Results and impact
- A developed platform, proposed for institutional adoption through a controlled pilot and phased deployment.
- Replaces manual multi-level consolidation with a shared reporting structure and an audit trail.
- Gives leadership a timely, consistent view of ministry statistics for planning and monitoring.