The client is a leading global supplier of electronic components who has manufacturing units across the world. They offer their customers the broadest selection of capacitance technologies in the industry across all dielectrics, electromechanical devices, electromagnetic compatibility solutions and super capacitors. Our client’s vision is to be the preferred supplier of electronic component solutions for customers demanding the highest standards of quality, delivery and service.
Business Challenge
Migration of data from SAP to Microsoft SharePoint 2013
- The organization uses BO as a reporting tool to develop and deliver reports to decision makers.
- To analyse the data, existing BO reports present a quite challenge due to the diverse formats of reports and multiple interfaces.
- Ever since, Complex reporting features like multidimensional analysing, Scorecards/Dashboards, Maps, Master detail reports & high volume of data’s could not accomplished.
How Avasoft helped?
AVASOFT proposed to migrate the existing BO reports to Cognos business suite.
- Worked with client to identify and ensure reports are aligned with business objectives by reducing and optimizing the existing reports.
- Planned a road map for migration using reusable components and designing of new components with enterprise architecture in mind.
- Analysed the existing reports for their functionality and technical aspects.
- Structured metadata and built the reports in Cognos 10.x BI.
- Tested reports for design, layout and data considering BO reports
- Implement Cognos reporting application in QA and production environment.
Tech Stack
These are the list of technologies we used
Value additions to Customer
Migrate existing site to Telerik Components
- Robust BI tool to accommodate future high volumes of data & multidimensional analysis feature.
- Provision to accommodate complex multidimensional Adhoc reports.
- Provision to accommodate complex scorecards / dashboards..
- Better scalability.
- Better role based / access driven security.
Business Gain
Our efficiency reflects as business gains.
- Reduced the No of legacy reports by 30% on consolidating report by providing advanced filtering capabilities.
- In addition to HTML, reports are accessed in several formats like PDF, CSV and Excel.
- Portal and email reports are accessed in mobiles and tablets.
- Improved user experience on notifications, search and content.
- Various complex reporting features which are required by decision makers like drill-through, maps, analytic calculations, detailed master reports, charts etc. has been accomplished in Cognos in a short span of time.
