Formula-Based Synthetic Data Generation

Generate Synthetic Data according to defined formulas

Book a demo

Key benefits of using
Formula-Based Synthetic Data

Explore how to use formula-based synthetic data in practice

Control and Customization
Control and Customization
Design synthetic data that reflects specific business logic and rules. This ensures the generated synthetic data reflects your organization’s unique requirements.
Scenario & Edge-Case Creation
Scenario & Edge-Case Creation
Easily simulate unusual, rare, or extreme scenarios by configuring formulas and rules. This helps test data reflect specific edge cases and hypothetical scenarios that might not be covered in real data.
Data Enrichment and cross data Relationships
Data Enrichment and cross data Relationships
Formula-Based Generation can use existing columns or data points as inputs to create new and related data on these input data points. This allows for data enrichment and correcting data errors.

User documentation

Explore the Syntho user documentation

Learn more

Formula-Based Synthetic Data Generation Examples

Explore how to use Formula-Based Synthetic Data Generation in practice

Generating mock email addresses based on first & last names

  1. Use Formula-Based Synthetic Data Generation to create consistent mock email addresses from the first and last name.
  2. Use Calculated Columns to define the generation rules.
  3. Apply a formula that concatenates the FIRSTNAME and LASTNAME columns and appends a mock email domain to produce a realistic synthetic email address.
Generating email addresses based on first and last names

Generating first & last names based on gender

  1. Use Formula-Based Synthetic Data Generation to create male or female first names based on the gender column.
  2. Use Calculated Columns to define the rules for name generation within the dataset.
  3. Apply an IF-statement formula to assign a male or female first name depending on the value in the gender column.
Generating  first and last names based on gender

Product Demo

Watch the Syntho Engine in action

Create data in 3 steps

Calculated column overview steps
01
Define the rules

Decide what data you need and the logic it should follow.

• Example: For an email address, the rule might be email = firstname + lastname + “@example.com”
• Tools: Business rules, formulas, or constraints

02
Use Calculated Columns or Formulas

Set up formulas to generate the values automatically.

• Example: IF(Gender=”Male”, MaleNameList, FemaleNameList) to generate first names
• Tools: A full overview of supported formula functions can be found in our user documentation

03
Generate and validate the data

Run the formulas to test the data in preview and check the results.

• Ensure that all rules are correctly applied
• Optional: Correct and tweak if relevant

Real data problematic?
Turn to synthetic data

Explore how to create data that mimics real data, safely and efficiently, using synthetic data

Join our newsletter

Keep up to date with synthetic data news