Data Warehouse for Service Warehouse

The Client :
A major Elevator Company, South Korea

Project Details:

• Analyzing  reporting & query requirements
• Understanding key Performance indicators for the organization
• Identifying business processes
• Studying dispersed data sources
• Auditing available information in the legacy databases
  

ennovate's Role:

• Designing process for Staging server
• Design & Development of ETL process
• Designing dimension model and data marts
• Designing Universe, Security Model, Deployment Scenario
• Development of few complex reports and queries
  

Platforms: SQL Server 2000, Business Object 6.1, Data Integrator 6.x, ERWIN