Tag Archives: Data warehouse

BI on a napkin

One of the surest ways, tried and true, to achieve BI happiness, is to do it in a bar. Especially with a nice drink, in the evening, and a good companion. Don’t believe me? Just try it. Well, that is … Continue reading

Posted in BI At Large | Tagged , , , , , , | Comments Off on BI on a napkin

Handle semi aggregate measures in universes

While relatively simple data marts can be designed as true simple stars, more often than we like, our reporting data models contains snowflakes. Whatever you want to call these entities, they represent one basic problem for your reporting tools: Cartesian products. … Continue reading

Posted in Universe Design | Tagged , , , , , , , , , , | Comments Off on Handle semi aggregate measures in universes

Naming Conventions In The Data Mart

What you call things matter. It matters to you, and it matters to others who interact with you. When you name things, your project, your children, your children’s stuffed animals, you typically consider two perspectives: what YOU think the name … Continue reading

Posted in Data Warehousing | Tagged , , , | Comments Off on Naming Conventions In The Data Mart