PI Systems's Business Intelligence Services enhances Corporate Performance Management capability at SE.
Corporate Performance Management at SE gets a boost after implementing a Business Intelligence project with PI Systems as its services provider.
SE, a electrical headquartered in the India, manages their business using the ERP, which runs on an IBM platform. The company wanted to enhance the sophistication of their reporting system in order to improve overall Corporate Performance Management capabilities. A powerful, yet cost effective solution, delivered in short timeframes, from a company with a good track record was the prime basis for evaluation. PI Systems was selected as the services provider after an evaluation process.
The PI Systems Solution
The PI Systems Solution primarily revolved around a data warehouse with a web based reporting solution with superior user interaction relevant to senior management. The reporting application offered sophisticated web based reports, web based pivot tables and analytics, graphical reports, alerts and dashboard features. Microsoft Excel based pivot tables were also provided with web front ends so that users could slice and dice the data and download relevant charts and analyses.
Open DataBase Connectivity (ODBC) queries were used along with Microsoft Data Transformation Services (DTS) to extract data from the IBM on IBM DB/2 and rendered in a Data warehouse. This staged database was used for the advanced reporting provided to SE. The primary area of functional thrust was in improving the Sales Information System.