Category Archive: Data warehousing

Data warehousing

The Elastic Data Warehouse

Some days I get really flexed out of shape about the rate at which new terms become spontaneously combusted in the BI and analytics industry. The latest I came across is the term “elastic data warehouse.” So what are we doing here – bending the rules, stretching the imagination or flexing our muscles here? Now …

Continue reading »

Using a Modern Analytics Platform

The increased use of analytics, coupled with an exponential growth in the volume and complexity of data, has changed the business intelligence landscape forever. Business users’ sophistication has extended beyond descriptive reports and dashboards into data exploration, predictive modelling and aspects of cognitive computing. Traditional requirements-driven ETL, data warehouse and reporting approaches do not meet …

Continue reading »

Accidental Data Warehouse

In many organisations we find what is called the “accidental data warehouse”. Sometimes you may even find more than one such data store floating around. These data warehouses have typically grown organically and uncontrolled as the result of separate and uncoordinated BI development and implementation initiatives.

Continue reading »

Dimensional Models for Predictive Analytics

Even though it has been around for years, predictive analytics has seen a much stronger uptake over the past few years. For example, store owners are now trying to predict what products their customers will buy and which products should be taken off the shelf completely; marketers are interested in analysing customer sentiment; telcos need …

Continue reading »

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 »

Building a Data Lake

The engineering analogy to building a data lake carries quite well. Putting a data lake in place is about as complex as building a man-made lake – there are so many aspects to consider. In this post I comment on some of the wisdom that have been published about building and populating data lakes. At …

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 »

The Seven Deadly Sins of Data Warehouse Design

A recent white paper from Embarcadero Technologies on the seven deadly sins of database design triggered me to write this post – as similar principles can be applied to dimensional data warehouse design. Some of the sins are vaguely similar to those encountered in relational data modelling, but the other sins are very different and …

Continue reading »

Older posts «