Data Engineering

Data enrichment on the fly

Engineering tools make it possible to transform information, creating new fields from the existing ones and reorganizing the data model in order it to be nearer to the user. New fields will be ready to be analyzed and crossed with any other field instantly, with no need of cubes or metadata.

On this way, you can be more independent from the IT department, more self-sufficient and have a better management of the application. Before starting to analyze data you can adapt each field to your needs and not the other way around.

Quiterian Analytics includes the following tools:

Aggregates:

Gather information from a child table into a parent table by applying functions. It is filterable through a SQL sentence.

See video »

Decodes:

Decode information into new fields, standardize codes and transform them into descriptions. It is used for making data more descriptive.

See video »

Expressions: Using predefined functions

Generate new fields calculated with functions and operations from other fields of the database.

See video »

Expressions: Expressions: using string operations, conditional and arithmetic functions

Generate new fields calculated with functions and operations from other fields of the database.

See video »

Numeric range:

Generate new fields by turning a continuous variable into a categorical one, and create configurable intervals from a numeric variable.

See video »

Quantile range:

Generate new fields by turning a continuous variable into a categorical one, and also create intervals with the same number of registers on each variable.

See video »

Parametrics:

Create a new column with values based on queries.

See video »