Semantic Modeling Workshop Plan

Phase 1: Workshop Preparation

Step 1 Image
Step 1: Domain Scope Definition (Pre-Workshop with Domain Lead)

Activity: Meet with the designated domain lead or a senior business expert to clearly define the scope of the workshop.

Output:

  • Domain Boundaries: Confirm the exact boundaries of the selected business domain (e.g., "Finance" - specifically focusing on "Financial Reporting").
  • Workshop Objectives: Agree on the primary objectives of the workshop (e.g., "To create a high-level semantic model for the data/business domain, focusing on key financial reporting concepts and their relationships").
  • Participant Identification: Identify key business experts from different areas within the domain who possess a broad understanding of data and business processes. Aim for a diverse group representing different perspectives.
AI support

The domain scope could be provided to an LLM (ChatGPT etc) later to pre-generate a very initial list of potential concepts as a starting point if needed, but this should be used cautiously to avoid biasing the business experts' input.

An example prompt here. The output can be pasted in Termboard using Tools > Add in Bulk/Chatbot. See here for the output using Gemini 2.5

Step 2 Image
Step 2: Workshop Materials Preparation

Activity: Prepare all necessary materials for the workshop.

Materials:

  • Workshop Agenda: A clear agenda outlining the workshop steps and expected outcomes.
  • Domain Overview (Optional): A brief, high-level document summarizing the data domain's purpose and key business functions (useful for setting context).
  • Examples of Semantic Models (Simple): Illustrative examples of simple semantic models from other domains (avoid showing examples from the target domain to prevent pre-conceived ideas). Focus on visual representations of concepts and relationships.
  • Concept & Relationship Templates (Physical or Digital): Prepare templates (e.g., sticky notes, digital whiteboard templates) for participants to easily capture concepts, descriptions, and relationships. Pre-printed concept types like "Event", "Party", "Product" can be helpful starting points.
  • LLM Access (Prepared): Ensure access to an LLM tool (via browser, API, or dedicated platform) for use during specific workshop steps. Have pre-defined prompts ready to guide the LLM in concept extraction and description refinement.
AI support

tbd

Phase 2: Workshop Execution

Step 3 Image
Step 3: Workshop Kick-off & Domain Context

Activity:

  • Welcome & Introductions: Facilitator welcomes participants and introductions are made.
  • Workshop Objectives & Agenda Review: Clearly state the workshop's objectives and review the agenda. Emphasize the collaborative nature of the workshop and the importance of business expertise.
  • Domain Context Setting: Briefly reiterate the defined domain scope and its importance to the bank. Use the optional domain overview document if prepared.
  • Semantic Modeling 101 (Very Brief): Provide a very brief and non-technical introduction to semantic modeling. Explain:
    • Concepts: "Business things we talk about" (entities, events, attributes).
    • Relationships: "How these things are connected."
    • Hierarchy (is-a): "Different types of things."
    • Goal: "To create a shared understanding of the data in your domain."
  • Key Message: "Forget about technical details for now, focus on the business language you use every day."
Step 4 Image
Step 4: Data Usecases Identification

Activity: Engage business experts in identifying and listing key data usecases within their domain.

Facilitation:

  • Prompt: "Think about the reports, analyses, data feeds, and outputs your domain produces for other domains and uses itself. What are the key 'things' you deliver or work with as data?"
  • Brainstorming Session: Use a whiteboard or digital tool to collect data usecase names and brief descriptions. Encourage everyone to contribute.
  • Focus on Business Value: Emphasize the business purpose of each usecase. "Why is this report important? What business question does it answer?"

Output: A list of relevant usecases with business-oriented descriptions.

AI support

Potentially, if the domain is very broad, you could ask an LLM (before the workshop) to generate a sample list of data product types for the "Finance" domain (e.g., "Financial Reporting data products"). However, it's generally better to let the business experts drive this step organically.

Step 5 Image
Step 5: Core Concept Extraction from the identified Usecases or Data Products

Activity: Analyze the usecase for data product names and descriptions to extract initial core business concepts.

Facilitation:

  • Prompt: "Looking at the data product names and descriptions, what are the key 'nouns' or 'business entities' being referred to?"
  • Concept Identification: For each data product, ask: "What are the key things this data product is about?" Write down these concepts on sticky notes or digital templates.
  • Grouping & Consolidation: Group similar concepts and consolidate duplicates. Discuss and agree on the most appropriate names for the core concepts.
  • Visualise the concepts: Write them on a whiteboard or enter the concepts in Termboard

Output: A canvas with 10-20 core concepts representing key business entities, events, or attributes.

AI support
  • Concept Suggestion: Feed the list of usecases or data product descriptions (from Step 4) into an LLM. Prompt the LLM with: "Identify the key business entities, concepts, or things mentioned in these descriptions. List them as single words or short phrases." The LLM can suggest potential concepts that might have been missed by the group.
  • Concept Description Refinement (Later in the step): Once the business experts have a list of core concepts, you can ask the LLM to generate initial draft descriptions for each concept based on the data product descriptions where they appear. This provides a starting point for business experts to refine and validate. Prompt: "Provide a brief business-oriented description for the concept '{Concept Name}', considering its use in the context of these data product descriptions: [List relevant data product descriptions]."
Step 6 Image
Step 6: Hierarchy Building (Is-a Relationships)

Activity: Build the "is-a" hierarchy for the core concepts and identify superclasses.

Facilitation:

  • Prompt: "For each core concept, ask: 'What kind of [Concept] is this?'" (e.g., "What kind of 'Financial Report' is 'Profit & Loss Statement'?").
  • Iterative Superclass Identification: Start with the core concepts and work upwards. "Is there a more general category that includes this concept?" Continue this process to reach higher-level, more abstract concepts.
  • Stop at Relevant Abstraction: Stop adding superclasses when you reach concepts that are broadly relevant across domains (e.g., 'Agreement', 'Event', 'Product', 'Document', 'Record', 'Classification'). Avoid overly generic terms unless structurally necessary.
  • Visual Hierarchy: Visually arrange the concepts in a hierarchical structure (e.g., using a tree diagram on a whiteboard or Termboard).

Output: A hierarchical structure of concepts with "is-a" relationships + expanded list of concepts adding the superclasses.

AI support
  • Superclass Suggestion: For a given concept, you can ask the LLM: "Suggest potential superclasses (more general categories) for the concept '{Concept Name}' within the context of financial reporting/the Finance domain." The LLM might suggest broader categories based on its knowledge base. However, business expert validation is crucial here as LLM suggestions might not always be business-relevant.
Step 7 Image
Step 7: Concept Definition & Description Refinement

Activity: Define and refine the descriptions for all concepts (core and superclasses).

Facilitation:

  • Prompt: "For each concept, ensure we have a clear, concise, and business-oriented description. What does this concept mean in our business context?"
  • Collaborative Definition: Work with the business experts to define each concept in their own words. Focus on clarity and shared understanding.
  • Consistency Check: Ensure descriptions are consistent and avoid jargon or overly technical terms.

Output: Complete descriptions for all concepts in a document or using Termboard. Use an LLM to review the definitions for clarity and consistency

AI support
  • Improve Definitions: In the Term sidebar of Termboard, select the icon with the stars, then select Improve Definition and paste the clipboard in an LLM to get an improved definitions for a concept
Step 8 Image
Step 8: General Relationship Identification (Beyond 'is-a')

Activity: Identify meaningful relationships other than "is-a" between the concepts.

Facilitation:

  • Prompt: "Now, think about how these concepts interact. What are the key business relationships between them?"
  • Relationship Brainstorming: Ask questions like: "What actions or processes connect these concepts?", "Does one concept influence or depend on another?", "Does one concept contain or manage another?"
  • Relationship Types: Suggest relationship types to get started (e.g., 'reports on', 'manages', 'uses', 'is derived from', 'applies to', 'contains', 'is denominated in').
  • Relationship Capture: Document the relationships using source concept, relationship name, and target concept.

Output: List of general relationships between concepts.

AI support
  • Relationship Type Suggestion: For a pair of concepts, you could ask the LLM: "Suggest potential business relationships between '{Concept A}' and '{Concept B}' in the context of financial reporting." However, rely more heavily on the business experts for this step, as understanding the nuances of business relationships is critical. LLM suggestions might be too generic or miss domain-specific relationships.
Step 9 Image
Step 9: Model Review & Validation

Activity: Review the complete semantic model (concepts, hierarchies, and relationships) with the business experts.

Facilitation:

  • Prompt: "Let's review what we've created. Does this model accurately represent the key concepts and relationships in your domain?"
  • Validation & Refinement: Ask for feedback, corrections, and refinements. Ensure everyone agrees that the model is a reasonable initial representation.
  • Business Sign-off (Informal): Aim for informal agreement and sign-off from the business experts that the model is a good starting point.

Output: Validated initial semantic model.

Phase 3: Workshop Wrap-up & Next Steps

Step 10 Image
Step 10: Documentation & Iteration Planning (Post-Workshop)

Activity:

  • Document the Model: Formalize the semantic model (create digital diagrams, populate tables as per the requested format, etc.).
  • Share & Communicate: Share the initial model with the workshop participants and the broader domain team for feedback and awareness.
  • Iteration Planning: Emphasize that this is an initial model and will likely evolve. Plan for future iterations and workshops to refine and expand the model as needed.
AI support

Documentation Generation: LLMs might assist in generating documentation from the structured model data (e.g., generating concept glossaries, relationship descriptions).