The main aim of this engagement was to consolidate the data from heterogeneous data sources into a single data store and also provide advanced analytical dashboards which would help the senior management in taking key business decisions.
Business challenge
- 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 make it difficult for them to take any key decisions.
- Providing separate access to necessary stake holders to respective systems involves more time and effort as they don’t have a common entitlement model in place.
How Avasoft helped?
- Setting up of the cloud based SQL Data warehouse where the data from heterogeneous data sources are extracted and consolidated in a single data store.
- These data are extracted using the SQL Sync job which is scheduled to run at a specific time and would pull all the required data.
- Created several analytical dashboards using Microsoft Power BI that blends data across multiple platforms.
- These dashboards cater different information to the user based on their role and their entitlement to see the data.
Technology stack
- Power BI
- .Net
- JavaScript
- SQL Data Warehouse
Value additions to customer
- A single application that blends data across multiple platforms which helps the stakeholders to view all the key data.
- Powerful analytics dashboard which reduces the time spent by the top management to make key decisions.
- Data from heterogeneous data sources are extracted into single data warehouse, and this helps in generating Adhoc reports on demand.
- Admin can assign the permission to the users to view dashboards, reports from a single entitlement module which controls data from multiple source systems.