Logo

BUSINESS DATA MODELING

Design for when the only constant is change itself.

As data grows at an unprecedented rate, extracting meaningful insights from it becomes essential. However, the current methods for doing so are often prone to errors, require significant time, and face various limitations. This certification offers a structured methodology and framework to tackle these challenges effectively.

BUSINESS DATA MODELING CERTIFICATION

The certification is for anyone who must make data-driven decisions for strategic or tactical purposes whether you are aspiring to be or currently working as a

  • Systems Analyst
  • Business Analyst
  • Data Analyst
  • Data Modeler
  • Line of Business Manager

The curriculum is specifically tailored to facilitate these professionals who need to derive insights from data independently, without relying on a software developer or technical expert.

The instructional methods employed during the training include a variety of learning exercises, use cases, and example projects. The certification program is fully online and self-paced. 


Addresses today's challenges

  • As data volume, variety, velocity, and veracity continue to grow, it becomes more important today to understand the implications this has on our businesses.

  • Data is often distributed across multiple platforms, from traditional data warehouses to cloud data lakes. Extracting insight from distributed data is time-consuming, expensive, and challenging. Spend more time understanding, analyzing, and gaining actionable insights from data.

  • What used to be the job of database engineers and developers, Data Modeling has become a critical skill for business, systems, and data analysts. Understand how to combine long-standing model-based approaches with new and different modeling techniques to address various business use cases.

The program provides an understanding of:

  • How data models are 'abstract views' of insight data.
  • How data models may be built on top of existing business systems and applications.
  • How to derive models that enable a business to gain valuable insights from various sources of data.

Data Modeling Guidelines

The image above is an excerpt from the Systems Analysis and Design text published by John Wiley and Sons. In addition to the extensive exercises and case studies included in the text, participants will complete the course with a license for The Visible Analyst (modeling software) and a license for the AI-Generated Language Model (LLM), enabling future training in the development of more detailed business-driven data models.



uCertify Portal-1
Upon successful completion, you will receive a recognized certificate validating achievement and competency in business-driven data modeling.

Our goal is that you appreciate why we must build systems designed to support a future where the only thing that remains constant … is change itself. You will understand how to build systems that can change easily, rapidly, and often. In the opening session, we begin our discussion with a high-level view of the enterprise, its need for planning, and why it is important for us as business data modelers to understand the strategic priorities of a business.

Many of the concepts presented here are the product of

Clive Finkelstein’s  Clive Finkelsteinwork with John Zachman John Zachmanand with C.J. Codd CJ Date

- all recognized as internationally renowned consultants and instructors – working with organizations throughout the world and in most industries.

What sets the CBDM Certification apart is the inclusion of insights and videos from Clive Finkelstein, recognized as the "father of information engineering." Clive's expertise and contributions have revolutionized information engineering - shaping the practices of countless professionals.

SECTION I

  • PROLOGUE
  • Introduction to Data Modeling
  • Data Entity Types
  • Structured Entities
  • Data Attributes
  • Sample Solution Exercises
  • Data Mapping
  • Sample Solutions Exercise 5 Manufacturing Co
  • Sample Solutions Exercise 6 Insurance Co

SECTION II

  • Introduction to Business Normalization
  • Normalization & the Relational Model
  • First Business Normal Form (1BNF) – Introduction
  • First Business Normal Form Exercise
  • Second Business Normal Form Exercise
  • Third Business Normal Form
  • Exercise 10 + Exercise 11
  • Fourth Business Normal Form
  • Fifth Business Normal Form
  • Normalization Exercise Sample Solutions - Exercises 1-10
  • Bonus - Normalization Exercise Sample Solutions - Exercises 11-13

Review: Data Modeling

  • Introduction
  • The Entity Relationship Diagram
  • Creating an Entity Relationship Diagram
  • Validating an Entity Relationship Diagram
  • LESSON REVIEW
  • QUESTIONS
  • EXERCISES
  • MINICASES
  • Inventory Order
  • APPENDIX 5A: NORMALIZING THE DATA MODEL

LAB EXERCISES

  • Getting to Know Visible Analyst®
  • Building Requirements Statements in Visible Analyst®
  • Building Repository Entries in Visible Analyst®
  • Defining process models in Visible Analyst®
  • Defining data models in Visible Analyst®
  • Defining structure charts / Adding physical details to DFDs in Visible Analyst®
  • Adding Physical Details to ERDs in Visible Analyst®

CERTIFICATION

NEW ... AI Augmented Learning with GPT 4.0 Large Language Model (LLM)!

High Level View

Clive begins our discussion with a high-level view of the enterprise, its need for planning, and why it is important for us as business data modelers to understand the strategic priorities of a business. Clive shows how to capture Information Requirements and how to derive a more detailed Operational Data Model from the Information Requirements. He begins by looking at a business planning scenario of a typical project found in an organization.

LLM3-1
LLM1

Feel free to direct your conversation as you see fit.

The conversational chatbox enables you to explore a broad spectrum of topics, ranging from a simple greeting such as "Hello, how are you?" to more complex inquiries like "Could you provide information about a primary key?"

We welcome all questions. The LLM is designed to address each query in an advisory capacity.

GPT Language Model

Leveraging the GPT (Generative Pre-trained Transformer) architecture to develop a straightforward LLM model, the language model is derived from the material presented in the course.

Consequently, the LLM establishes a foundational understanding of contemporary theories in business data modeling. Thus, it serves as a valuable resource for your future business data modeling projects.

 

LLM2
GPT 4-1

GPT-4.0

GPT-4 is a state-of-the-art language model developed by OpenAI that excels in understanding and generating human-like text based on the input it receives. 

GPT-4 can sift through large volumes of data. The CBDM leverages GPT-4 to provide summaries and actionable insights, which can be crucial for decision-making.

 

Logo