Data Transformation

Data transformation is the heart

Data transformation is the second step after data retrieval. It’s about about data translation, categorization, merging and statistics. For most people not the most sexy part of Data Alchemy. But I do consider it the heart of Data Alchemy. It’s about pumping around the data from the the source to the destination. Without data transformation no new insights.

Overview of tools

  • Google Refine: is a power tool for working with messy data, cleaning it up, transforming it from one format into another, extending it with web services, and linking it to databases(note: application was named Freebase Gridworks before Freebase got bought by Google).
  • TalenD: open source data integration, data quality and master data management solutions.
  • Spreadsheets: common spreadsheet applications like Microsoft Excel or Open Office Spreadsheets.
  • R: a language and environment for statistical computing and graphics.

3 Responses to Data Transformation

  1. You’ve good info in this article.|

  2. csgo weapon says:

    So enlightening, looking onward to returning

  3. Hi there,

    Talend is great for technical profiles and developers. But what of business users who don’t have time nor money to spend on coding ETLs ?
    I’m part of an open source project called Myddleware which aims at empowering business users who want to make sense of their data and undertake complex data migration operations.
    For contributors : https://github.com/Myddleware?tab=stars

    I’d love to hear about other integration tools that include business logic.

    Thanks,

    Barbara

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>