Who is the Client

A US-based manufacturer of semiconductor processing equipment used in silicon wafer processing, with an annual sale of approx. $10B.

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. A web-based collaborative platform that integrates with Microsoft Office and empowers teamwork with dynamic and productive team sites
ASP.NET. An open-source, server-side web application framework designed for web development to produce dynamic web pages
Bootstrap. A free and open-source CSS framework directed at responsive, mobile-first frontend web development
C#. A general-purpose, multi-paradigm programming language encompassing static typing, strong typing, and other programming disciplines
RESTful API Services. An architectural style for an application program interface (API) that uses HTTP requests to access and use data
QlikView. Provides an end-to-end platform that includes data integration, user-driven business intelligence, and conversational analytics
AngularJS 2.0. A TypeScript-based open-source web application framework used to build mobile and desktop web applications in HTML and JavaScript
Microsoft SQL Server. A relational database management system that stores and retrieves data as requested by other software applications

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