Why a Data Warehouse?
If Business intelligence is described as...
"a set of techniques and tools for the acquisition and transformation of raw data into meaningful and useful information for business analysis purposes"
...then the Data Warehouse exists at the very core of a Business Intelligence solution.
What is a Data Warehouse?
A Data Warehouse, as the name suggests, is a specialised database containing a massive collection of information from across an organisation, usually consisting of data from a diverse range of operational business systems. The information is clean, structured, and easily accessible. A data warehouse is often referred to as the:
"one source of truth"
Masses of Information, data complexity and business rules...
It is imperative for report writers to get truthful information to decision makers. Imagine a world where every business process nuance, or data artefact, or complex data process had to be expertly known by each new report writer that your organisation has to provide business critical information. Not ideal. There is a solution.
Accurate. Reliable. Consolidated.
By the time data reaches an organisation's Data Warehouse, complex data anomalies, business processes and other impurities will have been error-checked, stage-gated, curated, audited and endorsed; leaving only business information in it's purest form, which enables trust in critical data. From there report writers, analysts and all other information specialists are utilising Accurate Reliable & Consolidated information, regardless of their subject matter expertise, skill level or attention to detail.
DATAMetrics know Data Warehousing. We have built and maintain dozens of DWs, and they are the single most powerful tool available to any BI solution. An organisation’s BI capability is often only as good as the data warehouse that feeds information to business users, and we know what good looks like.