​casestudy-banner

Analytical Dashboard for School

More Case StudiesHamburger_Menu
​

Malvern

The client runs a premium school chain having multiple branches across the United States. The client has to use multiple source systems for managing data related to school finance, students and lead generation. The main aim of this engagement was to consolidate the data from heterogeneous data sources into a single data store and also to provide advanced analytical dashboards, which would aid the senior management in taking key business decisions.

 

Business Challenge

  • Existing systems had large amount of complex data in different sources.
  • Efficiently testing the entire data flow in one single application.
  • Various integrated system complicating the accurate analysis.
  • Continuous manual data entry process in spreadsheet to integrate the data from different source to view at one point.
Business Challenges  
 
HOW_AVASOFT_HELPS  

How AVASOFT Helped?

  • We evolved with an efficient solution for testing this application by customized approach to ensure data accuracy at various levels of the DW/BI chain.
  • Provided accurate test results by comparing the source and target data with business transformation rules using SQL query, manual spreadsheet report, and crystal report to test the different integrated sources.
  • Verified our application with Google platform to test the marketing strategies data in dashboards and reports.
  • Performed functional and regression testing on each iteration.
  • Integration testing carried out on the dependent filter, widgets and grid.
  • Automated the common integrated filter functionality to reduce the time with accurate result.
  • Individual role based testing executed.
 

OUR technology stack

These are the list of technologies we used

Power BI  
 
Microsoft SQL  
 
Selenium  
 
 
Value Added  

Value Additions to Customer

  • Using defined framework, complete testing was achieved in reduced timeframe and cost.
  • Entire data was processed in real time and was made available at a live notice with accuracy.
  • A well-established set of customized filters / options / visual customizations / output formats are available.
  • User friendly application.
 

Business gain

  •  We successfully provided complex deliverables on-schedule and with exceptional quality.
  •  Reduced manual testing effort.
Business Gain  
 
Business Need  

Business Need

  • Multiple systems are used by the client to manage different data like Student information, attendance information, course details, and financial details and lead generation data.
  • The data from these systems are not connected in any way and thus it won't provide any meaningful value.
  • There is no way the top level management can view any of these data from a single application, which makes it difficult for them to take any key decisions.
 

Vertical Industries

  • School – (Visionary planning, budgeting, analytics and reporting for Executive, Operational, Marketing, Regional Manager and School director).
Vertical Industries  
 
Country/Region  

Country/Region

  • USA