what is data warehouse???

Relational Database contain information
in a series of two-dimensional tables.

In a data warehouse and data mart,
information is multidimensional, it contains layers of columns and rows.
Dimension
– a
particular attribute of
information.

Once a cube of information is created, users can begin to slice and dice the cube to drill down into the information.
Users can analyze information in a number of different ways and with number of different dimensions.

Business
intelligence
refers
to applications and technologies that are used to gather, provide access,
analyze data, and information to support decision making effort.
these systems will illustrate business intelligence in the areas of customer profiling, customer support, market research, market segmentation, product profitability, statistical analysis, and inventory and distribution analysis to name a few
Eg : Excel , Access
No comments:
Post a Comment