Security for data warehouses

Sep. 8, 2015 by

…there is a constant tension between securing data and making information accessible. I encounter this trade-off at every client. Unfortunately my clients are usually addressing this dispute as a cold

Thoughts on TDWI’s “Hadoop: A slam-dunk DM platform”

Aug. 25, 2015 by

As a Business Intelligence Architect, I appreciate Hadoop as a powerful tool in my arsenal. Hadoop is the right tool for massively-parallel processing of Big Data. But Hadoop is not

How to pass parameters to a SQL view

Aug. 18, 2015 by

Have you every wanted to pass a parameter to a view? It’s a standard request that can be a bit difficult to implement. … Unfortunately, there are more than a

Documentation Debt

Aug. 6, 2015 by

If we did no documentation there would be chaos. … Documentation Debt is the concept that we want to focus on. … Every document needs to provide value that exceeds the

How decision dimensions empower analysts and simplify development

Jul. 28, 2015 by

In Business Intelligence we often have complex logic for categorizing facts. We also have even more compelling reasons to use decision tables for these calculations. They make the logic behind