The impact of enterprise initiatives such as ERP and CRM, as well as new e-business applications and processes have challenged the stature of the traditional data warehouse (DWH) as the decision-making framework of choice. Issues such as just-in-time data, pre-build packaged application integration, e-source data, and business process integration are just some of the weaknesses that have been linked to the conventional DWH solution.

Entigy has been able to repeatedly deliver high quality solutions by following our Enterprise Integration & Intelligence (EI²) framework. This process-driven framework is constantly refined and updated to reflect Entigy's every increasing technical Body of Knowledge.

The following are some of the individual services we offer that make up our turn-key solution:

1. Data Architecture/Modeling
2. ETL/Data Acquisition Strategies
3. Data Modeling
4. Data Cataloging/Organizing
5. Data Cleansing
6. Data Access & Delivery

1. Data Architecture/Modeling

Entigy has proven experience architecting complete data warehouse/integration solutions that cover the gamut of identifying and extracting raw transactional data from source systems through to delivering refined strategic information to knowledge workers. We are keenly aware that the solution is rarely an off-the-shelf offering rather a collection of disparate technologies that must be seamlessly integrated together. Entigy's Technical Architects possess key skills in the following areas: · Developing and maintaining logical and physical models for data warehouse environments · Designing and reviewing atomic, departmental and individual level data modeling and data mart design · Designing enterprise-wide business intelligence architectures, including data architecture and management, system architecture and management, data integration, and information access architecture · Creating Data warehouse process flow and data flow design · Designing and modeling Data warehouse database · Strong knowledge of the data warehouse market, tools, and strategies · Excellent presentation skills, both oral and written · Interact effectively with senior management and technical levels within client organizations.

2. ETL/Data Acquisition Strategies

It is estimated that for initiatives such as data warehouses or data marts, that seventy percent or more of the effort is concentrated on data acquisition. For most significant enterprise initiatives, the data integration effort is always identified as being of key importance. Since its inception, Entigy has specialized in the provision of ETL/Data Acquisition services that ensure the extraction, transformion, and loading of both structured and unstructured data in an optimized manner. Whether it's designing ETL architectures or creating data flows through that framework, Entigy consultants support every aspect of the ETL process through value-added integration and implementation tactics and support. These consultants have solid skills in the following areas: Our ETL developers are skilled at the following tasks: · Designing data acquisition process architecture · Designing and developing transformation processes · Interpreting, confirming, and modifying data acquisition specifications with business users · Refining extraction routines · Working with source system experts to define the system of record, develop and test the batch procedures · Installing and testing best of breed ETL tools

3. Data Modeling

Entigy brings proven experience in modeling the right solution for your needs. From single subject-data marts, to federated data warehouses to Operational Data Stores (ODS), without the appropriate data model, everything else will suffer. Entigy's Data Modelers are skilled at gathering requirements and translating them into workable designs. We pride ourselves on understanding the client goals, missions, and business drivers to analyze and assimilate client requirements and develop corporate data models and associated metadata with standard industry tools. Specifically, Entigy's data modelers: · Defines conceptual, physical and logical data models · Administers model encyclopaedias · Supports data dictionaries · Estimates data volumes · Applies 'star' and 'snowflake' database design for the data warehouse repository · Predicts likely types of queries from needs analysis · Documents data definitions · Understands/applies data warehousing methodologies including multidimensional designs

4. Data Cataloging/Organizing

One of the key tenants of a successful data integration initiative initiative is consistency of information. It is a difficult process agreeing to common definitions and meanings of business items within the entire organization. For example, a customer should have the same definition, meaning and algorithm for all departments within the corporation. As reports are generated, less confusion will occur in interpretation of the results. This is important since some data will be the result of combining operational data from different systems thus creating new information that the business community is not familiar with. The complexity is multiplied when data can originate from outside the organization and in any number of formats (documents, websites, e-mails). Management of business definitions, uses and consistency of information is the job of the metadata repository that is the database that acts as a "card catalog" to the data warehouse.

5. Data Cleansing

Data Quality Analysts protect the integrity of your data resources by making data quality a key component of the business process. Suprisingly, studies have proven that an overwhelming majoirty of integration projects DO NOT have any type of inherent data quality strategy. Entigy's data quality consultants have hands on experience with data quality tools and strategies; conducting data quality assessments; determining accuracy, consistency, completeness, and integrity of data stored in source systems; evaluating quality and integrity of data required by end users to satisfy warehouse business needs; and identifying opportunities for data improvement

6. Data Access & Delivery

All the integration behind the scenes is only meaningful if that data is accessible and useable by the people who use it most. Our data access and delivery strategies ensures that all types of information structured, and un-structured regardless of file formats, can be inituitively shaped, enhanced, and enriched to deliver valuable personalized business data and content to support your business relationships be it customers, suppliers or strategic partners. Entigy's Business Intelligence resources can offer you the following skills: · Architecting, designing and implementing business intelligence (BI) solutions · Defining reporting and analysis requirements for data warehouses · Designing and developing Relational and OLAP reports · Business intelligence requirements definition · Facilitating training sessions for business users · Database modelling, analysis and tuning (i.e. efficient query execution) · Excellent presentation skills, both oral and written