About the Customer
Industry: Education
The client is a large section of an educational institute in the USA, with over 15+ years of experience. This institute has been handling several online courses, apart from the traditional way of education. A large community of students leverage the online courses to upgrade their skills, gain knowledge at a reasonable fee pattern.
Key Challenges
Online courses in this educational institute are leveraged by many students across the USA. The management and administrators of this institute found it difficult to manage and monitor the courses, their details, the number of students enrolled, their progress, etc.
They were in search of a comprehensive reporting solution that could give them the details, based on different parameters. They needed to go in details of each record, to enable faster decision making and get deeper insights.
Our Solution
SPEC INDIA helped the client by offering them a comprehensive BI solution with the best of analytical tools, keeping in mind the challenges faced by them. We have been cleansing the data with Power Query and DAX, making a dimension table.
The solution consisted of the following features, incorporated with Power BI:
- Showcasing year-wise, category and sub-category wise information based on courses
- Comparison of total students enrolled as against total reviewed, category wise
- Drill down details, category wise with data like state-wise enrolled men/women, number of courses by state and year
We have leveraged the technical features like extracting data using Google sheets and storing in an excel file. We have loaded the data in Power BI to create an online education platform report.
Tools & Technologies
Business Benefits
- Effective and well-optimized reports with rich graphical displays
- Cost-effective, easy to analyze solution
- Enhanced insight to make optimal business decisions with the comparison of yearly data-driven visualization
- Focus on course categories based on student enrollments, year-wise, state-wise
- Instructor / expert wise course details, number of courses taught by them