Devlin Consulting Inc. > Services > Data Warehousing

Data Warehousing

Return to Home Page

Information drives the world today.  To compete companies must be able to quickly make decisions based on complete information.  Data warehousing is the process of consolidating information into a single source, allowing information to be quickly retrieved and analyzed.  As technology advances, the success of an organization to consolidate and store complete and accurate information has a greater influence on the organizationís ability to survive.

DCI has a proven track record at building feature rich data warehouses on time and on budget.  We have developed several large-scale enterprise warehoused that successfully consolidated information from several data sources, often running on different platforms.  The DCI web-based tool, Quality Central, validates the warehouse data against the source system and against financial operating reports.

DCI utilizes a consistent methodology in building a warehouse, and our web-based tool Data Central provides a single-source to monitor data structures, data definitions, scheduled processes and the success of each process.

Our extensive business and system engineering experience enables DCI to successfully design and implement warehouses.  DCI understands that a warehouse must be designed to grow and accommodate the changing business requirements.  Below is an overview of DCIís data warehouse approach.

Requirements Analysis:  DCI brings a unique mixture of business and system resources together, bridging the communication divide as business requirements are developed for a technical system.

Design Documentation:  The design documentation specifies how the business requirements will be implemented.

Data Modeling:  DCI is experienced in todayís leading data modeling and case tools.  DCI consultants have extensive experience in performing and teaching data modeling.  The data model must allow data to be loaded and retrieved efficiently.  The use of indexes, stored procedures and triggers and views are all incorporated in the data model to improve efficiency and meet business objectives.

Testing:  DCI uses an iterative approach to testing.  Throughout the life cycle of the project, use cases and tests are developed.  As each stage of the project is developed the tests are run.  As parts of the project are pieced together these tests are repeated, testing the system integration.

Configuration Management:  As the warehouse moves into production it is critical to understand what objects to move from the test environment into production.  Configuration management provides version control of objects and tracks each object.