Download PDF
Efficient Data Integration and Reporting in San Bernardino School System
Technology Category
- Cybersecurity & Privacy - Security Compliance
Applicable Industries
- Buildings
- Education
Applicable Functions
- Human Resources
- Maintenance
Use Cases
- Regulatory Compliance Monitoring
- Time Sensitive Networking
Services
- System Integration
The Challenge
San Bernardino County School System, which services 40 school districts and supports K-12 schools, community colleges, and occupational programs, was struggling with efficiently integrating data and providing reporting to comply with the Affordable Care Act and other new regulations. The school system was also required to continuously respond to ad hoc information requests. The new payroll reporting requirements further complicated the situation, as the system struggled to integrate the necessary data. Costly payroll system upgrades and time-consuming, manual efforts were not in the budget. The technology department needed to continuously respond to ad hoc requests for information quickly, such as budget impacts of increasing a health benefit, or the number of substitute teachers employed in a given month.
About The Customer
The customer in this case study is the San Bernardino County School System. The Superintendent’s office services 40 school districts throughout San Bernardino County, east of the greater Los Angeles area. They support K-12 schools, community colleges, and occupational programs serving more than 400,000 students. The Superintendent’s office also services five other counties: Del Norte, Inyo, Mono, Humboldt, and San Mateo. The school system was struggling with efficiently integrating data and providing reporting to comply with new regulations, as well as continuously responding to ad hoc information requests.
The Solution
San Bernardino County partnered with Altair to find an efficient, effective way to comply with the new laws without placing too great a burden on their limited resources. Altair provided self-service data preparation capabilities to more than 300 users throughout the county. Payroll clerks at each of the 40 K-14 school districts within San Bernardino County can now quickly access and compile substitute teacher data to ensure compliance with the Healthy Workplace Healthy Family Act. The system also allows them to review healthcare coverage data for employees in order to comply with the Affordable Care Act. Ad hoc requests can also be run without the involvement of the technology team. Altair pulls in and validates raw data automatically, ensuring the accuracy of the information provided.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Energy Saving & Power Monitoring System
Recently a university in Taiwan was experiencing dramatic power usage increases due to its growing number of campus buildings and students. Aiming to analyze their power consumption and increase their power efficiency across 52 buildings, the university wanted to build a power management system utilizing web-based hardware and software. With these goals in mind, they contacted Advantech to help them develop their system and provide them with the means to save energy in the years to come.
Case Study
Intelligent Building Automation System and Energy Saving Solution
One of the most difficult problems facing the world is conserving energy in buildings. However, it is not easy to have a cost-effective solution to reduce energy usage in a building. One solution for saving energy is to implement an intelligent building automation system (BAS) which can be controlled according to its schedule. In Indonesia a large university with a five floor building and 22 classrooms wanted to save the amount of energy being used.
Case Study
Powering Smart Home Automation solutions with IoT for Energy conservation
Many industry leaders that offer Smart Energy Management products & solutions face challenges including:How to build a scalable platform that can automatically scale-up to on-board ‘n’ number of Smart home devicesData security, solution availability, and reliability are the other critical factors to deal withHow to create a robust common IoT platform that handles any kind of smart devicesHow to enable data management capabilities that would help in intelligent decision-making
Case Study
Commercial Building Automation Boosts Energy Efficiency
One of the challenges to building automation is the multitude of non-interoperable communications protocols that have evolved over the years. Buildings have several islands of automation. Bridging the islands of different automation without losing the considerable investment in each specialized control network is the main focus in this solution.
Case Study
Protecting a Stadium from Hazardous Materials Using IoT2cell's Mobility Platform
There was a need for higher security at the AT&T Stadium during the NFL draft. There was a need to ensure that nuclear radiation material was not smuggled inside the stadium. Hazmat materials could often be missed in a standard checkpoint when gaining entry into a stadium.
