Hello everyone, this post is about 2014 and Data Vault 2.0 – it’s been a long time in the making, and I am finally beginning to release information about the standards, best practices, what it contains (what it doesn’t), how to get Certified as a Data Vault Certified Practitioner, and so on.
I’ve been extremely busy, so first I must apologize to my fans and readers for not posting or blogging for quite a long time. I have a TON of announcements coming soon, so bear with me. But for now, I am announcing the following:
DV2.0 – What it is…
Data Vault 2.0 is the evolution of Data Vault. Data Vault 2.0 is a system of business intelligence and data warehousing that goes beyond just the Data Vault model. Data Vault 2.0 is comprised of four major pillars:
- Architecture – systems and ETL, along with Big Data, and NoSQL inclusion
- Methodology – Project management, standards, best practices, agile build out, SCRUM and SEI/CMMI Level 5
- Implementation – rules and procedures, standards, BPEL, BPM,
- Modeling – of course the Data Vault Model has evolved, Ontologies, Concept Models, Data Models
A big big part of the release is the inclusion of NoSQL platforms, the ability to seamlessly interconnect these various platforms (hybrid, relational, non-relational, columnar, text, etc..) with your existing data warehouse. Also, with the release come the following key concepts:
- Big Data – changes to the model to support Big BIG data sets (hyper data sizes / extreme data sizes) in to the petabyte ranges
- Function point counting techniques, estimating rules and standards, risk mitigation strategies
- Ontology modeling concepts for Business Keys, fact based modeling inclusion and rules/standards/patterns for building those artifacts in to the Data Vault model
- Automation – utilizing tooling (what when, why, where, how) – and the best practices for auto-generating as much of the data warehousing processes as possible
- Business Rules Engines & Real-Time processing – turning your Data Vault warehouse in to a self-sustaining operational Data Vault or enterprise asset that is kept up to date in real-time
- Write-back techniques – how to handle, where to handle them, patterns – what to do with the data
- Managed Self-Service BI – how it fits, how to enable it for your business, what it means
- Virtualization of Data Marts – why it works, how to make it happen, automation components
- Security and Data Protection – with the big data come big risks… you’ll want to know how to manage those risks
- Agility !! Rapid 2 week delivery time frames, fixed-cost / fixed time deliverables leveraging automation and Data Vault 2.0. I’m working with Scott Ambler on this one, he has agreed to review the materials in the DV2.0 Boot Camp and Private Certification course, and to assist me with edits where necessary.
- Mixed Modeling Aspects – what to do with Logical Data Models, when and where to mix and match with Data Vault
And lots lots more…. So you can see, Data Vault 2.0 is a system of data warehousing and business intelligence. It defines the “who, what, how” to make your team agile and successful. It really pulls the whole package together. I think most of you will be pleased with the outcome.
Some of the finer points will be introduced in the upcoming World Wide Data Vault Consortium this year. (there’s still time to register)
Data Vault 1.0 was highly focused on Data Modeling for your data warehouse, Data Vault 2.0 is truly an evolution.
DV2.0 training and certification
Yes, there is training. I am pleased to announce the following high powered courses for everyone: (these classes will be available both on-line, and in-person)
- Data Vault 2.0 Boot Camp and Private Certification – this class is a 3 day intensive course that covers a lot of ground (many of the topics listed above). It really teaches you how to be a general practitioner, and enables you to implement Data Vault 2.0 successfully within your organization. CDVP2 (Certified Data Vault 2.0 Practitioner) is available privately for those who complete this course.
- Advanced Data Vault 2.0 Boot Camp and Private Certification – For those of you with experience in Data Vault 1.0, or already certified in Data Vault 1.0, you can take this course. This is an intensive 2 day class covering ONLY the new pieces, and the new knowledge you need to bring your qualifications up to speed. You do not have to be “certified” in Data Vault 1.0 to take the CDVP2
- Data Vault 2.0 Modeling (Introductory, Intermediate, Advanced) – I will be offering three different flavors of classes around JUST the Data Vault Modeling components. These classes will be available only on-line, they will also be highly focused on Hands-On Exercises and workshops to give you practical application experience.
You do NOT need to be already certified in Data Vault 1.0 in order to take any of these courses. Nor do you have to be already certified to take the Private DV2.0 Practitioner Certification Exam.
In order to earn your CDVP2, you *must* contact us directly to setup a private certification.
You can find out more (we are currently changing and updating the site) about private certification by going to: http://DataVaultCertification.com
Will there be other training?
Yes. I have a host of other classes I am bringing to LearnDataVault.com The following classes will be brought on-line. If you are interested in signing up early, and getting a discount off the retail price, please let me know. If you are interested in detailed agendas of any of these courses, please contact me directly.
note: run-times subject to change, contact us for pricing details
|Class||# of Days|
|Agile BI Visions
About This Class: This class is an introductory course. It sets the tone for the students as well as the business users. It defines the issues, the market pressures, and pains of current enterprise BI solutions. This course also sets the tone for the recommended solutions, and helps to explain why Data Vault 2.0 meets those needs.
|Defining the BI Platform
This class is an introductory course. It focuses on the base definitions of the critical components of all B.I. solutions: DV2.0 Model, DV2.0 Methodology, DV2.0 Architecture, and Managed Self Service B.I. These topics are handled at an overview level with some deep dive in to the technical definitions. The second section of this course dives in to the KPA’s and KPI’s of a proper BI solution, discussing Estimates & Actuals, Governance, Roles and Responsibilities, and concludes with an introduction to Automating your Data Warehouse.
|Architecture in Depth
This class is an in-depth look at the B.I. landscape of architecture. It covers: data architecture, and systems architecture – both Data Vault and Kimball style BI solutions. It discusses positioning, definitions, and best practices, while comparing and contrasting the different architectural components. The main topics include defining: staging areas, EDW, data mart layers, NoSQL layers, Metrics Layers, and Metadata Layers. Each section dives in to best practices, practical application, and proper definition (where it fits), and what it should store – and how it should be utilized.
|Methodology in Depth
This class is an in-depth look at the DV2.0 methodology. It focuses on agility, practical application and delivery, 2 and 3 week sprint cycles. In other words – it teaches HOW-TO make all of this work. The topics it discusses include: technical numbering, agile requirements gathering, agile project plan (WBS), Mapping Requirements to Data Sources (DBS), Mapping Business Processes to Projects (PBS), Organizational Roles And Responsibilities (OBS), KPI’s and KPA’s of Data Warehousing, Optimizing your processes, parallel teams, scope control, and automating your EDW (overview).
|Advanced DV2.0 Boot Camp
This class is an in-depth look at upgrading your DV1.0 system to DV2.0. This course covers ONLY the new components (what they are), and where they fit. It also talks about the changes to your Data Vault 1.0 Model that are necessary to bring it in to compliance with DV2.0. Topics include: Physical modeling pieces (hashing etc..), Ontologies, ETL & SQL Processing, Write-Back, and some Advanced DV2.0 Modeling cases. This course dives in deep in to the technical implementation of DV2.0, anyone with prior working knowledge of DV1.0 will find this course beneficial. ** this is a prerequisite to DV2.0 Private Certification for those with DV1.0 Certification, or DV1.0 experience **
|Defining the Business Vault
This class is an in-depth look at a component of DV2.0 called the Business Vault. This course defines and introduces the concepts of Business Vault, and discusses the various components. It also talks about how to build the Business Vault, and the benefits it carries with it. The course dives in to physical modeling components, business ontology application, and master data pieces. The course finishes up with a discussion on Managed Self Service BI & write-back.
|Creating a Historical Vault
This is an intermediate class. It covers some out of the box ideas around how, when and why to load historical data. It discusses interesting aspects of adjusting the DV2 model to meet the needs of the historical data, along with combining historical data in the data mart layers for business presentation purposes.
|Intro: Building Marts from Vaults
This is an introductory class, the goal of this class is to help students get their feet wet with building, loading two data mart models: flat-wide and dimensional. The students will use SQL, the examples used in class will be made available for download by the student – for use with hands on. The DDL, and the data sets for the Data Vault will be made available for hands-on. The database used will be SQLServer R2 2008. The students should be able to translate that to any database they wish, or download SQLServer Express and try it there.
|Intermediate: Building Marts from Vaults
This is an intermediate class, the goal of this class is to help students become familiar with GAAP principles, reconciliation, business rules, eventual consistency; along with handling error marts, report collections, and incremental change application to existing fact tables. The students will use SQL, the examples used in class will be made available for download by the student – for use with hands on. The DDL, and the data sets for the Data Vault will be made available for hands-on. The database used will be SQLServer R2 2008. The students should be able to translate that to any database they wish, or download SQLServer Express and try it there.
|Advanced: Building Marts from Vaults
This is an advanced class, the students will work with hands on examples, and discuss security, cubes, redaction, business process management, reconciliation, fuzzy logic and master data. The database used will be SQLServer R2 2008. The students should be able to translate that to any database they wish, or download SQLServer Express and try it there.
|Transitioning to DV2.0
This class is an intermediate to advanced overview that focuses on what you need in order to transition in to a DV2.0 solution. It discusses the starting states of “federated star schemas as EDW’s” and “normalized models as EDW’s”. The course goes through what you need to know to get going in DV2.0. How to kick start, possible pit-falls, things to consider before beginning your DV2.0 project. This is a preparation course for those considering a DV2.0 solution.
|DV2.0 Performance and Tuning
This class is an in-depth look in to performance and tuning components for the DV2.0 model and architecture. It’s focus discusses MPP, SMP, Normalization, mathematics, data co-location, partitioning, ETL/ELT parallelism, clustering, load balancing, I/O storage, indexing, and structure layout. This course is for those who want to maximize their data ingestion and retrieval rates. EVEN IF YOU DON’T HAVE A DATA VAULT, you will find value in this class at a data architecture level.
|Applying Test Cases to Data Vault 2.0
This class is an in-depth look in to testing in the DV2.0 model. We discuss generic test cases, and offer specific How-To instructions on getting the most out of your testing paradigms in a DV2.0 modeling environment. We discuss different test types, how to test, ensuring results, generating test data, and performance testing.
|Intro: Data Vault 2.0 Modeling
This class is an introductory course, meant to help the team get started in Data Vault 2.0 Data Modeling. It covers the basics of what a Data Vault 2.0 Model is, how it functions, and contains a hands-on example case for practitioners to get familiar with the ideas and concepts.
|DV2.0 Boot Camp & Private Certification
This class is an introductory and intermediate class that takes you through the why/what/how of Data Vault 2.0. It includes the coverage of the business justifications, then follows with the technical descriptions of the architecture, implementation, methodology, and modeling. The course finishes with descriptions on ETL design time paradigms, including templates, best practices and working SQL. This class is a prerequisite for anyone wishing to achieve DV2.0 Certified Practitioner status. Certification is available privately after the course is completed.
|DV2.0 for Business Analyst and Data Architect
The purpose of this class is to provide a high level overview of the Data Vault 2.0 architecture, methodology, and model; along with comparing and contrasting specific points in each with “traditional” or “Legacy” data warehousing constructs. It will provide enough information for the Business Analyst to understand and guide Data Vault 2.0 projects.
|Tool Based: Automating DV2 ETL with Mapping Manager
This class is an introductory look at using Mapping Manager to handle cross-reference specifications. It then walks you through examples and teaches you how to generate Data Vault 2.0 code using the provided code-generation templates.
|Tool Based: Automating Test Data with Mapping Manager and RowGen
This class is an introductory look at using Mapping Manager to generate test data for specific Data Vault 2.0 cases. It provides examples around custom business rule formulation in order to “automatically” generate specific test cases needed for your environment. The generated code is actually script, that is then run through RowGen to produce the end-result test data.
|Tool Based: How-To Build Code Gen Templates for Mapping Manager
This class walks through an introductory level to get you started in writing code-generation templates for Mapping Manager. You can think of this course as the “hello world” side of code generation. You are given a working code-generation template that you can use in your own environment to experiment with.