Avnet® Technology Solutions
Avnet Client Solutions - Your leading Software Solutions Provider

Contact Finder

Avnet contacts found : ?

Data Warehouse Explained

Data Warehousing is the main repository of the organisation's historical data, its corporate memory. For example, an organisation would use the information that's stored in its data warehouse to find out what day of the week they had the most transactions in May 2010 or how employee sick leave the week before Christmas differed between Dublin and Galway in 2010.

In other words, the data warehouse contains the raw material for management's decision support system. The critical factor leading to the use of a data warehouse is that a data analyst can perform complex queries and analysis (such as data mining) on the information without slowing down the operational systems.

Contact Us to Learn More

Data Warehousing Ireland

While operational systems are optimised for simplicity and speed of modification (online transaction processing, or OLTP) through heavy use of database normalisation and an entity-relationship model, the data warehouse is optimized for reporting and analysis (on line analytical processing, or OLAP). Frequently data in data warehouses is heavily denormalised, summarised and/or stored in a dimension-based model but this is not always required to achieve acceptable query response times.

What is a Data Warehouse?

  • A Data Warehouse is a set of data structured for Query and Reporting purposes
  • Typically contains multiple data sources
  • Consolidates data from these sources
  • Provides point-in-time reporting
  • Can tell you what did or did not happen, or when it happened?

Ask the experts

Business Intelligence team 

Avnet Client Solutions

+353 1 6204825

Dominic Muldoon

Business Intelligence Team

353 (0) 87 900 75 88

Software Development Services
Accelerating your success

Avnet on Google+ Follow Avnet Client Solutions on LinkedIn Avnet Client Solutions Press RSS Follow Avnet Services EMEA on Twitter

We use cookies to ensure that we give you the best experience on our website. If you continue without changing your browser settings we will assume that you are happy to receive all cookies on the Avnet Technology Solutions website. However, if you would like to, you can change the cookie settings of your browser at any time. To find out more about the cookies, see our Privacy Policy and Cookie Statement.