• Victory Family Centre’s data analysis initiative encompassed these key elements:
  • Data Source: JSON files served as the primary source of attendance data.
  • Technology Stack: Advanced Query and GraphQL were chosen for data analysis and extraction.

For the data collection and integration aspect of their project, Victory Family Centre implemented the following processes:

1. Data Source – JSON Files: The primary data source for this project was JSON (JavaScript Object Notation) files. These files contained detailed records of member attendance for each community group’s meetings. JSON is a widely used data format for storing and exchanging structured data. Victory Family Centre collected attendance data in these JSON files, which served as the central repository for their analysis.
2. Data Analysis with Advanced Query and GraphQL: To extract and analyze data from the JSON files, Victory Family Centre employed Advanced Query and GraphQL. These technologies facilitated the extraction of attendance data efficiently and allowed for in-depth analysis. Advanced Query and GraphQL served as the bridge between the raw data stored in JSON files and the creation of informative dashboards.

• Member Attendance Patterns
• Attendance Data Visualization
• Total Attendance Insights
• Average Attendance Analysis
• Total Visitors Evaluation
• Total Returning Visitors Assessment
• Enhanced Community Engagement Strategies

• Advanced Query: Advanced Query is a powerful data analysis tool that allows users to query and extract data from various sources, including JSON files. It provides the capability to perform complex data analysis operations, filter data, and generate reports based on specific criteria. Victory Family Centre used Advanced Query to retrieve attendance data efficiently and perform in-depth analysis.
• GraphQL: GraphQL is a query language for APIs (Application Programming Interfaces) that enables efficient data retrieval and manipulation. It provides a more flexible and efficient approach compared to traditional REST APIs. Victory Family Centre utilized GraphQL to interact with their attendance data stored in JSON files. GraphQL allowed them to specify exactly what data they needed and retrieve it in a structured manner, making data extraction and analysis more streamlined and effective.

• Data Extraction: Advanced Query and GraphQL were utilized to efficiently extract and analyze data from JSON files.
• Dashboards: Interactive dashboards were meticulously designed to allow users to explore data, identify trends, and gain insights.
• Attendance Patterns: Tracking Total Attendance and Average Attendance patterns enabled a better understanding of member engagement.
• Visitor Analysis: Insights into Total Visitors and Total Returning Visitors shed light on the effectiveness of community engagement initiatives.

• Data Integration: Connecting Power BI to the PostgreSQL database required the establishment of appropriate database connections and queries, which were efficiently managed.
• Data Security: Strict adherence to data security standards ensures the protection of sensitive business information.
• Customization: Power BI reports were thoughtfully tailored to meet QI Spine’s specific business metrics and objectives, ensuring that the reports aligned with their strategic goals.

Victory Family Centre successfully utilized data analysis tools such as Advanced Query and GraphQL to gain valuable insights into member attendance patterns across various community groups. This initiative empowered the church to make data-driven decisions to enhance community engagement.

The interactive dashboards provided insights into Total Attendance, Average Attendance, Total Visitors, and Total Returning Visitors. This data analysis project exemplifies the power of data-driven decision-making in optimizing community engagement strategies within a church setting, fostering a sense of belonging and spiritual growth among its members.