Tutorials

Familiarize yourself with CrossModel by going through these step-by-step tutorials. Each tutorial builds on the previous one, so we recommend following them in order.

The BrightGreen Electronics scenario

All tutorials use a shared fictional scenario: BrightGreen Electronics, a growing electronics retailer that needs an integrated data platform. You will act as a data modeler helping BrightGreen build a logical overview of their data landscape and design an integrated data model.

Prerequisites

Before starting the tutorials, make sure you have:

• A CrossModel account - sign up at app.crossmodel.cloud
• Familiarity with the CrossModel User Interface
• A basic understanding of data modeling concepts - see the Glossary if any terms are unfamiliar

Learning path

1. Datamodeling Fundamentals

Create a logical data model from scratch. You'll learn how to create a workspace, define entities with attributes, build relationships, and use CrossModel's three editing perspectives (form, code, and diagram).

2. Configure and Use the AI Assistants

Set up AI support in CrossModel and use the DataModeler assistant to reverse engineer a data model from SQL DDL files and documentation. You'll also learn about the ModelAssistant for querying your models.

3. Mapping Fundamentals

Create your first data mapping to define how data flows from a source model to a target model. You'll learn how to map attributes between entities to create data lineage.

4. Add Expressions to a Mapping

Extend your mappings with transformation logic. You'll learn how to use expressions to calculate values, extract parts of dates, and concatenate fields from multiple sources.

5. Creating a Mapping with Multiple Sources

Build mappings that combine data from multiple source systems into a single target entity. You'll learn how to add multiple sources and define join conditions between them.