Business Process Improvement | Microsoft Excel | Google Sheets | Dashboard Design | Workforce Analytics
Situation
The business managed continuing education for approximately 150 EMS professionals across multiple training formats, including quarterly education, tailgate trainings, instructor-led courses, online learning, and external education. Leadership needed greater visibility into employee training progress, certification compliance, and workforce readiness, but training records were maintained across multiple spreadsheets, forms, and reporting systems. The decentralized process made it difficult to monitor compliance, identify training gaps, and efficiently generate reports for leadership.
Business Questions:
Are employees on track to meet continuing education requirements?
Which certifications or training requirements are approaching expiration?
Where are the largest training gaps across the organization?
How can reporting be standardized to improve decision-making?
How can we reduce the time spent manually tracking continuing education?
Approach
I designed and developed a centralized Google Sheets–based workforce analytics system that consolidated continuing education data from multiple sources into a single reporting platform. The solution automated data collection through QR codes and Google Forms, standardized reporting, and generated interactive dashboards that provided leadership with real-time visibility into compliance and workforce readiness.
The system also generated individualized continuing education transcripts, significantly streamlining the employee recertification process with the North Carolina Office of EMS.
(Personal identifiers have been removed from published screenshots. Figures reflect the original analysis.)
Insights
Centralizing training data improved reporting accuracy and consistency.
Automation significantly reduced the time required to prepare compliance reports.
Leadership gained real-time visibility into certification status and workforce readiness.
Standardized reporting made it easier to identify employees approaching certification deadlines.
Consolidated data enabled proactive workforce planning and targeted educational initiatives.
Business Impact
The dashboard transformed continuing education management from a manual reporting process into a centralized decision-support system.
Key business outcomes included:
Improved visibility into organization-wide workforce readiness.
Reduced administrative effort through reporting automation.
Increased confidence in the accuracy and consistency of training records.
Streamlined employee recertification through automated transcript generation.
Enabled proactive identification of compliance risks before certification deadlines were missed.
Provided leadership with timely, standardized reporting to support operational planning and regulatory compliance.
Business Process Improvement
Workforce Analytics
Operational Decision Support
Dashboard Design & Reporting
Data-Driven Problem Solving
Executive Communication
Google Sheets & Forms
Pivot Tables & Pivot Charts
Dynamic Charts
Dashboard Design
SUMIFS, INDEX/MATCH
Data Validation, Conditional Formatting
Reporting Automation
Protected Workbook Architecture
What I Learned
This project reinforced that successful analytics begins with understanding the business problem before selecting a technical solution. By centralizing fragmented data and automating reporting, I transformed a manual process into a decision-support system that improved visibility, increased efficiency, and helped leadership make more proactive decisions. It strengthened my ability to translate operational challenges into practical, user-focused analytical solutions.