Course curriculum

    1. Introduction to Data Warehousing

      FREE PREVIEW
    2. Importance in Modern Business

    3. Key Components of a Data Warehouse

    4. Benefits and Use Cases

    5. Data Warehouse Architecture

    1. IBM Infosphere Data Architect

      FREE PREVIEW
    2. IBM Infosphere Data Architect - Purpose & Functionality and Key Features

    3. IBM Infosphere Data Architect - IBM Ecosystem Integration

    4. IBM Infosphere Data Architect - Industry Templates and Standards

    5. IBM Infosphere Data Architect - Data Governance & Metadata management

    6. IBM Infosphere Data Architect - Code Generation and DDL Scripting

    7. IBM Infosphere Data Architect - Impact Analysis

    8. IBM Infosphere Data Architect - Reporting and Documentation

    9. IBM Infosphere Data Architect - Cross-Platform Compatibility

    10. IBM Infosphere Data Architect - Reverse Engineering

    11. IBM Infosphere Data Architect - Naming Standard

    12. Data Modeling Traditional high level process

    13. Data Modeling How to create

    14. Data Modeling How to build

    15. Multiple Package Diagrams for a complex model

    16. Physical Data Model creation

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

    2. Scenario 2 Reverse Engineering and Web publishing

      FREE PREVIEW
    3. Demonstration: MySQL Installation

    4. Demonstration: IBM Infosphere Data Architect (IDA) Installation

    5. Demonstration: Infosphere Data Architect - Forward Engineering

    6. Demonstration: Infosphere Data Architect - Web Publishing

    7. Demonstration - Infosphere Data Architect - Reverse Engineering

    1. Introduction to IBM Industry Data Model

    2. What are the IBM Industry Models

    3. IBM Industry Models Components and Terminology

    4. Benefits of Implementing IBM Industry Data Model

    5. Why do we need an Industry data model

    6. Success factors in using IBM Industry Data Models

    7. IBM Banking and Financial Market Data Warehouse

    8. Specific IBM Industry Data Models

    1. Introduction to IBM Financial Banking Data Model

    2. Data Warehouse Architecture

    3. Set of extensive Banking Data Models

    4. FSDM (Business Conceptual Model)

    5. FSDM (Business Conceptual Model) - 9 Data Concepts - Slide 45-46 - Made with Clipchamp

    6. FSDM (Business Conceptual Model) - 9 Data Concepts in relationship for Example

    7. The Analytical Requirements Model

    8. The Analytical Requirements Model – Focus Areas

    9. Asset and Liability Management

    10. Investment Management

    11. Payment Analysis

    12. Profitability Analysis

    13. Regulatory Compliance Analysis

    14. Relationship Marketing Analysis

    15. Risk Management

    16. Wealth Management

    17. Dimensional Warehouse Model

    18. Atomic Warehouse Model – Subject oriented, normalized flexible Package

    19. Atomic Warehouse Model Entities

    20. Atomic Warehouse Model - Fundamental Entity

    21. Atomic Warehouse Model - Invariant History Entity

    22. Atomic Warehouse Model - Periodic History Entity

    23. Atomic Warehouse Model - Episodic History Entity

    24. Atomic Warehouse Model - Continuous Relationship Entity

    25. Atomic Warehouse Model - Continuous Values Entity

    26. Atomic Warehouse Model - Associative Entity

    27. Atomic Warehouse Model - Classification Entity

    28. Atomic Warehouse Model - Classification Entity (Cont.)

    29. Atomic Warehouse Model - Supportive Entity

    30. Atomic Warehouse Model - Supportive Summary Entity

    31. Atomic Warehouse Model - Example of Piece of System of Record

    32. Demonstration: FSDM (Business Conceptual Model) - 9 Data Concepts

    33. Demonstration: The Analytical Requirements Model - Dimensional Data Model

    34. Demonstration: Atomic Warehouse Model

    35. Recap

About this course

  • $22.00
  • 75 lessons
  • 5 hours of video content

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: Understand the core concepts and components of data warehousing.
  • 🛠️ IBM InfoSphere Data Architect: Gain proficiency in using IBM InfoSphere Data Architect for data modeling.
  • 🖥️ Hands-On with InfoSphere Data Architect: Engage in practical exercises to build and publish data models.
  • 🏦 IBM Industry Data Models: Explore data models tailored for Financial & Banking, Healthcare, Insurance, Retail, and Telecommunications.
  • 💼 Detailed Banking Data Model: Dive deep into the IBM Financial & Banking Data Model.
  • 🔍 Demonstration of Banking Data Model: Observe a live demonstration of the IBM Financial & Banking Data Model using InfoSphere Data Architect.

📋 Requirements

  • Basic Understanding of Data Concepts: Familiarity with fundamental data concepts is beneficial.
  • Database Knowledge: Basic knowledge of databases and their structures is required.
  • SQL Skills: A foundational understanding of SQL will be helpful.
  • Familiarity with Data Modeling (Optional): Prior exposure to data modeling concepts can be advantageous.
  • Access to IBM InfoSphere Data Architect (nice to have): Access to the software for practical exercises is recommended.
  • Interest in Financial & Banking and Data Warehousing: A keen interest in these topics will enhance your learning experience.

📝 Course Description

Welcome to the "IBM InfoSphere Data Architect and Data Warehousing Course," a comprehensive online program designed to provide you with a solid foundation in data warehousing concepts and practical skills in using IBM InfoSphere Data Architect.

1. Foundations of Data Warehousing

  • Importance of Data Warehousing: Gain insights into the significance and components of data warehousing, including staging, atomic data, data marts, ETL processes, and overall architecture.

2. IBM InfoSphere Data Architect Mastery

  • Introduction to InfoSphere Data Architect: Dive into the features and capabilities of IBM InfoSphere Data Architect, focusing on data modeling practices, including conceptual, logical, and physical modeling.

3. Hands-On Experience

  • Practical Sessions: Participate in hands-on exercises with InfoSphere Data Architect, where you'll learn to create projects, perform forward and reverse engineering, and build and publish data models using real-world scenarios.

4. IBM Industry Data Models

  • Industry-Specific Solutions: Explore IBM’s tailored solutions for industry-specific data challenges, focusing on financial, healthcare, insurance, retail, and telecommunications sectors.

5. Deep Dive into Banking Data Models

  • Understanding Banking Data Models: Focus on the IBM Banking Data Model, covering:
    • Financial Services Data Model (FSDM): Explore 9 key data concepts, including Involved Party, Arrangement, Condition, Product, Location, Classification, Event, Resource Item, and Business Direction Item.
    • Analytical Requirements and Dimensional Data Model: Overview of 8 main business areas: Asset & Liability Management, Investment Management, Payments, Profitability, Regulatory Compliance, Relationship Marketing, Risk Management, and Wealth Management.
    • Data Entities and Relationships: Get a detailed walkthrough of each data entity, relationship, and the atomic data warehouse model.

6. Practical Demonstration

  • Live Demonstration: Witness a practical demonstration of implementing the IBM Banking Data Model using IBM InfoSphere Data Architect, focusing on the Financial Services Data Model, Analytical Requirements, Dimensional Data Model, and the Data Warehouse Model.

👥 Who This Course Is For

  • Data Professionals: Individuals in data-related roles seeking to enhance their skills in data warehousing and modeling.
  • Data Modelers, Designers, DBAs: Professionals who want to gain knowledge of IBM InfoSphere Data Architect and industry-specific data models (Banking & Financial Services).
  • Business & Data Analysts in Banking: Analysts in the banking sector looking to leverage industry-specific data models for enhanced insights.
  • Finance and Banking Professionals: Those in finance and banking interested in understanding the application of tailored data warehousing models.
  • Anyone Curious About IBM Industry Data Models: Individuals interested in exploring IBM Industry Data Models and their practical applications in financial and banking contexts.

Reference, Rating, and Feedback

Instructor(s)

Instructor Bio:

I'm a seasoned author deeply passionate about data strategy and management. With over 15 years in IT, spanning banking, insurance, and retail, I've held key roles such as Data Division Director and Chief Data Officer. Currently, as Director of Data Division, I shape data initiatives, while as a Governance & Analytics expert, I establish robust frameworks. Through my writing, I share practical strategies and insights honed from diverse industry experience.

Dien Pham Cong

Chief Data Officer

Discover your potential, starting today

Subscribe to our Newsletter!

Add your email to the mailing list to get the latest updates.

Thank You