Self-Service ETL

Use Self-Service ETL to simplify the data transformation process before loading it into the platform.
The data transformation module allows users to independently clean data, merge tables from different sources, and add or remove columns—without involving the IT team. It’s available to anyone with permission to edit a dataset.

Why You Need a Data Transformation Module

Before data is loaded into the platform, it often needs to be processed—for example, formatted, filtered, or deduplicated. It’s far more convenient for users to handle these tasks directly within the platform interface, without relying on the IT team.

Visiology addresses this need with its built-in data preparation and transformation module — Self-Service ETL. It significantly simplifies data processing before upload. The intuitive control panel makes it easy to perform transformations, saving time and resources for end users.

Self-Service ETL Capabilities

Transformations:
  • Add custom columns
  • Remove unnecessary columns
  • Replace values in columns
  • Append queries (combine tables from different sources)
  • Apply data formatting
  • Remove duplicate rows
  • SQL Transformation: Execute custom SQL queries across multiple sources for advanced data shaping beyond built-in transformation steps.
  • Filter rows using conditions such as equals, does not equal, contains (LIKE), is in list, is null, and is not null
With Self-Service ETL, you can:
  • Perform transformations on tables, including:
    • Tables from different data sources (all available sources supported)
    • Newly added tables or those previously loaded into the dataset
  • Refresh data:
    • On demand
    • On a schedule
  • Edit transformation steps at any time, if needed

How to Access the Data Transformation Module

You can access the data transformation module in several ways:

What the Data Transformation Module Looks Like

  • Toolbar
    Contains a variety of tools for working with data, such as appending queries, formatting values, filtering, and more.
  • Query Panel
    Displays a list of all queries used to build the final result. Queries can be renamed or deleted as needed.
  • Preview Area
    This is your main workspace, where you can see all changes applied to the query in real time. It helps you monitor the data transformation process. You can also rename columns or change data types by clicking the icon to the left of the column name.
  • Applied Steps Panel
    A history of all transformation steps. It shows the sequence of operations applied to the data, making it easy to track and review the process. You can also edit or remove individual steps here.