3.

A data warehouse is a general structure for storing the data needed for good BI
(Business Intelligence).

Data in a warehouse is of little use until it is converted into the information that decision
makers need.

The large relational databases, typical of data warehouses, need additional help to
convert the data into information.

In data warehouse we have two kinds of data
and

4.

Measures are the key performance indicators that you want to evaluate.

To determine which of the numbers in the data might be measures, here
is a rule of thumb:


If a number makes sense when it is aggregated, then it is a measure.
Examples
 Salary
 Utilization
 Sales

5.

Dimensions are the categories of data analysis.

Here is the rule of thumb:
 When a report is requested "by" something, that something is usually a
dimension.

Examples
 Employee
 Geography
 Department
 Products

6.
What is EIM – Enterprise Information Management
The set of capabilities enabling the
enterprise to get the right data to the right
consumers, reliably, repeatedly, efficiently &
with high confidence.

10.
What is SQL 2012 DQS ?
Data Quality Services (DQS) is a
Knowledge-Driven data quality solution,
enabling IT Pros and data stewards to
easily improve the quality of their data

11.
Knowledge Bases
• To prepare knowledge for a data quality project, you build and
maintain a knowledge base (KB) that DQS can use to identify
incorrect or invalid data.
Domains
• Knowledge in a knowledge base is maintained in domains,
each of which is specific to a data field.
Knowledge Discovery
• A computer-assisted process that builds knowledge into a
knowledge base by processing a data sample

18.
Conclusion
Enterprise Integration Management (EIM) provides an a
portfolio of solutions that enable organizations to trust the
credibility and consistency of their data so they can make
critical business decisions.