bussion JANUARY 2016

BUSSION and FUZZY DATA TRANSFORMATION (ETL)

Below is a scenario about singularization of a data before Bussion. Data in Data File are the ones to be send to Bussion. Out of these data the areas to be changed are changed from Look Up table. In this case in Data File>Customer area there are Customer info. So in Bussion side to be able to create proper reporting this area has to be singularized according to the Look Up areas values.

In Data File>Customer Info (below Table-1) can be differently written. This happens when source data is not straight or when trying to unify datas from different sources. For a proper Data transfer all the differently written values must be set as IDEA TEKNOLOJI value. Below Fuzzy an algorithm make these changes for both the column and all the lines. Corrected Data Sets then during the next steps of the process, edited and transferred to Bussion.

Look Up Data File LAST VALUE
IDEA TEKNOLOJI IDEA TEKNOLOJI IDEA TEKNOLOJI
IDEA TEKNOLOJI IDEA TKNOLOJI IDEA TEKNOLOJI
IDEA TEKNOLOJI IDEA TEK IDEA TEKNOLOJI
IDEA TEKNOLOJI IDEA TEKNO. IDEA TEKNOLOJI
IDEA TEKNOLOJI IDEA TEK. IDEA TEKNOLOJI

Table 1 - Ex:Customer Info

Fuzzy Data Picture 1

Picture 1 - Process designed for ETL

Fuzzy Data Picture 2

Picture 2 - Visualization fo Transferred Data

If you need complex data transformation, it is possible to design processes, transferring changed or calculated data to Bussion.

For more information please contact us.

Get in touch


Main Office
Idea Teknoloji, Ltd. Sti.
Ismail Ergin Is Merkezi No:52/A
Kat:6 D:22 Ustbostanci,
Istanbul, TURKEY

P: (+90) 216-372 36 10
Email
iletisim@ideateknoloji.com
We're on social networks