All Posts By

Ivan Schotsmans

By |

Integrate Information Quality in your Data Warehouse Architecture

 

 

 

 

Abstract

The start of GDPR implementations in Europe was, for most organizations, also the start of rethinking their Data Warehouse strategy. The experience of past implementations gave a better view on the do’s and don’ts. One of the important lessons learned was the approach of handling information quality. It’s not something you handle on top of your data warehouse. To be successful, information quality goes hand in hand with your data warehouse implementation.

What you will learn

  • An architecture handling current and future challenges.
  • Moving to an agile approach implementing your “new” data warehouse?
  • Increase business involvement

Profile

Ivan Schotsmans is an experienced Data Specialist with 30+ years of experience. Ivan supports organizations in their data strategy but also in the real implementation of data warehouses, dashboards and KPI’s. His highlights from the past decade include: setting up and rolling out company wide data governance organizations and revamp data warehouses using Data Vault. He has a vendor neutral approach and is speaker on international conferences and driver of several user communities in the Benelux area.

DWA Special Interest Group

The DV-Community is a special interest group for anyone interested in Data Warehouse Automation. All skills and levels are welcome to this user group. We provide a meeting place for Data Warehouse Automation addicts to get information, share resources and solutions, increase networking and expand DWA expertise.

Agenda

 

Bill Inmon

By |

Bill Inmon

Modern data architecture

 

Abstract

Data Vault is but the latest branch of an ongoing evolution of data architecture. From the early IBM mainframe has sprung a sophisticated architecture that today includes Data Vault, data warehouse and other elements of architecture. Surprisingly, the biggest impediment to the architectural evolution has been the IT department.

This presentation discusses the evolution of data architecture – its past, its present and its future, along with the forces that move and shape that evolution.

What you will learn

  • The complacency of the IT department
  • Where we are going next – text, text, everywhere text
  • Who the buyer is in the organization – it’s not IT
  • Where does Data Vault fit in

Profile

Bill Inmon – father of data warehouse – has published 59 books and has had translations done in 9 languages. One of Bill’s books has sold over 500,000 copies worldwide. Bill has developed textual disambiguation, which allows text to be translated into a standard data base format. He is a Best-Selling Author & Scalefree Advisory Board Member.

Agenda

 

Francesco Puppini

By |

Francesco Puppini

Time travel using Qlik on Data Vault

 

 

 

Abstract

Information Marts are designed to make it easy for end users to consume data, no matter if it’s via a language, a cube or a BI tool. But when it comes to reading directly from the Business Data Vault, things become a bit more complicated. Satellites are capturing all the changes of a hub over time, and in some cases the end users may want to explore these changes in detail. With Qlik, thanks to the Associative Engine, it is possible to capture all the changes into a dashboard, and give to the end users the possibility to interactively choose a Point In Time. The presentation will include a live demo: how to travel in time by simply moving a slider.

What you will learn

  • The 3 main Qlik products: QlikView, Qlik Sense, Qlik Core. Brief explanation of the differences
  • The “Associative Engine” of Qlik
  • The SET Analysis: a powerful tool for filtering
  • How to use the SET Analysis on slowly changing dimensions
  • How to maximize the power of the Data Vault PIT information
  • How the dashboard end users can interactively travel in time across the Data Vault

Profile

Francesco Puppini is an Italian freelance consultant in Business Intelligence and Data Warehousing. He has worked on over 30 different projects across 10 Countries of Europe, for clients from several industry sectors. He is currently working as a Qlik specialist, after 18 years spent on Business Objects, SQL, Teradata and Data Modeling.

Agenda