Learn to really have an agile data warehouse and deliver data faster" Data Vault is widely accepted as a modeling approach for the Enterprise Data Warehouse regardless in... [+]
including Big Data modeling, revised UOW, Metrics Overlay, Ensemble Modeling, updated BK design, Hash Key options, new Raw/BDV materials, and new cases.
This course will guide you through the Data Vault modeling approach from modeling constructs and patterns to applying data vault principles in your DWBI program. This course covers also loading paradigms, architectures, and how to develop an effective overall data vault data warehouse program. Since data vault may be new for many of you, this course also includes a summary of the benefits of using data vault techniques.
Who Should Attend?
The target audience for this course includes data warehousing and business intelligence professionals, data modelers, data architects, model managers, data warehouse DBAs, data scientists, and ETL professionals. Because data vault modeling concepts are closely aligned with the business aspects of DWBI programs our target audience also includes program managers, business analysts, information modelers, information architects, and other BICC professionals.
Course Structure
This is a hybrid course, with three (3) days in the classroom and two (2) weeks of online, on demand videos that will be available to students 24 hours a day, 2 weeks prior to the start of class. The time in the classroom will consist of interactive, guided group lab work to further the understanding of Data Vault Modeling. At the end of the 3rd day, there will be an exam to test the knowledge gained by each student. This exam is written in English and the grading is not based on grammar or spelling, only ideas and concepts.
Day One
0830 Welcome & Introductions
0900 Data Warehouse Modeling
0930 Ensemble Modeling
1000 Data Vault Core Constructs
1020 Comparing Modeling Methods
1030 Break
1045 Tracking History
10:55 Information Modeling
11:15 Data Vault Modeling Process
1115 First Small Group Case Exercise
1200 Lunch
1300 Continue First Case
1345 Class Discussion & Groups Present
1415 Link Design & Exceptions
1430 SAL & HAL
1440 Business Key Topics
1500 Disconnected & Reference Tables
1515 Break
1530 Unit of Work
1600 Second Small Group Case Exercise
1700 Wrap up for the Day
Day2
0830 Q&A from Day One
0915 Continue Second Case
1030 Break
1045 Class Discussion & Groups Present
1120 Satellite Design & Exceptions
1135 Expanded UOW & Keyed Instance
1150 Modeling Address
1200 Lunch
1300 Bike Shop Example
1320 Applying the DV Ensemble
1335 Standard and Expanded Attributes
1350 Managing Dates / Bi-temporal Data
1400 Third Small Group Case Exercise
1515 Break
1530 Continue Third Case
1545 Class Discussion & Groups Present
1620 Raw & BDV Layers
1630 Hyper Forms and Unstructured
1640 SID versus Hash
1650 Virtualization
1700 Wrap up for the Day
Day3
0
0830 Q& A from Day Two
0900 Data Vault & Agility
0930 Data Vault & Big Data
1000 Architecture & Layers
1020 Helpful Tables: Bridge & PIT
1030 Break
1045 Loading Patterns
1130 Class Discussion
1145 Recap for Exam
1200 Lunch
1300 Recap & Discussions
1330 CDVDM EXAM
1630 Conclusion
Instructors
Hans Hultgren
Hans Patrik Hultgren
Hans Patrik Hultgren is a Data Warehousing and Business Intelligence educator, author, trainer, and advisor. Hans is currently working on Business Intelligence and Enterprise Data Warehousing (EDW) with a focus on modeling and architecture including Ensemble and Data Vault modeling. Hans works internationally primarily in Nordics and EU (based in Stockholm), USA and Canada (based in Golden, CO) and down under in Sydney, Melbourne, Brisbane as well as Auckland and Wellington. Hans was with the University of Denver for 20 years and now continues an education focus with hybrid course delivery including e-Learning components. Courses delivered through Genesee Academy use blended and On-Demand DWBI training videos at www.DataVaultAcademy.com
Hans published the book Modeling the Agile Data Warehouse with Data Vault which is available on Amazon websites. Specialties: EDW, Data Modeling, DWBI Architecture, Ensemble Modeling, Data Vault Modeling, Speaking, Advising, Data Vault, Agile Data Warehousing, Education, Training, e-Learning, Entrepreneurship.
Remco Broekmans
Remco Broekmans, educator, trainer, and advisor. Remco is working on Business Intelligence and Enterprise Data Warehousing (EDW) with a focus on modeling and architecture including Ensemble and Data Vault modeling. Remco works internationally in Europe and is based in the Netherlands.
Remco worked for several consultancy companies in the Netherlands before starting his own companies, Coarem and BI Academy. He has worked a consultant throughout the complete field of business intelligence from reporting, ETL and modelling. The last 15 years Remco is teaching different classes on business intelligence and data warehousing. Since 2006 Remco is closely involved with the Data Vault classes from Genesee Academy and authorized trainer from Genesee Academy since 2014. Courses delivered through Genesee Academy use blended and On-Demand DWBI training videos at http://www.DataVaultAcademy.com.
Specialties: EDW, Data Modeling, DWBI Architecture, Ensemble Modeling, Data Vault Modeling, Speaking, Advising, Data Vault, Agile Data Warehousing, Education, Training.
Price: 28.900,- (24,900,- for signups before September 30) [-]
Les mer