2 3 4 5 6 7 8 9 10 11

Modern Data Modeling

Ön Koşul

Temel Veri ve Veri Ambarı konsept bilgisi olması yeterlidir.

Eğitimin Hedefleri

Eğitim sonrasında katılımcıların veri modelleme süreçlerine hakim olmaları hedeflenmektedir.

Eğitimin İçeriği

 

1. Gün

Part 1: Data Modeling Concepts
The Data Modeling Life Cycle
Kinds of Data Systems
Data Taxonomy
Data Modeling Framework for BI
Logical Data Models
What to Model

Part 2: Understanding Data Sources
Logical Relational Modeling
Logical Dimensional Modeling
Logical Models and Business Metrics
Logical Models and Business Analytics
Logical Models and Master Data Management
Logical Models and Unstructured Data

Part 3: Implementation Data Models
Data Structure in Transaction Systems
Structural Modeling and Data Integration
Structural Modeling and Business Analytics
Physical Design Overview
Some Optimization Techniques
Physical Design and Implementation

Part 4: Dimensional Data Modelling

Dimensional Modeling Concepts
Dimensional Modeling in Context
Dimensional Modeling Basics
Requirements Gathering for Dimensional Modeling
Business Context for Data Modeling
Business Questions as Requirements Models
Fact/Qualifier Analysis
Logical Dimensional Modeling
Star Schema Dimensions
Star Schema Fact Tables
Star Schema Design Challenges

 

2. Gün

Part 5: Big Data Modelling

5.1 What Is Big Data?
Big Data Opportunities
Technologies
Big Data Challenges

5.2 Data and Models
Models
Modeling for Relational Storage
Modeling for Nonrelational Storage
Complementary Approaches

5.3 Key-Value Stores
Key-Value Stores Defined
Key-Value Data Representation

5.4 Document Stores
Document Stores Defined
Document Data Representation
Use Cases
Examples

5.5 Graph Databases
Graph Databases Defined
Graph Data Representation
Use Cases
Examples

5.6 Embracing Big Data
Big Data in the Enterprise
Managing Big Data Assets
Capture Nonrelational Data
Explore Nonrelational Data
Archive Nonrelational Data
Deploy Nonrelational Data

5.7 Case Studies
Visualising data on cloud with on-premises Data Model
Hybrid data mode wiht Data masking / Data federation data model

 

3. Gün

6. Modern DWH Modelling with Azure – Workshop

Using Data Lakes
Uploading data to Cloud using SSIS
Orchestating Big Data with Azure Data Factory
Visualizing Data With PowerBI
Create an in-memory data model in SQL 2017 Analysis Services
Configuring Data Gateway
Visualsing in-memory data with PowerBI
Diplaying AI capabilities of PowerBI on Azure (Data insight)

 

Kayıt

Modern Data Modeling eğitim programı kaydı için aşağıdaki formu doldurunuz.