Chartio, a business intelligence service that lets you explore your data from a wide variety of sources, is launching a new service today that should make getting started with data analysis and visualization quite a bit easier.
The new Data Pipeline, which Chartio co-founder and CTO Dave Fowler described to me as “a bit like Yahoo pipes but for business data,” takes your data and walks you through a series of steps to transform and merge it. It doesn’t quite have the graphical interface of Yahoo Pipes, but in return the new interface allows you to more easily perform all kinds of standard operations on your data (think merges and sorts).
Many of those features for working with data in Chartio have long been part of the company’s toolbox, but others, like ordering and limits with offsets are new in the release. As you walk through each step, you can always see a sample of your data to make sure everything is working as expected.
The whole process then ends in easy-to-read visualizations. The new design, Fowler tells me, “was made so that more and more transformation steps could be seamlessly added without cluttering the interface.” Fowler believes that “an interface like this has never been done before in business intelligence” and that while the pipeline concept has been around for a while, “it has never been brought all the way to the visualization level.”
You could do something similar on previous iterations of Chartio’s tools, but those pipelines could grow long and unwieldy. The new tool breaks all the steps into more manageable chunks and always displays the current state of your chart or table on the right-hand column.