Who is the Client

A US-based $9B company that designs and builds semiconductor processing equipment that is primarily used in frontend and backend silicon wafer processing.

The Challenge

The client owns multiple large manufacturing plants in various locations. They have separate units for performing the different processes for manufacturing semiconductor processing equipment. The nature of the client’s business requires frequent analysis of the data related to the manufacturing process to determine and analyze risk vectors. Maintaining multiple Excel sheets for tracking the risk vectors was cumbersome. Since the data was collated manually, the reports were prone to errors.

The client wanted to eliminate all time-consuming manual processes associated with the collection and consolidation of data for different KPIs to create dashboards in MS Excel.

The Solution

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.

Business Impact

  • Swapped the manual process of extraction and aggregation of analytical data with ETL functions.
  • Synchronized and automated multiple tasks associated with the smooth functioning of the BI dashboard and ensured the availability of analytical data in the SQL server database.
  • Availability of real-time KPIs on the executive dashboard significantly increased the client's productivity.

Technologies Used

Atlassian Jira. Platform to manage sprint stories
Microsoft SharePoint. Document management and storage system
ASP.NET. Open-source server-side web application framework
Bootstrap. HTML, CSS, and JS frontend framework
C#. Multi-paradigm programming language
RESTful API Services. Web services conforming Representational State Transfer (REST) architecture
QlikView. Business intelligence (BI) software
AngularJS 2.0. TypeScript-based open-source frontend web application platform
Microsoft SQL Server. Relational Database Management System (RDMS)

Related Capabilities

Utilize Actionable Insights from Multiple Data Hubs to Gain More Customers and Boost Sales

Unlock the power of data insights buried deep within your diverse systems across the organization. We empower businesses to effectively collect, beautifully visualize, critically analyze, and intelligently interpret data to support organizational goals. Our team ensures good returns on the big data technology investment with effective use of the latest data and analytics tools.

Do you have a similar project in mind?

Enter your email address to start the conversation