In case you are wondering where I’ve been, I’ve been working hard on brand new course-ware for 2014. All about Data Vault 2.0. Including unstructured data, NoSQL, columnar stores, Big Data and more. Some of the more exciting advancements offer performance gains in the Data Vault 2.0 Model of 10x to 50x (over DV1.0 models). Here’s a sneak peak of the courses I’m putting together…
Class 1: Agile BI Visions: 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.
Class 2: Defining the BI Platform: this class will discuss new DV2.0 modeling components, introduce the agile methodology, the architecture and managed self service BI. It will then walk you thrugh the basics of DV2.0 projects including: KPA’s & KPI’s (what to measure and how), governance, roles and responsibilities, and automating the DV2.0 system.
Class 3: Architecture In Depth: will cover each segment of a Data Warehousing system, including DV2 Staging and Kimball PSA, DV2 EDW and Kimball EDW, Data Mart Layers, NoSQL Layers, Metrics Layers, and Metadata Layers. It will cover the similarities, definitions, comparisons and contrasts of each. It will also provide definitions for what these components need to be and why.
Class 4: Methodology in Depth: will cover the agile project methodology. Including: technical numbering, agile requirements gathering, agile project plan, mapping requirements to data sources, business processes, organizational roles and responsibilities, KPA’s & KPI’s, optimizing the process, parallel teams, team sizing, scope control, 2 week deliveries, and automating the EDW
Class 5: DV2.0 Modeling Upgrades (NOTE: due to legal reasons, we will not be teaching CDVDM – if you want Modeling Certification, you must get that elsewhere).
HOWEVER… we will offer a Data Vault 2.0 Fundamentals class – which will be focused on DV2.0 Modeling only, it will NOT offer certification in Data Vault Modeling.
This class will cover what you need to implement new DV2.0 structures, physical modeling changes, modeling using ontologies, upgrading ETL & SQL Processes, handling data mart write-back, Managing master data applications, and advanced DV2.0 Modeling (Satellite Effectivity, Status Tracking Examples, managing time zones, currencies, and calculated fields in PIT and BRIDGES.
Class 6: Defining the Business Vault: this class will not only introduce you to the business vault, but help you define it, identify it, and provide you with the necessary hands on expierence to build one. This class is still being flushed out, if you want specific topics in this course, please post them in the comments below.
Class 7: Creating the Historical Vault: this class will cover: requirements and needs, loading and analysis, backup and restoration, metadata vault, and metrics vaults.
Class 8: Building Data Marts: this class will focus in on how to properly build and load data marts. Topics include: golden rules to follow, virtual marts, physical marts, application of business rules, GAAP principles (dual entry accounting applied to data marts), re-loading parts of the data mart, real-time alerts and analytics, utilizing data statuses, query templates and build processes, managing error marts, report collections in depth.
Class 9: Managed Self Service BI: this class will introduce and discuss HOW to build out managed self-service BI, and how to introduce your users / customers to these concepts. It will cover such topics as: write back conditions, managing master data, enabling the business users, engaging governance of end-users, defining self-service BI (what it means, the value it brings), and more.
Class 10: Transitioning to Data Vault 2.0: this class is just now being flushed out… watch this space for more.
Class 11: DV2.0 Performance and tuning: Introduction to SMP and MPP, Mathematics behind the DV2.0 concepts, data co-location, partitioning (in depth), parallelism, To Cluster or not to cluster, I/O balancing, I/O storage layout, index structuring, ETL / ELT tuning
Class 12: Testing Data Vault 2.0 Elements: This class will cover “how to” test in a Data Vault 2.0 environment. It will discuss types of tests, how to ensure results, talk about testing strategies, and generating test data for specific cases. This class is still being flushed out as well, any suggestions for topics are welcome.
Happy 2014!!! looks to be a good year.
NOTE: you can get “early bird” discounts and notifications by SIGNING UP for our e-mail list on http://LearnDataVault.com