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:
From "Dataset" page
From the Dashboard Designer page
From the preview page of the table being uploaded
Click the “Data” button in the Dashboard Designer or on the Data Model Builder page.
Choose a data source and upload the required table.
To enter the data transformation module, click “Transform Data.”
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.