Semantic Model Templates for Business Context in Visuo

These semantic model templates provide a structured framework for defining entities, attributes, relationships, and key metrics specific to different business domains in Visuo. They serve as a starting point for creating effective Business Contexts.

Semantic Model Templates for Various Domains

Here are templates for creating semantic models in various business domains:

E-commerce Template

Domain: E-commerce
Entities:
  - Customer:
      Attributes:
        - [CUSTOMER_ID_COLUMN]: Unique identifier
        - [CUSTOMER_NAME_COLUMN]: Full name
        - [CUSTOMER_EMAIL_COLUMN]: Email address
        - [CUSTOMER_REGISTRATION_DATE_COLUMN]: Registration date
  - Product:
      Attributes:
        - [PRODUCT_ID_COLUMN]: Unique identifier
        - [PRODUCT_NAME_COLUMN]: Product name
        - [PRODUCT_CATEGORY_COLUMN]: Category
        - [PRODUCT_PRICE_COLUMN]: Price
  - Order:
      Attributes:
        - [ORDER_ID_COLUMN]: Unique identifier
        - [ORDER_DATE_COLUMN]: Order date
        - [ORDER_TOTAL_COLUMN]: Total amount
        - [ORDER_STATUS_COLUMN]: Current status
Relationships:
  - Customer places Order
  - Order contains Product
Key Metrics:
  - Customer Lifetime Value: Sum of [ORDER_TOTAL_COLUMN] per [CUSTOMER_ID_COLUMN]
  - Product Performance: Count of [PRODUCT_ID_COLUMN] in Order
  - Order Conversion Rate: Count of Order / Count of unique [CUSTOMER_ID_COLUMN]

This template is ideal for online retailers, marketplaces, and digital storefronts.

E-commerce Template

Domain: E-commerce
Entities:
  - Customer:
      Attributes:
        - [CUSTOMER_ID_COLUMN]: Unique identifier
        - [CUSTOMER_NAME_COLUMN]: Full name
        - [CUSTOMER_EMAIL_COLUMN]: Email address
        - [CUSTOMER_REGISTRATION_DATE_COLUMN]: Registration date
  - Product:
      Attributes:
        - [PRODUCT_ID_COLUMN]: Unique identifier
        - [PRODUCT_NAME_COLUMN]: Product name
        - [PRODUCT_CATEGORY_COLUMN]: Category
        - [PRODUCT_PRICE_COLUMN]: Price
  - Order:
      Attributes:
        - [ORDER_ID_COLUMN]: Unique identifier
        - [ORDER_DATE_COLUMN]: Order date
        - [ORDER_TOTAL_COLUMN]: Total amount
        - [ORDER_STATUS_COLUMN]: Current status
Relationships:
  - Customer places Order
  - Order contains Product
Key Metrics:
  - Customer Lifetime Value: Sum of [ORDER_TOTAL_COLUMN] per [CUSTOMER_ID_COLUMN]
  - Product Performance: Count of [PRODUCT_ID_COLUMN] in Order
  - Order Conversion Rate: Count of Order / Count of unique [CUSTOMER_ID_COLUMN]

This template is ideal for online retailers, marketplaces, and digital storefronts.

Financial Services Template

Domain: Financial Services
Entities:
  - Account:
      Attributes:
        - [ACCOUNT_ID_COLUMN]: Unique identifier
        - [ACCOUNT_TYPE_COLUMN]: Type of account
        - [ACCOUNT_BALANCE_COLUMN]: Current balance
        - [ACCOUNT_OPEN_DATE_COLUMN]: Opening date
  - Transaction:
      Attributes:
        - [TRANSACTION_ID_COLUMN]: Unique identifier
        - [TRANSACTION_DATE_COLUMN]: Date of transaction
        - [TRANSACTION_AMOUNT_COLUMN]: Amount
        - [TRANSACTION_TYPE_COLUMN]: Type (debit/credit)
  - Customer:
      Attributes:
        - [CUSTOMER_ID_COLUMN]: Unique identifier
        - [CUSTOMER_NAME_COLUMN]: Full name
        - [CUSTOMER_RISK_SCORE_COLUMN]: Risk assessment score
Relationships:
  - Customer owns Account
  - Account has Transactions
Key Metrics:
  - Average Account Balance: Avg of [ACCOUNT_BALANCE_COLUMN]
  - Transaction Volume: Sum of [TRANSACTION_AMOUNT_COLUMN]
  - Customer Risk Distribution: Distribution of [CUSTOMER_RISK_SCORE_COLUMN]

This template is suitable for banks, investment firms, and fintech companies.

Healthcare Template

Domain: Healthcare
Entities:
  - Patient:
      Attributes:
        - [PATIENT_ID_COLUMN]: Unique identifier
        - [PATIENT_NAME_COLUMN]: Full name
        - [PATIENT_DOB_COLUMN]: Date of birth
        - [PATIENT_GENDER_COLUMN]: Gender
  - Encounter:
      Attributes:
        - [ENCOUNTER_ID_COLUMN]: Unique identifier
        - [ENCOUNTER_DATE_COLUMN]: Date of encounter
        - [ENCOUNTER_TYPE_COLUMN]: Type of encounter
  - Diagnosis:
      Attributes:
        - [DIAGNOSIS_ID_COLUMN]: Unique identifier
        - [DIAGNOSIS_CODE_COLUMN]: ICD-10 code
        - [DIAGNOSIS_DESCRIPTION_COLUMN]: Description
Relationships:
  - Patient has Encounters
  - Encounter includes Diagnosis
Key Metrics:
  - Patient Age Distribution: Calculated from [PATIENT_DOB_COLUMN]
  - Encounter Frequency: Count of [ENCOUNTER_ID_COLUMN] per Patient
  - Common Diagnoses: Frequency of [DIAGNOSIS_CODE_COLUMN]

This template is designed for hospitals, clinics, and healthcare management systems.

Human Resources Template

Domain: Human Resources
Entities:
  - Employee:
      Attributes:
        - [EMPLOYEE_ID_COLUMN]: Unique identifier
        - [EMPLOYEE_NAME_COLUMN]: Full name
        - [EMPLOYEE_HIRE_DATE_COLUMN]: Hire date
        - [EMPLOYEE_DEPARTMENT_COLUMN]: Department
  - Performance Review:
      Attributes:
        - [REVIEW_ID_COLUMN]: Unique identifier
        - [REVIEW_DATE_COLUMN]: Date of review
        - [REVIEW_SCORE_COLUMN]: Performance score
  - Compensation:
      Attributes:
        - [COMPENSATION_ID_COLUMN]: Unique identifier
        - [COMPENSATION_AMOUNT_COLUMN]: Salary or wage
        - [COMPENSATION_TYPE_COLUMN]: Type (salary/hourly)
Relationships:
  - Employee receives Performance Review
  - Employee has Compensation
Key Metrics:
  - Employee Tenure: Calculated from [EMPLOYEE_HIRE_DATE_COLUMN]
  - Average Performance Score: Avg of [REVIEW_SCORE_COLUMN]
  - Compensation by Department: Avg of [COMPENSATION_AMOUNT_COLUMN] grouped by [EMPLOYEE_DEPARTMENT_COLUMN]

This template is ideal for HR departments and workforce management systems.

Manufacturing Template

Domain: Manufacturing
Entities:
  - Product:
      Attributes:
        - [PRODUCT_ID_COLUMN]: Unique identifier
        - [PRODUCT_NAME_COLUMN]: Product name
        - [PRODUCT_CATEGORY_COLUMN]: Category
  - Production Batch:
      Attributes:
        - [BATCH_ID_COLUMN]: Unique identifier
        - [BATCH_START_DATE_COLUMN]: Start date
        - [BATCH_END_DATE_COLUMN]: End date
        - [BATCH_QUANTITY_COLUMN]: Quantity produced
  - Quality Control:
      Attributes:
        - [QC_ID_COLUMN]: Unique identifier
        - [QC_DATE_COLUMN]: Inspection date
        - [QC_RESULT_COLUMN]: Pass/Fail
Relationships:
  - Product has Production Batches
  - Production Batch undergoes Quality Control
Key Metrics:
  - Production Efficiency: [BATCH_QUANTITY_COLUMN] / ([BATCH_END_DATE_COLUMN] - [BATCH_START_DATE_COLUMN])
  - Quality Pass Rate: Count of Pass in [QC_RESULT_COLUMN] / Total [QC_ID_COLUMN]
  - Production Volume by Category: Sum of [BATCH_QUANTITY_COLUMN] grouped by [PRODUCT_CATEGORY_COLUMN]

This template is designed for manufacturing companies and production management systems.

Using Semantic Model Templates in Visuo

These templates provide a starting point for creating semantic models in various domains. To use these templates effectively in Visuo:

Select Your Domain: Choose a template that matches your business domain from the user interface.
Map Your Data: Replace placeholder column names (e.g., [CUSTOMER_ID_COLUMN]) with your actual database column names.
Customize: Add or modify entities, attributes, relationships, and key metrics as needed for your specific use case.
Implement: Use the completed template to generate appropriate prompts for Visuo’s AI, guiding it in understanding your data structure and relevant business concepts.
Save and Reuse: Save your customized templates for future use, allowing you to create domain-specific models for your organization.

Essentials

Guides

Changelog

Semantic Model Templates for Business Context in Visuo

Semantic Model Templates for Business Context in Visuo

Semantic Model Templates for Various Domains

E-commerce Template

E-commerce Template

Financial Services Template

Healthcare Template

Human Resources Template

Manufacturing Template

Using Semantic Model Templates in Visuo

Essentials

Guides

Changelog

​Semantic Model Templates for Business Context in Visuo

​Semantic Model Templates for Various Domains

​E-commerce Template

​E-commerce Template

​Financial Services Template

​Healthcare Template

​Human Resources Template

​Manufacturing Template

​Using Semantic Model Templates in Visuo

Semantic Model Templates for Business Context in Visuo

Semantic Model Templates for Various Domains

E-commerce Template

E-commerce Template

Financial Services Template

Healthcare Template

Human Resources Template

Manufacturing Template

Using Semantic Model Templates in Visuo