This repository contains analytical materials supporting a synthetic cohort modeling project examining seminary formation attrition dynamics through rule-based data generation, institutional segmentation analysis, and dashboard reporting.
Because publicly available individual-level seminary formation microdata are generally unavailable, the project uses synthetic observations designed to simulate plausible institutional trajectories while maintaining explicit methodological constraints.
The project was developed as a descriptive institutional-analysis exercise focused on:
- synthetic cohort construction
- rule-based variable generation
- segmentation analysis
- dashboard reporting
- structured analytical documentation
- institutional-process modeling
The framework is descriptive rather than predictive and does not represent real seminarians, institutional personnel records, or empirical population estimates.
Repository contents are organized as standalone analytical deliverables and supporting files.
Primary project materials include:
-
01_Executive_Memorandum.pdf
High-level overview of project purpose, analytical framing, findings, and interpretive limitations. -
02_Methodology_Memorandum.pdf
Documentation of analytical logic, variable construction, segmentation framework, and workflow design. -
03_Technical_Appendix.pdf
Detailed technical materials supporting synthetic cohort construction, variable operationalization, validation procedures, and implementation logic.
-
Seminary_Attrition_FinalDataset.csv
Final synthetic cohort dataset. -
Seminary_Attrition_Workbook.xlsx
Structured workbook used for synthetic data generation, validation review, and analytical development. -
Seminary_Attrition_Codebook.pdf
Variable definitions, coding structure, typology logic, and methodological notes.
-
Seminary_Attrition_Dashboard.pbix
Power BI implementation file. -
Seminary_Attrition_Dashboard.pdf
Static dashboard export and reporting view.
Supporting_Resources.zip
Supporting literature, seminary enrollment reporting, ordination reporting, attrition literature, and institutional reference materials used to inform methodological assumptions.
Primary objectives included:
- synthetic cohort dataset construction
- operationalization of qualitative institutional concepts
- institutional segmentation analysis
- dashboard-oriented reporting
- descriptive analytics workflow development
- validation review procedures
- structured methodological documentation
The project emphasizes:
- systems reasoning
- structured analytical workflows
- institutional modeling
- transparent methodological constraints
- descriptive reporting implementation
TOOLS AND METHODS
Primary tools and methods used include:
- Microsoft Excel
- Google Sheets
- rule-based synthetic data generation
- conditional spreadsheet logic
- pivot-table validation review
- descriptive segmentation analysis
- Microsoft Power BI
- DAX-based label formatting
- technical analytical documentation
Reviewers seeking a high-level overview should begin with 01_Executive_Memorandum.pdf.
Reviewers seeking implementation details should consult 02_Methodology_Memorandum.pdf and 03_Technical_Appendix.pdf.
Technical variable definitions and dataset structure are documented in Seminary_Attrition_Codebook.pdf.
Dashboard reporting materials are available in Seminary_Attrition_Dashboard.pdf, with the editable Power BI implementation contained in Seminary_Attrition_Dashboard.pbix.
Supporting literature and reference materials are contained in Supporting_Resources.zip.
This project uses entirely synthetic data generated through rule-based logic structures informed by published aggregate reporting, seminary enrollment reporting, ordination summaries, and qualitative attrition literature.
No real seminarians, institutional personnel files, confidential records, or individual evaluations are represented.
The repository is intended solely as a methodological and analytical demonstration artifact supporting institutional modeling, descriptive analytics, segmentation reporting, and dashboard implementation.