Membership Bio-Data Dashboard

Project Title

Membership Bio-Data Analysis & Dashboard

Project Objectives

• To analyze the membership bio-data of Celebration Church International (CCI) Mararaba Campus.
• To uncover trends, patterns, and areas of improvement within the community.
• To build a clear and simple dashboard that tells a data-driven story and aids decision-making.
• To recommend strategic initiatives for deeper engagement and community growth.

Dataset Used

CCI Mararaba Membership Bio-Data

Key Questions Explored

• What is the gender distribution among CCI Mararaba members?
• Which MAP Groups have the highest membership?
• What is the age distribution across the congregation?
• How many members are active in service units?
• Which service units have the most members?
• Where do most members reside?
• What percentage of members are married?
• How can engagement be improved across different demographics?

Process

• Data Cleaning and Preparation
• Removed blanks and standardised category names.
• Handled missing data entries.
• Data Analysis
• Grouped members by Gender, Age Group, Residential Location, Service Unit, and MAP Group.
• Performed aggregation to find counts and percentages.

Dashboard Building

• Used Microsoft Excel for visual storytelling.
• Created charts (bar, pie, stacked column) and KPIs (total members, gender split, marital status).
• Insights and Recommendations.
• Analyzed trends to guide proposed action steps.

Dashboard Preview

Recommendations and Insights

• Gender Imbalance: There are significantly more female members than male members.

➔ Host male-focused events like Men’s Hangouts, sports tournaments, and mentorship programs.

• Service Unit Participation: A large number of members are not in any service unit.

➔ Launch quarterly skill discovery events and active service unit onboarding drives.

• Geographical Clustering: Most members reside in Mararaba, Karu, Nyanya, and Jikwoyi/Kurudu.

➔ Prioritize outreach and community bonding activities in these areas.

• MAP Group Engagement: Mararaba MAP Group has the highest membership.

➔ Introduce inter-MAP competitions to foster healthy competition and bonding.

• Young Demographics: Most active members fall between ages 18 — 30.

➔ Develop youth-focused initiatives such as leadership workshops, tech training, and entrepreneurship events.

Conclusion

This project provided valuable insights into the structure and demographics of CCI Mararaba members. The analysis highlights opportunities for targeted engagement strategies to foster stronger community participation, nurture talents, and drive overall growth.

The dashboard serves as a dynamic tool for leadership to make informed, data-driven decisions.