Data Warehousing

The foundation of any Business Intelligence implementation is the Data Warehouse.  Whether it supports the entire enterprise or just a departmental solution, our Data Architects can help conceptualize, design and implement your Data Warehouse solution.  Our 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.

Fabica'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.  Our 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.

Fabica'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