Datamartist gives you data profiling and data transformation in one easy to use visual tool.

Date archive for November, 2010

  • Preparing Data for QlikView

    In this blog post, I am going to play with some economic data- specifically, Canadian Import and Export data using Datamartist and then use QlikView Business Intelligence Software to analyze the results. The trick with public data like this is that often (ok almost ALWAYS) either data is missing, or the codes don’t match up. […]

    11/18/10 • (0)

  • Data profiling- a search or a code to crack?

    Often, tracking down data quality issues is presented as a search for bad data- but sometimes the data isn’t so much bad, as not understood. In legacy systems, you might be more trying to first find the meaning of data- in effect, decoding it as if it had been encrypted (which in a way, time […]

    11/03/10 • (0)

  • Transforming Data for Tableau (part 2)

    In this second part of the blog post, I am going to discuss how I added data about electricity generation in the U.S.A. to the output data file discussed in part one of this blog post. As before, I will transform the data using the Datamartist software so that Tableau’s powerful visualization software can be […]

    11/02/10 • (0)