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.
Domain: E-commerceEntities: - 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 statusRelationships: - Customer places Order - Order contains ProductKey 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.
Domain: E-commerceEntities: - 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 statusRelationships: - Customer places Order - Order contains ProductKey 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.
Domain: HealthcareEntities: - 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]: DescriptionRelationships: - Patient has Encounters - Encounter includes DiagnosisKey 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.
Domain: ManufacturingEntities: - 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/FailRelationships: - Product has Production Batches - Production Batch undergoes Quality ControlKey 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.
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.