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.
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.
Tech Stack


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 Gains
- We successfully provided complex deliverables on-schedule and with exceptional quality.
- Reduced manual testing effort.
Business Needs
- 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).