They were keen to design and develop a business intelligence solution that can act as a support to their learning management system, and gather insights from their digital portal for the course and module-related activities. They wanted detailed analysis from Google Analytics data, KACE system data and other data chunks for further detailing. They needed status of support tickets and other KPIs.
The client was finding it difficult to visualise different reports based on parameters. They were looking for a business intelligence application that could gather information from different sources, get map data from Google Analytics and upload it to the reports, complex chart type formatting for creating user defined reports.
Looking at the challenges faced by the client, SPEC INDIA followed the Fixed Cost model with the Agile approach to develop roadmap and architecture of the product. We designed and launched the Power BI reports and dashboards, after identifying and researching on various modern methodologies.
We have designed a range of Power BI dashboards and reports to offer insights for different categories like course completion, course and module-wise activities, enrolments, certification, badges, and other activities as listed below. These reports and dashboard act as foundation support for their learning management system.
We have also designed insights for the ticket management system that extracts data from data sources like Google Analytics, KACE, and Vimeo Analytics for video views, geographical user insights, and Predictive Modeling.
There have been requirements for complex chart type, in which we have used tweaks for transparency and formatted options of Power BI for generating complex visuals.
Filtration of data based on date range, gender, age, education, sales
Filtration of data based on country, state, city hierarchical filter, module
Number of badges achieved by level of education
Average no of badges achieved per user
Badge achieved by age group and gender wise
Number of badges achieved by level of sales
Distribution of Score
Population vs Average Score
Trends per Range
Expected Tables for Week
Total Number of Certified Modules, most/least certified,
Number of users promotor wise
Module wise number of certified users, logins and average time in minutes for completions of that module
Completed module by each level of education, by age and gender, date range, month etc.
No of Users by Module Completion
Total percentage of no of completed modules
Users by gender, hierarchy, age, education, sales, status etc.
Top 10 Users by Completed Modules
Top 10 Users by Min Time and Max Time Certified Modules
Top 10 Users by Tools Downloaded
Top 10 Users by Insignias Received
Active Users vs Days
Number of tools downloaded by Level of Sales
Number of tools downloaded by Level of Sales
Number of tools downloaded by tool name
Users per field staff
Registrations, Logins, Certifications by Assessor
KPIs – Number of users by region/rating/finishing video, hours spent by users
Total registrations, logged in users, total months since first and last login
Registrations, Logins, Certification wise Data
Logins per person per month
Total number of loads for videos
Number of responses from user for entry and exit questions
Insights through Google Analytics, KACE
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 well-defined, robust, and secure launch criteria that offer us a successful implementation clubbed with detailed testing, customer acceptance, and satisfaction.
Easy tracking of the entire learning management system, ticket management, marketing insights etc.
Predictive modeling for duration of course completion and status of users
Insights in an interactive manner
Faster decision making on product impact
Increased digitization inputs
Viewing dashboards on an ongoing basis
Futuristic view of business information
Dynamic representation and interaction with data
Business growth and job creation
Overall impact of product / service on financial and business wellbeing