O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Model-Driven Data Warehousing

Video Description

Organizations can implement their Business Intelligence solution automatically, based on corporate data models and business rules. No programming or coding is needed anymore, nor is technical modeling of optimized structures for Data Warehouses and Data Marts Databases. This saves time and money, and increases quality and consistency. In general, modelers are working on Staff-level. They define the model, business rules, meta-data, etc. They hand it over to different IT teams, including BI / DW teams. The BI / DW teams start to work and, at best, use the document from Staff as a guideline. They often lose track with the model and start making changes without any alignment to the model anymore.

Model-Driven Data Warehousing solves these issues. Based on the model, the complete implementation (Design of Data Warehouse (3NF and/or Data Vault) and Data Marts (Star-schemas), plus the generation and execution of ETL-code) is automated. And when changes need to apply, a simple “update” of the model adjusts the Data Warehouse automatically.

Creating a logical data model gives you a Data Warehouse in just a few clicks. With consistent management information available, technical complexity and challenges are no longer delaying your business advantage. Better alignment between the business and IT can also be achieved through this model-driven approach. From a Corporate perspective this will bring more control and consistency at the implementation of business rules, meta-data standards and correct definitions of KPIs. From a developer’s perspective the backlog of work is decreased, unsatisfied and impatient customers are no longer frustrated, and you don’t have to redo your own work over and over for each change. The technical, time-consuming and error-prone activities are automated for you.

You finally have achieved an agile Data Warehouse: Flexible, Incremental, Fast, Cost effective. With shorter time to market due to the efficiency and productivity improvements, you gain a significant competitive advantage. Data modeling not only ensures that your business intelligence solution will be built more quickly and effectively, but that the underlying information that drives them is correct and fully documented. Usher in a new era in Data Warehouse automation by automatically designing and generating the Enterprise Data Warehouse code for Third Normal Form and/or Data Vault as well as Star Schema data marts and staged data for Business Intelligence projects.

Table of Contents

  1. Model-Driven Data Warehousing 00:27:00