This school had a massive data of students, faculty, admissions, exam grades, scholarship, financial aid, and other government submission reports. But, the data scattered in multiple systems and had tight integrations with various systems.
Following were the key challenges:
Consolidating data from multiple sources and designing data warehouse
Data profiling for accuracy & completeness
Data cleansing for detecting and correcting corrupt records
Embed various visualization and analysis in the web-based system for admission and management staff
Web-based system storing student-faculty online application and admission data
CRM integration with Salesforce
Financial Accounting data in Peach Tree
Legacy data/forms in MS-Access
SPEC India designed and developed a Business Intelligence and Analytics Solution for the customer which can help them in doing effective data analytics. As per the student’s pattern, this solution helped in marketing campaign and even forecasted & identified students’ competitive exam cleared ratio/interest/retention ratio etc. It covers following features:
Competitive Exam Passer/Failure Ratio Analysis
Visualization for comparison of university’s result with other universities results over the period.
Displaying the total count of student appeared in the exams, the number of passers among them and ratio of passers within the given duration of the dates.
Detailed analysis of passer/failures of students by gender, by GPA, by LSAT score, etc. for first-timers as well as repeaters.
Top Course Trend As Per Enrolled Students
Visualization of enrolled student information by semester by class and by program
Chart showing top ‘N’ registration trends for courses
Visualization can be bifurcated by categories of courses i.e online/offline
Students Retention & Graduation Summary
Retention trend of students by the year
Graduation trend of students by the year
Drill down student information for each trend
Students Application Status Summary
Application trend of students by type of applicant status (New, visiting or transfer, etc.) for year
Application trend of students by gender for a year
Data warehouse design for visualization
SSIS development to load data into the warehouse
Tableau Dashboard Development for various requirements
Students Registration Trend
Visualization of registration trend of students at the census, live and registration period.
Our detailed and accurate research , analysis, and refinement leads to a comprehensive study that describes the requirements, functions, and roles in a transparent manner.
We have a team of creative design experts who are apt at producing sleek designs of the system components with modernized layouts.
Our programmers are well versed with latest programming languages, tools, and techniques to effectively interpret the analysis and design into code.
Quality is at the helm of our projects. We leave no stone unturned in ensuring superior excellence and assurance in all our solutions and services.
We have a well-defined, robust, and secure launch criteria that offers us a successful implementation clubbed with detailed testing, customer acceptance and satisfaction.
SPEC India’s successful implementation of Business Intelligence and Analytics helped University in various analytical goals. It benefitted them in the following ways:
Fetched meaningful insights into the large set of historical data
Forecast retention ratio and effectively design the new programs as per student
Identify performing and non-performing student patterns for competitive exams
Compared results with other universities
Identify the yearly trend of the application by specific age group, gender which can help them to target a set of the group for the campaign.