In computing, a data
warehouse (DW or DWH), also known as an enterprise
data warehouse (EDW), is a system used for reporting and data analysis, and is
considered a core component of business intelligence. DWs
are central repositories of integrated data from one or more disparate sources.
They store current and historical data in one single place that are used
for creating analytical reports for workers throughout the enterprise.
3.The data stored in
the warehouse is uploaded from
the operational systems (such
as marketing or sales). The data may pass through an operational data store and
may require data cleansing for
additional operations to ensure data quality before
it is used in the DW for reporting.
The typical Extract, transform, load (ETL)-based
data warehouse
4. uses staging, data integration, and
access layers to house its key functions. The staging layer or staging database
stores raw data extracted from each of the disparate source data systems. The
integration layer integrates the disparate data sets by transforming the data
from the staging layer often storing this transformed data in an operational data store (ODS)
database. The integrated data are then moved to yet another database, often
called the data warehouse database, where the data is arranged into
hierarchical groups, often called dimensions, and into facts and aggregate
facts. The combination of facts and dimensions is sometimes called a star schema. The access layer
helps users retrieve data.
The main source of the data is cleansed, transformed,
catalogued, and made available for use by managers and other business
professionals for data mining, online analytical
processing, market research and decision support.
Need of datawarehose
in modem business…
·
Better decision-making – Corporate decision makers will no longer have to make important
business decisions based on limited data and hunches. Data warehouses store
credible facts and statistics, and decision makers will be able to retrieve
that information from the data warehouse based on their personal needs. In
addition to making strategic decisions, a data warehouse can also assist in
marketing segmentation, inventory management, financial management, and sales.
·
Quick and easy access to data – Speed is an important factor that sets you above your competitors.
Business users can quickly access data from multiple sources from a data
warehouse, meaning that precious time won’t be wasted on retrieving data from
multiple sources. This allows you to make quick and accurate decisions, with
little or no support from your IT department.
·
Data quality and consistency – Since data warehouses gather information from different sources
and convert it into a single and widely used format, departments will produce
results that are in line and consistent with each other. When data is
standardized, you can have confidence in its accuracy, and accurate data is
what makes for strong business decisions.
A data warehouse is essential for any
business that wants to profit from sound business decisions. If you’re looking
to implement a data warehouse into your business, give us a call today.
0 comments:
Post a Comment
Let us know your responses and feedback