In-Depth BI_ Data Warehousing Vs Data Marts by Seemase164


More Info
									In-Depth BI: Data Warehousing Vs Data Marts
Over the years of doing business, organizations accumulate large quantities of data about their
customers, suppliers, products and services. This accumulated data and resources are used by
business intelligence for making decisions that can give them significant commercial advantage.
Business intelligence uses many different computer programmes and tools to sift through this data
and analyze it to find trends, patterns and correlations that can help them understand the data and
guide in decision making.

Data Warehousing Advantages

The collection of this data in one place from different sources and different data bases so that it can
be stored and used for further analyzing is known as data warehousing. Usually the data stored in a
data warehouse is from the various departments that form the organization. This data may be both
historical as well as current. Since all the data is stored in one place it is homogenous and can be
manipulated easily. The amount of data that is stored in a data warehouse is dependent upon the
system and how much data it can handle.

Many organizations use their data warehouses to bring together data from various departments in
their organization. But the drawback can be that this data may be too much to make analysis easy.
To address this problem many organizations break down the data according to the various
departments and have each department collect data into one data bank. These data banks are known
as data marts. Each data mart contains data pertaining to that particular department. The data
collected in a data mart is collected for a specific department for specific purposes and this data is
therefore in a format that can be easily accessed as well as easily processed. A data warehouse can
be a collection of all the data marts in one centralized location with all the data being correlated and
processed into one format.

Departmental Data Marts

Using a data warehouse which is made up of various data marts of all the departments in the
organization makes it easier for the business intelligence department to correlate the data that they
require, whether it is from one data mart or from various data marts, to make the analysis of the
trends for strategic planning and making forecasts. Another advantage of having a data warehouse
made up of various data marts is that the various departments can access the information they might
need from another department easily. One company that is amazing at data mart automation in
accelerating your BI project is as they truly save significant costs on any SQL Server
Integration Services project.

Data warehouses are usually central data storage centers which can be made up of data from various
sources, while data marts store data from individual departments which together can form the data

To top