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

Category archive for ‘Datamartist Tool’ rss

  • Putting data analysis into the hands of the business user

    Having too many people involved can slow down the entire analytics process- by using tools that are designed to be accessible by business users, huge gains can be made. However a challenge faced by all companies is connecting the business knowledge and data manipulation knowledge in a way that the data can be used. As […]

  • Data quality monitoring and reporting

    In the vast majority of cases, useful data sets are not static, but are being updated, added to and purged constantly. Data quality monitoring aims to provide data quality information that is also being constantly updated, and can be used to detect issues quickly, before the bad data piles up. Don't let those bad records […]

  • Automating data update for Tableau Server using Tabcmd and Datamartist

    Tableau is a wonderful, powerful visualization tool. If you have the data, it will generate insightful, powerful dashboards and reports. But actually getting the data is often the tricky bit. And having it appear in your dashboards and reports without having to press lots of buttons is the goal. (No one likes to have to […]

  • To Excel or not to Excel, that is the question

    There is an ongoing debate in Business intelligence and Analytics circles about what role spreadsheets have in data management. At the extreme pro-spreadsheet side, Excel can fix all, be all, and IT departments should just be disbanded, because the world can run on workbooks and macros. At the other end of the spectrum, all that […]

  • 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 […]

  • 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 […]

  • 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 […]

  • 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. […]

  • 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 […]

  • Data profiling rules and data format strings

    A very useful technique in data profiling is data format analysis. Rather than looking at the actual individual values for a given column, by profiling the structure of the values you can understand at a higher level the quality of data. This technique is primarily used for string based data. Can't find the forest because […]