Mastering Ibm Industry Data Warehousing Models

Mastering IBM Financial and Banking Data Model with using IBM InfoSphere Data Architect

What you'll learn

Foundations of Data Warehousing

IBM InfoSphere Data Architect

Hands-On with InfoSphere Data Architect

IBM Industry Data Model in Financial & Banking, Healthcare, Insurance, Retail, and Telecommunication

IBM Financial & Banking Data Model in very detail

Demonstration of IBM Financial & Banking Data model with IBM InfoSphere Data Architect

Requirements

Basic Understanding of Data Concepts: Familiarity with fundamental data concepts will be beneficial.

Database Knowledge: Basic knowledge of databases and their structures.

SQL Skills: A foundational understanding of SQL will be helpful.

Familiarity with Data Modeling (Optional): While not mandatory, prior exposure to data modeling concepts can be advantageous.

Access to IBM InfoSphere Data Architect (nice to have): Access to the IBM InfoSphere Data Architect software for practical exercises.

Interest in Financial & Banking and Data Warehousing: A keen interest in the banking industry and data warehousing concepts.

Description

What will you learn:Foundations of Data Warehousing:Gain insights into the importance and key components of data warehousing, exploring concepts like staging, atomic data, data marts, ETL processes, and overall data architecture.IBM InfoSphere Data Architect Mastery:Dive into the basics of IBM InfoSphere Data Architect, exploring its features, capabilities, and the art of data modeling, covering conceptual, logical, and physical modeling.Hands-On Experience:Roll up your sleeves for hands-on sessions with InfoSphere Data Architect. Learn to create projects, practice forward and reverse engineering data modeling, and build data models and how to publish the logical and physical with real-world scenarios.IBM Industry Data Models:Explore the tailored solutions offered by IBM for industry-specific data challenges. Understand the benefits, success factors, and navigate challenges using industry-specific models in financial, healthcare, insurance, retail, and telecommunications.Deep Dive into Banking Data Models:Focus on the IBM Banking Data Model, uncovering its architecture, and:Financial services data model (FSDM) with 9 data concepts such as: Involved Party, Arrangement, Condition, Product, Location, Classification, Event, Resource Item and Business Direction Item. And analytical requirements, and dimensional data model with overview of 8 main business areas of Asset & liability management, Investment management, payments, profitability, Regulatory Compliance, Relationship marketing, Risk management, Wealth Management. Get a detailed walkthrough of each data entity, relationship, and the data warehouse (atomic) model.Practical Demonstration:Witness a practical demonstration of implementing IBM Banking Data Model using IBM InfoSphere Data Architect. Explore the Financial Services Data Model, Analytical Requirements & Dimensional Data Model, and the Data Warehouse Model

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Course Outline

Lecture 3 Materials

Section 2: Introduction to Data Warehousing

Lecture 4 Introduction to Data Warehousing

Lecture 5 Importance in Modern Business

Lecture 6 Key Components of a Data Warehouse

Lecture 7 Benefits and Use Cases

Lecture 8 Data Warehouse Architecture

Section 3: IBM InfoSphere Data Architect Basics

Lecture 9 IBM Infosphere Data Architect

Lecture 10 IBM Infosphere Data Architect - Purpose & Functionality and Key Features

Lecture 11 IBM Infosphere Data Architect - IBM Ecosystem Integration

Lecture 12 IBM Infosphere Data Architect - Industry Templates and Standards

Lecture 13 IBM Infosphere Data Architect - Data Governance & Metadata management

Lecture 14 IBM Infosphere Data Architect - Code Generation and DDL Scripting

Lecture 15 IBM Infosphere Data Architect - Impact Analysis

Lecture 16 IBM Infosphere Data Architect - Reporting and Documentation

Lecture 17 IBM Infosphere Data Architect - Cross-Platform Compatibility

Lecture 18 IBM Infosphere Data Architect - Reverse Engineering

Lecture 19 IBM Infosphere Data Architect - Naming Standard

Lecture 20 Data Modeling Traditional high-level process

Lecture 21 Data Modeling - How to create

Lecture 22 Data Modeling - How to build

Lecture 23 Multiple Package Diagrams for a complex model

Lecture 24 Physical Data Model creation

Section 4: Hands-On with InfoSphere Data Architect

Lecture 25 Hands-On with InfoSphere Data Architect & Scenario 1 Forward Engineering

Lecture 26 Scenario 2 Reverse Engineering and Web publishing

Lecture 27 Demonstration: MySQL Installation

Lecture 28 Demonstration: IBM Infosphere Data Architect (IDA) Installation

Lecture 29 Demonstration: Infosphere Data Architect - Forward Engineering

Lecture 30 Demonstration: Infosphere Data Architect - Web Publishing

Lecture 31 Demonstration - Infosphere Data Architect - Reverse Engineering

Section 5: IBM Industry Data Models

Lecture 32 Introduction to IBM Industry Data Model

Lecture 33 What are the IBM Industry Models

Lecture 34 IBM Industry Models Components and Terminology

Lecture 35 Benefits of Implementing IBM Industry Data Model

Lecture 36 Why do we need an Industry data model

Lecture 37 Success factors in using IBM Industry Data Models

Lecture 38 IBM Banking and Financial Market Data Warehouse

Lecture 39 Specific IBM Industry Data Models

Section 6: IBM Financial & Banking Data Model

Lecture 40 Introduction to IBM Financial & Banking Data Model

Lecture 41 Data Warehouse Architecture

Lecture 42 Set of extensive Banking Data Models

Lecture 43 FSDM (Business Conceptual Model)

Lecture 44 FSDM (Business Conceptual Model) - 9 Data Concepts

Lecture 45 FSDM (Business Conceptual Model) - 9 Data Concepts in relationship for Example

Lecture 46 The Analytical Requirements Model

Lecture 47 The Analytical Requirements Model – Focus Areas

Lecture 48 Asset and Liability Management

Lecture 49 Investment Management

Lecture 50 Payment Analysis

Lecture 51 Profitability Analysis

Lecture 52 Regulatory Compliance Analysis

Lecture 53 Relationship Marketing Analysis

Lecture 54 Risk Management

Lecture 55 Wealth Management

Lecture 56 Dimensional Warehouse Model

Lecture 57 Atomic Warehouse Model – Subject oriented, normalized flexible & Package

Lecture 58 Atomic Warehouse Model Entities

Lecture 59 Atomic Warehouse Model - Fundamental Entity

Lecture 60 Atomic Warehouse Model - Invariant History Entity

Lecture 61 Atomic Warehouse Model - Periodic History Entity

Lecture 62 Atomic Warehouse Model - Episodic History Entity

Lecture 63 Atomic Warehouse Model - Continuous Relationship Entity

Lecture 64 Atomic Warehouse Model - Continuous Values Entity

Lecture 65 Atomic Warehouse Model - Associative Entity

Lecture 66 Atomic Warehouse Model - Classification Entity

Lecture 67 Atomic Warehouse Model - Classification Entity (Cont.)

Lecture 68 Atomic Warehouse Model - Supportive Entity

Lecture 69 Atomic Warehouse Model - Supportive Summary Entity

Lecture 70 Atomic Warehouse Model - Example of Piece of System of Record

Lecture 71 Demonstration: FSDM (Business Conceptual Model) - 9 Data Concepts

Lecture 72 Demonstration: The Analytical Requirements Model - Dimensional Data Model

Lecture 73 Demonstration: Atomic Warehouse Model

Lecture 74 Summary Session

Data Professionals: Individuals working in data-related roles seeking to enhance their skills in data warehousing and modeling.,Data Modeler, Data Designer, DBA who would be knowledge of IBM InfoSphere Data Architect and specific IBM Industry data model (Banking & Financial Service).,Business & Data Analysts in Banking: in the banking sector interested in leveraging industry-specific data models for better insights.,Professionals in Finance and Banking: Finance and banking professionals keen on understanding the application of data warehousing models tailored to their industry.,Anyone Interested in IBM Industry Data Models: Individuals curious about IBM Industry Data Models and their implementation in the context of financial and banking data