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 above completed Alteryx workflow sample published in Alteryz product documentation, assume that due… Read More
My most recent customer gave me a chance to exercise Tableau Version 9’s features, for both the Server and Desktop Professional. Early on, an analyst asked me to do something rather interesting with calculations in a workbook. Because the source data was not transformed sufficiently to directly surface crucial data, Tableau was being used to… Read More
Greetings, Click here to read my Amazon review of Ralph Hughes’ book on Agile DW for leaders. Well written and timely, it lays a clear path toward future-proofing our data. Daniel
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!
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.
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
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
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
Here’s a quick link to a thoughtful discussion that relates to Lean Data Warehousing… Just in Time (JIT) and Business Intelligence