Schedule Meeting

a
Primary keys in Data Warehouses

Primary keys in Data Warehouses

In my recent webinar Designing a schema for a data warehouse, I was asked a question that deserves a long answer. I recommended to use IDs generated directly in the data warehouse. In other words, even if you import customer data from a MySQL database and each...
Data warehouse benefits and use cases

Data warehouse benefits and use cases

Recently I talked to many companies about this topic: why a data warehouse is essential to support company decisions, in all departments. I decided to summarise my points in this article, for future reference. The need for centralised information All company...