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

Author Archives rss

  • Transposing data- columns to rows

    Being able to pivot and transpose data is a key part of reporting and data analysis. With the recently released V1.6 of Datamartist, there is new functionality in the Pivot block that lets you turn a data set that looks like this: Into one that looks like this: The columns have been transposed to rows, [...]

    4/19/12 • (0)

  • Datamartist V1.6 Released- Excel Dashboard enhancements

    We are pleased to announce the release of Datamartist V1.6, and a powerful new capability for the generation of Excel based dashboards. With the new version, Datamartist can insert data sets easily and visually into Excel workbooks as well as having the capability of defining a template, allowing automation of dashboard generation. As always, data [...]

    3/29/12 • (0)

  • A new years resolution to data profile

    Well, it's the time of making and breaking resolutions, a time when setting realistic goals is sometimes hard to do with all the optimism of the new year. Sometimes, we make decisions NOT to set a goal, because we don't want to break it. You might be thinking you really should step up your data [...]

    1/10/12 • (0)

  • Datamartist V1.5 Released

    We are pleased to announce that Datamartist V1.5 is now available. This version of Datamartist brings with it some useful new functionality, including new functions that can be used in expressions, new capabilities in terms of exporting to databases, and a new data block. In this post, we'll look at two new features, the Pivot [...]

    8/31/11 • (0)

  • Datamartist data quality cartoons

    I've had lots of fun over the years building the little cartoons that have become a regular feature. Here are a few, reposted together just for fun. Data quality super powers. Fighting the anti-data forces of evil. Data silo fun. The joys of a moving target Data migration tools.

    6/21/11 • (0)

  • Data Quality Rules

    What's the difference between good data and bad data? It is much like the difference between good children and bad children- the bad data doesn't follow the rules. But what are the rules? Unlike the rules for kids, which have been fixed in stone for decades (or at least, parents wish it were so), the [...]

    6/16/11 • (0)

  • Data Profiler tool Datamartist V1.4 Released

    We are pleased to announce the release of Datamartist V1.4 We've had lots of great feedback from our customers and are thrilled with how people are using Datamartist, not just for powerful and flexible data profiling, but for data migration, data quality work and ad-hoc datamart creation. As always we're committed to continually improve our [...]

    5/16/11 • (0)

  • Data quality sizzle

    I'm an engineer. Being an engineer, I'm pretty product focused, pretty technology focused, and pretty "does it work or not" focused. Having technical things like tools work is useful, and good. But just because you build it, does not mean they will come. The challenge often in Data Quality is that often what has to [...]

    3/22/11 • (0)

  • Which myths are holding you back?

    In your business you have "facts". Things that are considered to be true. Lots of folks have heard of them, or believe them, and propagate them. But are they true? You are making decisions every day based on these "facts". Obviously, we have to believe something. But today I'm asking you to be skeptical. Question [...]

    2/10/11 • (1)

  • 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)