Like what you see? Have a play with our trial version.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Overview


Yellowfin’s platform has an integrated data extraction and transformation module to enable users to manipulate data into a format better suited to reporting and analytics. With this module, it is possible to extract data, transform it and then store the transformed data into a target database. Transformation steps can be joined up to configure complex flows which can then be run immediately, or scheduled to run at specific time intervals.


The Data Transformation module has a simple drag-and-drop builder to help you create Transformation Flows. These flows consist of "steps", each performing a different function. Following are the three main Data is transformed by creating transformation flows. These flows can contain three different types of steps:

  • Input stepsteps: These steps allow you to extract data from any data source and import it into the platform to be transformed. This is the first step that you will need to configure.
  • Transformation stepsteps: Yellowfin  Yellowfin allows you to transform your data in a variety of ways. This could be anything from aggregating your data to generating predictions based on data science models.
  • Output stepsteps: Once the data has been converted, it will need to be stored. Use the output step to store load data in into a database.

These steps can be joined up to configure complex flows which can then be run immediately, or scheduled to run at specific time intervals.

 

Learn more about this module here.

Section Contents

Refer to the links below to learn more about for details on this module and how to use it.

  • Prerequisites: Learn how to configure your user roles for security access to the transformation module.

  • Getting Started: Get a better understanding of this module and its various components.

  • Input Steps: Learn about the different ways data can be extracted.

  • Transformations: Click here to view all types of transformations that can be performed on the data.
  • This Output Steps: This guide provides instructions on how to store data into a database.
  • Example Flow: Use this guide to learn how to perform create a basic transformation flow using the Data Transformation module.