About the Training:
This course is focused towards the fundamentals of Data Vault Data Modeling and this course will help you to clear interviews, to understand Data Vault Data Modeling fundamentals to step into Data Lake Environment.
If you are interested, please approach Training@LearnDataModling.com or 91-90801 57239.
- Course: Data Lake Data Modeling Training – Data Vault Approach
- Start Date: November 11th and 19th, 2023
- Training Hours: 10 plus
- Weekend: Saturday 8pm IST to 10.30 pm IST and Sunday 8 pm IST to 10.30 pm IST
- Trainer: Working as a Data Modeler in Azure Data Lake Environment – Data Vault Approach.
- Online Meeting Software: Go to Meeting
- Online Class Reference Documents: Will be provided.
- Online Class Videos: Will be provided, life time Access.
Data Vault Data Modeling Training:
- Overview: How Business Analysts get data for data modeling?
- Overview: What is Bus Matrix in Azure Data Lake?
- What are the components in a Bus Matrix?
- Jira Overview : How Scrum Masters create user stories for a particular Requirement?
- Overview: How Business Analyst write about ingestion of data in Confluence?
- Overview: What is DMD? Data Mapping Diagram?
- Overview: What format is followed for meta data creation?
- Jira Overview: What format is followed for Data Ingestion User Story?
Agile Scrum | Data Modeler’s Activities:
- Understand Bus Matrix and Tables from the daily AGILE sprint stand up call and documents.
- What is done in: Scrum Planning, Daily Sprint, Sprint Retrospective Meeting, Parking Lots Meetings?
- How to Understand user stories, create sub tasks for the user stories, complete it and assign sub tasks to other teams.
- What to do with incomplete tasks in Jira?
Data Vault Data Modeling:
- What is Data Vault?
- What is Raw Vault?
- What is Business Values?
- Why we need to go for Data Vault rather than our OLTP and OLAP Data Modeling?
- How to create Data Modeling Standards in Raw Vault and Business Vault.
- Hash Key algorithms.
- How to create Raw Vault Data Models in Excel spreadsheet?
- How to Create Raw Vault Data Model with Hubs, Satellites, and Links in Excel?
- What is Reference Table, Bridge Table, and PIT tables?
- How Raw Vault Data from Excel is imported into Erwin?
- Develop Business views from Data Vault.
- Create Star Schema (Combine Hubs, Satellites, and Links.) Models in Information Mart.
- Create SQL Queries(Representative SQL based on Logic) for the Data Loading Team to populate the Tables in Azure Environment.
- Create Business Views based on Information Mart for Business Users for a new environment