Data Warehouse Design Services

Touchstone provides a full data warehouse design and development service. Either from a migration of an existing data warehouse onto a new database format, to the design and creation from one or more existing transaction based data sources.

We have implemented data warehouse solutions at multiple sites, using data from servers worldwide. Our solutions range in size from small data marts to company-wide multiple source data warehouses. We have developed data warehouse systems as bespoke turnkey solutions, or stages developments and deployments using stepwise implementation to allow early deliverables and better user acceptance.

Platforms used included workstations and servers from Sun, SGI and HP, Windows NT servers, Windows 95 / 98 and Mac clients. We bring in not just technical skills, but rich experience in application areas like marketing, sales, human resources, finance, etc. Out focused data warehouse team provides focused consulting and design services to the business intelligence world.

Services

• Complete analysis of functional needs
• Data mart and data warehouse design, using data modelling techniques
• Data warehouse creation at multiple sites from multiple servers
• 'Jump-starting' client projects with our in-depth knowledge of Business Objects, Brio, Cognos, Impromptu and Powerplay, Micro-Strategy, Informatica and Data Stage
• Web-enabling of data warehouses and complimentary reporting
• OLAP tool implementations on the web
• Single sign on, using LDAP and web servers
• Expertise with databases such as Oracle, Sybase, DB2, Informix and Teradata
• Writing ad hoc queries and reports
• Integration with enterprise resource planning (ERP) solutions such as SAP, Oracle, etc
• Integration with eCommerce to build near-real-time data warehouse access
• Integration with customer relationship management (CRM) tools such as Siebel, Clarify and Oracle CRM.

Experience

Our value proposition is based on our vast experience in providing design, development, enhancement, maintenance, and support services to our clients across diverse function and technological areas:

• Strong data warehousing and business intelligence practice within the organisation
• Availability of a strong knowledge base and experience in data warehousing projects
• Availability of a large resource pool to meet flexible resource demands
• Partnership with leading data warehousing companies