offdataai
← All courses
offdataai Learn · Intermediate

Build an ontology

Describe what your data means: business concepts, definitions and relationships that people and AI agents can reason over.

Start learning for $1/month

5 lessons · about 50 minutes · included in Explorer

Intermediate5 lessons · about 50 minutes

Build an ontology

Describe what your data means: business concepts, definitions and relationships that people and AI agents can reason over.

Outcome: You can turn a data model into a concept graph with clear definitions and meaningful relationships.

  1. 1

    Name the concepts and define them

    An ontology starts with the things the business talks about, defined in one sentence each.

    Build concepts and relationships · 10 min · instant checks

  2. 2

    Connect concepts with verb phrases

    'Customer places Order' says something. 'Customer has Order' doesn't.

    Build concepts and relationships · 10 min · instant checks

  3. 3

    Classes and subclasses

    Retail customers and business customers are both Customers. A taxonomy says so, and says what makes each kind different.

    Build concepts and relationships · 10 min · instant checks

  4. 4

    Synonyms and a business glossary

    Sales says Client, support says Account holder, the warehouse says Item. Record those words on one concept instead of creating three.

    Build concepts and relationships · 10 min · instant checks

  5. 5

    Walk relationships to answer questions

    A question is a path through the concept graph. Find the path and you have the joins.

    Build concepts and relationships · 12 min · instant checks

What you will be able to do

  • ✓Name concepts in business language, not table names
  • ✓Write a definition that says what one instance is
  • ✓Map each concept to the table that holds it
  • ✓Write a relationship as subject, verb, object
  • ✓Choose a direction that reads as a sentence
  • ✓Avoid empty verbs like 'has' and 'relates to'
  • ✓Model a kind of concept as a subclass with a parent
  • ✓Write a subclass definition that names what sets it apart
  • ✓Decide when a type column deserves its own concept
  • ✓Record the other names a team uses for a concept as synonyms
  • ✓Tell a synonym apart from a separate concept
  • ✓Use the ontology as a business glossary people and agents can search
  • ✓Translate a business question into a path of relationships
  • ✓Spot when a question needs a concept or relationship that is missing
  • ✓Choose between two paths that connect the same concepts
Included in Explorer

Every course and every exercise for $1 a month.

Explorer also includes the Model Builder, all 174 templates and SQL for every warehouse. Cancel anytime.