Data Preparation Is Easy with Alteryx

Without support from I.T., analysts increasingly need to perform data preparation tasks of varying complexity in order to wrangle data into shape for current analytic needs.  Using Alteryx Designer, many such tasks are simple and intuitive.  Let’s consider an example. For the completed Alteryx workflow sample published in Alteryz product documentation, assume that, due to… Read More

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 I 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 personal favorite features.  But first, some quick background:  Snowflake is a built-for-cloud, MPP column-oriented, **ANSI-SQL-COMPLIANT** built-for-cloud 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