Burn Baby Burn
I’ve been awfully busy over the past few months (sheesh! almost a year) helping out nModal Solutions get it’s Datamartist product up and onto the ‘net. I am very pleased to announce that the public beta is now open, and anyone can download and try the app out (which I would totally encourage you to do).
Datamartist (named by yours truly) is application for cleaning, manipulating and transforming data sets in ways that used to require SQL query knowledge or days and days of effort in excel. It uses a graphical interface of connected blocks to do some absolutely wicked things to your data. As well, it also exports nicely into excel, so you can still analyze it in ways you are used to.
You can watch the tutorial i built for the product here: http://www.datamartist.com/video-and-screenshots which should give you a good idea of how it works.
We’ve done some testing with super large data sets too. And I mean crazy, stupid, nutty large. 100 Million rows of data large. I think excel gets a bit barfy on anything more than 1,000,000 rows.
You can learn more here: http://www.datamartist.com/learn-more if you are interested. So if you do any sort of manipulation of large data sets (data marts or data warehouses if you will) please check it out, and don’t hesitate to crush me with feedback on either the app or the website.