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 LeapFrogBI.com 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 warehouses.
Pages to are hidden for
"In-Depth BI_ Data Warehousing Vs Data Marts"Please download to view full document