|
Over the years, our client acquired a number of systems to capture data and hence, needed a system that would pull key data from these systems spread across the group to give them useful insights on facts to analyse their profitability. |
|
| InfrasoftTech's Solution: |
- Agile Methodology to accommodate incremental requirement and incremental releases to meet the drop date.
- Standardisation of the Master Data.
- Translating data feeds into the Staging Database for checking Data integrity using ETL Services in SQL Server 2005.
- Capturing and Storing the data in SQL Server 2005 as Enterprise data warehouse.
- Processing the data and generating the required cubes using SQL Server 2005 Analysis service and executing reports on Business Objects XI Release 3 and Microsoft Excel.
- Partitioning of Databases and cubes to handle large data volumes.
|
|
With this implementation, our client is now able to:
|
- Generate a consolidated view of data across the group.
- Perform limits monitoring, data reconciliation and overall fasterreporting operations.
- Profitability Analysis across the group or any of the sub-groups drilled down, to the lowest level.
- More efficient report generation process and accurate reporting.
- Lower total cost of ownership using InfrasoftTech's agile delivery model.
- The solution led to identification of data quality issues in the source systems and improvements thereof.
|
|
| Technology Environment : |
|
- Business Intelligence: Business Objects XI R3
- User Interface and Administration: ASP. Net 2.0 (Language C#)
- ETL (Extract, Transform and Load): Microsoft SQL 2005 Data Transformation (DTS)
- Database: Microsoft SQL Server 2005 Enterprise Edition with 64 bit OS support
- Analytical Services: Microsoft SQL Server 2005 Analytical services
|
|
|
|
| To understand how we can help you maximize your organisation's investment on technology, write to us at solutions@infrasofttech.com |
|