Greetings, Click here to read my Amazon review of Ralph Hughes’ book on Agile DW for leaders. Well written and timely, it offers innovative, not widely-known methods for expediting the delivery of priority insights and of keeping your data infrastructure lean and responsive to evolving business needs. Daniel
Agile ModelStorming to Integrate BigData / NoSQL with RDBMS
Another published slide deck, presented in Huntington Beach at the recent SQL Saturday Event. To view the deck, click here. Viewer comments are always welcome!
Data Modeling for Integration of NoSQL with an RDBMS Data Warehouse
This post for data modelers, like a good portion of my online content, is in the form of published slides. To view them, click here. If you like them, feel free to subscribe here for the occasional new entry.
Snowflake’s Elastic Data Warehouse as a Service: Favorite Features
Since I am currently working with Snowflake Elastic Datawarehouse (see http://www.snowflakecomputing.com), and excited about what experts regard as it’s game-changing innovations (for a summary, see http://www.snowflake.net/blog/top-10-cool-things-i-like-about-snowflake/ ), I want to take a moment and describe my own personal favorite features. But first, some quick background: Snowflake is a built-for-cloud, MPP column-oriented, **ANSI-SQL-COMPLIANT** data warehouse service… Read More
Universal Data Vault: Hyper-Generalized Data Vault — Review of John Giles’ Case Study
I recently came across an interesting data-modeling case study. John Giles, who wrote it, is also the author of the insightful and — for us data geeks — entertaining book, ‘The Nimble Elephant’. In this UDV case study, John combined his strategy of applying, and establishing variations from, universal data-modeling patterns to Dan Linstedt’s Data Vault EDW methodology, with very practical results in a challenging… Read More
Lean Data Warehouse via Data Vault
Today, businesses want a data warehouse to be Lean. In contrast to many traditional data warehouses, a Lean Data Warehouse is simple, fast to deliver, automatable, free of over-complex dependencies, adaptive to business change, and thus quickly profitable. Data Vault is an outstanding logical architecture for a just such a Lean Data Warehouse. With a conceptual overview and a few medium-dive examples, this original article points the way forward. To… Read More
Just in Time (JIT) and Business Intelligence?
Here’s a quick link to a thoughtful discussion that relates to Lean Data Warehousing… Just in Time (JIT) and Business Intelligence
