GSPANN developed an automated dashboard to display BI data that was captured through web forms and Extract, Transform, and Load (ETL) database functions. The automated dashboard provided an interface to track and monitor KPIs.
GSPANN leveraged the potential of ASP.NET framework, Angular.js, SharePoint, and MS SQL Server to automate the KPIs for various risk vectors. We simplified the process of monitoring and tracking through graphical dashboards. We developed the BI dashboard with QlikView to display real-time analytical results by aggregating and extracting the data for multiple KPIs related to governance, mobile security, data protection, software updates, firewall protection, etc.
We programmed the dashboard to update periodically and send an automated notification whenever there is a change in the KPI status. This level of monitoring enabled the decision-makers to take prompt actions.
GSPANN developed a BI dashboard application in ASP.NET and then integrated it with SharePoint. The ASP.NET application was programmed to fetch data from the SQL server database using RESTful API services. The API services return the analytical data in JSON format, which was eventually bonded with HTML controllers with the help of Angular.js. Finally, the analytical data is displayed in the form of graphs, charts, and reports on the SharePoint-based BI dashboard.