Case study
Streamlining Operations for a Statewide Vocational Education Association
An association running professional development, events, membership, and extended-campus coursework for educators across an entire state, on a stack of spreadsheets and manual steps.
- Sector
- Education and membership associations
- Engagement
- Multi-semester operational modernization
- Platform
- Microsoft 365, SharePoint, Power Automate, Power BI, Cognito Forms
- Scope
- Registration, finance, reporting, web content, and security
Background
The Problem
The association manages professional development, events, membership, and extended-campus coursework for educators statewide. Every semester brings registration windows that have to open on time, pricing tiers that vary by member status, cohorts that need tracking, and instructor reimbursements that need paying.
Most of that was running on manual steps and spreadsheet hunting, which made routine operations slow and reporting unreliable. This was not a single project but an engagement sustained across multiple semesters.
The work
What We Delivered
Semester and Event Registration
- Prepared and launched the spring semester registration page and ensured the registration experience was live on time.
- Updated planning-retreat registration forms covering dates, pricing tiers, role taxonomy, and school lists, returning final links for staff review before publishing.
- Implemented nomination, application, and response forms for leadership programming, with controlled closure windows to cap submissions.
- Delivered dynamic pricing logic for specialty testing courses, distinguishing member from non-member schools with stakeholder verification.
Extended-Campus Operations
- Built and tuned SharePoint list filters so courses surfaced correctly by site, location, and cohort.
- Created a consolidated withdrawn view to simplify semester reporting.
- Supported ad-hoc analytics such as net registrations minus withdrawals, to inform university payables.
Reporting and Directories
- Established a membership directory data source on a two-hour refresh cadence feeding the public dashboard.
- Documented edit paths and expectations for update latency so staff knew what to expect.
- Monitored Power BI refresh alerts and advised on retry and triage for transient failures.
Finance Workflows
- Created instructor reimbursement workflows from Cognito Forms into a SharePoint list, and surfaced the bookkeeping list for finance stakeholders.
- Routed payment notifications to the correct finance owner and removed legacy recipients.
- Coordinated vendor invoicing entries and approvals for timely payment processing.
Website Content Operations
- Updated officer pages, fixed content issues, and posted program agendas and semester schedules.
- Published the annual calendar PDF and began loading individual events into the site calendar.
Security
- Blocked an impersonation and phishing sender targeting leadership, and shared forensic context with stakeholders.
- Advised on Power Automate connection re-authentication for mission-critical flows, reducing downtime.
Outcome
The Results
Reporting People Trust
Staff moved from spreadsheet hunting to list views for withdrawals and class-by-class registration, with filters corrected for accuracy.
Same-Day Content Changes
Agenda postings and officer updates were executed within the same day, minimizing confusion for registrants and members.
Clearer Finance
Instructor reimbursements were standardized and written directly to tracked lists, and payment notification ownership was clarified.
Proactive Reliability
Power BI refresh incidents were triaged quickly, and directory refresh cadence was communicated and automated.
Security Hardening
Phishing attempts were identified and blocked, with stakeholders notified.
In their words
What the Client Said
How it was built
Approach and Architecture
- PlatformMicrosoft 365, SharePoint Online, Power Automate, Power BI, and Cognito Forms.
- CadenceA two-hour directory refresh feeding the public membership dashboard.
- ModelSustained engagement across multiple semesters rather than a one-off project.
Services used
The Work Behind This Engagement
Delivered from our Nashua office. See where else we work on our service area page.
Recognize Any of This?
If your organization is running something important on manual steps, start with a free IT assessment. We review what you have, rank what is worth fixing, and give you a written roadmap to keep.