CompuTek Solutions
     
News
     
  CompuTek Solutions . has certified professional consultants to work with you to help

CompuTek Solutions .
 
 
 
 
 
  data warehousing > DataMarts and DWH
 

CompuTek Solutions Partners can make it easier to get departmental data to your Data Warehousing application, and get answers to your specific questions. CompuTek Solutions can easily handle large volumes of queries, delivering business intelligence to more business users.

Data Warehousing solutions must not only deliver answers quickly and accurately, they must also deliver answers to multiple users with differing interests. For example, an accounting department may be interested in the Return On Investment (ROI) of the latest direct-mail promotion, while the marketing department is more interested in analyzing the market penetration the promotion achieved.

Many financial organizations are also opting to build Data Marts specialized, single-line-of-business warehouses- which are often the most manageable realizations of the warehousing process. However, while data marts may be the right choice for immediate data analysis needs, building specialized data marts without first creating an infrastructure for a corporate wide Data Warehouse can cause trouble later. If the various data marts within an enterprise do not conform to a corporate standard, and the company decides that it needs to consolidate those data marts into an enterprise wide warehouse.

Data that will be of interest primarily to a particular workgroup, department, or business area can be segmented into data marts. Data marts enable easy distribution of data, provide higher availability and easier access to data, and can be used as a means to better manage business information.

In practice, the terms data mart and data warehouse each tend to imply the presence of the other in some form. However, most writers using the term seem to agree that the design of a data mart tends to start from an analysis of user needs and that a data warehouse tends to start from an analysis of what data already exists and how it can be collected in such a way that the data can later be used. A data warehouse is a central aggregation of data (which can be distributed physically); a data mart is a data repository that may derive from a data warehouse or not and that emphasizes ease of access and usability for a particular designed purpose. In general, a data warehouse tends to be a strategic but somewhat unfinished concept; a data mart tends to be tactical and aimed at meeting an immediate need.

 
 
Designed @ Computesk Solutions Copyright @ CompuTek Solutions  
Home | Site Map | privacy policy