Tag Archive: data warehouse

Revolt against the Data Lake as Staging Area

In previous posts I covered the data lake, approaches to “building” the lake and the data lake’s relationship with the traditional data warehouse. However as rosy as all that may seem, there are some people quite opposed to using the data lake as an all-encompassing free-for-all at-scale staging area. To an extent, I tend to …

Continue reading »

Data Lake vs Data Warehouse

In a previous post I gave a high level description and overview of the data lake. Informally speaking, from a BI point of view, a data lake is a large scaled-out all-encompassing free-for-all unstructured data staging area. In this post I take the discussion further to investigate whether it replaces or interacts with the data …

Continue reading »

Uplifting BI Capability to Business Strategy

In this post, I’m looking at approaches to lift BI up from a mere enabling IT function to an enterprise strategic business function. This is an elaboration on discussions that were recorded in TDWI’s BI Journal, Vol 18 No 4 (http://tdwi.org/research/2013/12/business-intelligence-journal-vol-18-no-4.aspx), around aligning BI with business strategy. I have previously also published a post on …

Continue reading »

Big Data and the BI Ecosystem

The Big Data movement is transforming long-established data warehouse architectures into multifaceted analytical ecosystems, in which the time dimension has also seen been ratcheted up a few notches. In the good old days data was extracted from operational systems, batch-processed through a data warehouse, transformed to information and delivered to a relatively small group of …

Continue reading »

Big Data Warehousing & Business Intelligence Summit

I have just returned from attending the 5th Annual Big Data Warehousing & Business Intelligence Summit, organised by Enterprise IQ, held in Sydney on 27 – 29 November 2012.  I participated in two panel sessions, firstly as a panelist on doing business in the Big Data age, and secondly moderating the session on the architectures …

Continue reading »

Data Quality vital for sound BI decisions

The success of every decision is closely related to the quality of the information that was used to make that decision. For this reason, Data Quality is very closely related to Business Intelligence. Data quality checks and active data quality controls should be embedded into the loading and reporting processes. This can ensure the quality …

Continue reading »

Handling the Data Explosion

There is an enormous amount of data around, and much of it in data warehouses. We question the realities and discuss the approaches to keep the data warehouse to a handleable size, without reducing the availability of any historic data and without suffering any loss of data and information.

Continue reading »