The Value Of Properly Developed Data Warehouses (7) .pdf
Original filename: The Value Of Properly Developed Data Warehouses (7).pdf
Title: The Value Of Properly Developed Data Warehouses
This PDF 1.4 document has been sent on pdf-archive.com on 19/09/2012 at 23:13, from IP address 188.126.x.x.
The current document download page has been viewed 841 times.
File size: 83 KB (2 pages).
Privacy: public file
Download original PDF file
The Value Of Properly Developed Data Warehouses
For those who are brand-new to the whole idea of business intelligence and the uses of data
warehouses and data marts, the explanations one normally locates can be extremely complex and
practically completely incomprehensible. In today's business environment not only does one need to
have a lot of business savvy, they also have to at least have a working understanding of on-line
information storage space and retrieval.
As a lot of business individuals already recognize business intelligence is the collecting, analyzing
and saving of data that has an impact on every level of the business enterprise. However, in order to
put that information to great usage, those who perform certain tasks within the business ought to be
able to recover the information they require rapidly. They make use of the data that is stored in data
banks for this application.
Data marts are data banks within a company that are maintained by the numerous divisions of the
company and normally hold data concerning that division. This data is accumulated from specific
sources. These sources can be internal departments, a primary data warehouse or external
resources. Every division like finance, sales or marketing would have their very own data mart vs data
warehouse project which would include data concerning their area of operations.
The reason for having these specific data marts for the numerous divisions makes it much easier for
every division to analyze the data because it pertains only to their division. This makes it quicker and
much easier to not only access the data but also in quick decision manufacturing. In today's business
industry in order to be competitive, informed choices have to be made on a regular basis in order to
locate solutions to challenges or to stay clear of complications. Business intelligence deals with the
sorting of the data in these data marts and delivering that data so that it can be made use of to make
the choices required.
Data marts are typically of two kinds, independent and dependent. Independent data marts are stand
alone systems that gather their data from operational systems or external sources or both. This data
has to be moved from the sources, filtered then collected in the data mart. Independent data marts
typically can provide answers to issues in a much briefer timeframe.
Dependent data marts however, collect their data from streamlined data warehouses. This data is
typically clean and formatted for usage. The reliant data marts have only to identify the pertinent data
and move it into their data bank. Dependent data marts have the benefit of local access to the data
for the pertinent division which helps in improved performance and availability and much better
control and lowered prices.
Data marts assist business intelligence by having the ability to deliver the necessary data about their
division rapidly in a kind that makes decision making quick and effortless.