Data Warehouse Consulting

The foundation of any Business Intelligence implementation is the Data Warehouse. Whether it supports the entire enterprise or just a departmental solution, WIT’s Data Architects can help conceptualize, design and implement your Data Warehouse solution. WIT’s collective Data Warehouse experience covers all of the major database vendors, including Oracle, DB2/UDB, Teradata, Sybase, etc.

With many years of collective experience implementing Data Warehousing projects, you will find us to be an expert delivery organization and a trusted advisor. Our implementation experience includes both large and small projects. Combined together with our BI competencies, our Data Warehouse consulting professionals can help you harness the power of your data warehouse and BI implementations.

WIT’s Data Warehouse Consulting competency encompasses the full-solution delivery model that includes:

Requirements Gathering & Analysis

Rationalization of Kimball vs. Inmon Data Warehouse Design Methodologies

Dimensional / Star Schema Data Modeling

Data Warehouse Technical Infrastructure Design

Data Warehouse/Mart Integration & Enhancements

Data Warehouse Appliance Implementations

Performance Tuning

Extract, Transform, and Load (ETL) Consulting

ETL is the glue that connects the Data Warehouse to its data sources. WIT’s ETL Consultants are highly skilled in analysis of data transformational requirements and implementation of ETL solutions that are optimized to populate and update the Data Warehouse. WIT Consultants are experts in all of the major ETL tools, including IBM Datastage, Informatica, Business Objects Data Integrator, etc.

WIT’s ETL Consulting competency encompasses the full ETL solution delivery model that includes:

Requirements Gathering & Analysis
Data Profiling
ETL Development & Enhancements
ETL Batch Window Analysis & Optimization
Performance Tuning

For more information about our consulting services, please call Scott Smith at (800) 257-1490, extension 248, or email at ssmith@witinc.com.