3 AgileBI Things – Data Virtualisation, Agile Survey, Data Warehouse Automation

by | Dec 14, 2016

Shane writes an AgileBI series called “3 AgileBI Things” published on LinkedIN Pulse. This article below is a copy of “3. AgileBI Things – 2016-10-31“.  Shane also writes on AgileBI concepts at AgileBI Guru.

1. Data Virtualisation

Looks to me that data virtualisation is starting to get legs as a possible technical solution in data warehousing. We are doing a bit of experimentation on virtualising dimensional stars off the Data Vault structures to reduce the latency and effort required to deliver data to users.
Short article here:
The Logical Data Warehouse Architecture is NOT the same as Data Virtualization
The gold is this statement:
“To summarise: Data virtualization technology relates to a logical data warehouse architecture the way a SQL database server relates to a data warehouse or data mart”

2. Agile Survey

Scott Ambler is a guru in the world of Agile and is a voracious publisher of content. Help him out by taking his online survey to help him publish more great content.
November 2016 Agile State of the Union Survey

3. Data Warehouse Automation

We are working on the next major feature of http://ODE.ninja focussing on automating derived columns and Same as Links.
I’m completely sold on the idea of DW Automation. Not so much automating the endless data flows created by developers like most DW Automation products, but by using configuration to automate the 80% of the code that conforms to standard patterns. In my head, DW Automation should be as easy as WordPress.
The table in this article does a great job of articulating the benefits of DW Automation for both development and operations.
Automate the Boring But Essential Parts of Your Data Warehouse

About Shane 

When the team have time I am nagging them to add new cool features to ODE, our open source data vault automation engine at ode.ninja.
Most of my time is actually spent teaching and coaching customers how to deliver using AgileBI as part of the Optimal Orange team.
We run regular Agile courses with a business intelligence slant in both Wellington and Auckland, you can learn more about these here.

0 Comments
Submit a Comment

Your email address will not be published. Required fields are marked *