[vc_section full_width=”stretch_row” css=”.vc_custom_1532085157436{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;background-color: #ffffff !important;}”][vc_row full_width=”stretch_row” css=”.vc_custom_1766725087824{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 40px !important;}”][vc_column css=”.vc_custom_1766724963717{margin-top: 10px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][vc_column_text css=”.vc_custom_1766725017949{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

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

[/vc_column_text][vc_column_text css=”.vc_custom_1766723700853{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]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.[/vc_column_text][vc_column_text css=”.vc_custom_1766723738042{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

Background

[/vc_column_text][vc_column_text css=”.vc_custom_1766723808887{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]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:[/vc_column_text][vc_column_text css=”.vc_custom_1766725634321{margin-top: 0px !important;margin-bottom: 35px !important;padding-left: 35px !important;}” el_class=”text-block1″]

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

[/vc_column_text][vc_column_text css=”.vc_custom_1766724039966{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

Solution

[/vc_column_text][vc_column_text css=”.vc_custom_1766724181300{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]DiLytics provided an Oracle Analytics based solution. As part of the solution implementation, DiLytics:  [/vc_column_text][rt_list_style list_style=”seven” list_content=”

• List Item Text One
• List Item Text Two
• List Item Text Three

” list_css=”.vc_custom_1766724368104{margin-bottom: 20px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]

• 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

[/rt_list_style][vc_column_text css=”.vc_custom_1766724412585{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]The solution enabled the following insights for the client: [/vc_column_text][rt_list_style list_style=”seven” list_content=”

• List Item Text One
• List Item Text Two
• List Item Text Three

” list_css=”.vc_custom_1766724561675{margin-bottom: 10px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]

• Student-to-class assignment
• Teacher-to-class assignment
• Staff-to-class assignment
• Schedules
• Attendance
• Disciplinary
• Grades/Scores
• For Students with Disabilities (SWD):

[/rt_list_style][vc_column_text css=”.vc_custom_1766724530298{padding-left: 55px !important;}” el_class=”text-block”]- Referrals
– Assessment
– Prescription
– Individual Education Progress
– On-call support to students’ families[/vc_column_text][vc_column_text css=”” el_class=”text-block”]

Business Benefits

[/vc_column_text][vc_column_text css=”.vc_custom_1766724677520{margin-bottom: 10px !important;}” el_class=”text-block”]Key business benefits to the client included:[/vc_column_text][rt_list_style list_style=”seven” list_extra_class=”text-block” list_css=”.vc_custom_1766724731986{margin-bottom: 35px !important;padding-left: 35px !important;}”]

• 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

[/rt_list_style][vc_column_text css=”” el_class=”text-block”]

Technical Stack

[/vc_column_text][vc_column_text css=”” el_class=”text-block”]Source Systems: MISIS, Welligent

Data Integration Tool: Oracle Data Integrator 12c (ODI)

Data Warehouse: Oracle Database 12c

Reporting Tool: Oracle Analytics[/vc_column_text][vc_column_text css=”” el_class=”text-block”]

What does the Client Say?

[/vc_column_text][vc_column_text css=”.vc_custom_1766724879046{margin-bottom: 0px !important;}” el_class=”text-block”]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[/vc_column_text][/vc_column][/vc_row][/vc_section][vc_row full_width=”stretch_row” equal_height=”yes” content_placement=”middle” css=”.vc_custom_1684237429473{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 35px !important;padding-bottom: 35px !important;background-color: #ffffff !important;background-position: center !important;background-repeat: no-repeat !important;background-size: cover !important;}”][vc_column width=”1/3″ css=”.vc_custom_1531997568277{margin-top: 0px !important;margin-bottom: 10px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][/vc_column][vc_column width=”1/3″][vc_column_text css=”” el_class=”text-block”]

DiLytics Delivers

[/vc_column_text][/vc_column][vc_column width=”1/3″][vc_custom_heading text=”View all Success Stories →” font_container=”tag:h6|font_size:16px|text_align:right|color:%23dd3333|line_height:26px” use_theme_fonts=”yes” css=”.vc_custom_1660717315754{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”font-weight-medium” link=”url:https%3A%2F%2Fdilytics.com%2Fsuccess-stories%2F|title:Success%20Stories”][/vc_column][vc_column css=”.vc_custom_1661424713241{margin-bottom: 25px !important;}”][rt_case_study_style case_study_style_variation=”seven” case_study_display_filter=”no” case_study_enable_title=”yes” case_study_enable_excerpt=”yes” case_study_spacing=”30″ case_study_looping_sort=”ASC” no_of_case_studies=”3″][/vc_column][/vc_row]