Data Warehouse Solutions

· Data Warehouse
· e-Business Intelligence
· Re-Engineering of DW applications
· CRM Data Warehouse
· Data Warehousing Implementation
· Data delivery applications
· Data integration

Case Studies
· Business Management System
· Data Warehouse Redesign Project
· User Survey Project
· BI Platform Development
· Data Warehouse Reporting Portal

Data warehouse Technologies

OLAP tools:MicroStrategy, Brio, Business Objects, Cognos, Hyperion, Informix Metacube

ETL tools: Informatica, Datastage, Datajunction, DataMirror

Databases: Oracle, MS SQL Server 2000, Sybase, DB2, Informix, Redbrick, Teradata;

Datamining Tools: SAS Miner, Intelligent Miner;

End to end tools: SAP Business Warehouse suite and Oracle Data Warehousing product suite


Database Consulting

· Offshore Database Consulting
· Embedded Database Development

Case Studies
· Database programming

Business Intelligence Platform Development.

Business Situation:

The big volume of data within our customer organization was overwhelming. Yet data alone could not give them a competitive edge.
The customer's business environment required a responsiveness that could only be achieved with timely and accurate insights into business conditions. To be successful, our customer needed rapid, easy access to the information about their finances, customers, and external market conditions.

Key Issues :

The customer needed rich data analysis and data mining capabilities of the platform that would enable their customers to empower all of the critical, timely business information tailored to their specific information needs.

Result :

SolovatDesign developed a complete business intelligence (BI) platform that provides the features, tools, and functionality to build analytical applications.
The following tools were developed as the components of a business intelligence system:

• Extract, transformation, and load (ETL) tool
• Relational data warehouse (uses leading databases)
• Data mining tool
• Reporting tool (OLAP)
• Database development tools (Enterprise Manager, Query Analyzer, etc)
• Database management tools (SQL Server tools)