Student Analytics Solution Enabled Effective Management of Services Provided to Students with Disabilities

 

The client is the second largest School District in the nation and serves over 600,000 students in kindergarten through twelfth grade at over 1,000 schools. The district also has over 200 independently operated public charter schools. Its boundaries stretch across 720 square miles and include the City of Los Angeles as well as all or parts of 31 municipalities and several unincorporated regions of Southern California. 

 

Background

The client used multiple complex systems to manage regular & special student education programs. These systems were disparate and ran on different technology platforms. The key challenges in front of the client were to:

 

  1. Consolidate millions of records of data from these disparate and complicated systems 
  2. Be able to provide scalable performance to thousands of business users to perform self-service analytics on the consolidated data

 

 

Solution

DiLytics provided an Oracle Analytics based solution. As part of the solution implementation, DiLytics:  

  • Analyzed and evaluated the business requirements
  • Studied the data in underlying complex source systems
  • Designed a best-practices-based star schema data warehouse keeping the nuances of the business data in consideration
  • Developed industry standards-based Extract, Transform, and Load (ETL) mappings leveraging Oracle Data Integrator (ODI) to automate the integration of data from all relevant source systems
  • Modeled the data warehouse on Oracle Analytics to develop metrics, attributes, and Key Performance Indicators (KPI) in a business dictionary.
  • Built a library of reports and dashboards for business users to be able to consume analytics effortlessly.
  • Deployed the solution in a clustered environment to enable scalability of the solution when thousands of users are active.

 

The solution enabled the following insights for the client: 

  • Student-to-class assignment
  • Teacher-to-class assignment
  • Staff-to-class assignment
  • Schedules
  • Attendance
  • Disciplinary
  • Grades/Scores
  • For Students with Disabilities (SWD):
    – Referrals
    – Assessment
    – Prescription
    – Individual Education Progress
    – On-call support to students’ families

Business Benefits

  • Effective management of services provided to SWD by school/local district/central office administrators
  • Enablement of families of SWD to become meaningful participants in the education of their children via the provisioning of information, assistance, and resources
  • Improved visibility into data for users, on a near real-time basis based on automated data refresh on a nightly frequency
  • Ability for super users to create additional analyses at the speed of thought leveraging the business dictionary made available to them.

Technical Stack

  • Source Systems: MISIS, Welligent
  • Data Integration Tool: Oracle Data Integrator 12c (ODI)
  • Data Warehouse: Oracle Database 12c
  • Reporting Tool: Oracle Analytics

What does the Client Say?

DiLytics has found creative ways to adapt to the changing complex requirements and has always kept management informed of project status. The vendor is always proactive, cooperative, adaptive, and courteous, and shows a professional demeanor. Business users are very satisfied with their end product and their approachability. DiLytics resources do not only have technical expertise, but are also very professional, personable, and approachable. This differentiates them from other technical resources. – IT Director

To get a copy of this success story in a downloadable format with more in-depth analysis, kindly provide us a little information about yourself in the form below

DiLytics Delivers

View all Success Stories →

Manufacturing Analytics

DiLytics implemented a Manufacturing Analytics solution for a Biotechnology Company in a short period of 100 days.

Custom Data Warehouse

DiLytics implemented a custom data warehouse solution for a Leading Container Leasing Company in a short span of 150 days.

Center of Excellence

DiLytics established a Business Intelligence Center of Excellence to help a Video Game and Digital Entertainment Company maximize RoI.