
Have a look through the gallery of examples on their home page - some of them are truly stunning. The catch is, the data you enter into it and any visualisations you create must be publicly available.Īnd something completely different: if you have a quality server lying around and you happen to want to make awesome google-maps style tile-based 'slippy' maps using open source tech (probably not what you're looking for - but it's possible!), check out MapBox TileMill.
Tableau Public - a free-to-use online version of Tableau. Raw by Density Design - blog introduction - (hit "Choose a data sample" to try it out) - mostly copy and paste based, not sure if it has an API that can connect to a database but good for trying things out quickly. There are also some free (not open source) online datavis suites worth mentioning (probably not suitable for direct DB connection but worth a look): If you're interested in the web programming option, here's a slightly more detailed write-up I wrote on Raphael and D3 for stackoverflow. Tip: If you decide to work with Raphael and the latest version is still 2.1.0, I'd advise applying this bug fix to the code). Here's a different approach to pumping D3 output through Raphael to be cross-browser. If you're good with javascript, Raphael is a good way to build something custom-made. D34Raphael combines D3's visualisation tools with Raphael's IE compatibility and abstraction. Raphael if you need SVG output to work in Internet Explorer 6, 7, and 8. gRaphael for interactive cross-browser standard charts. D3 for interactive visualisations in SVG (works in every browser except IE8 and earlier and old (v1,v2) Android phones). Miso Dataset for getting, processing, managing and cleaning the data on the client side in Javascript (includes a CSV parser). If you don't mind coding some Javascript and some kind of server-side layer to serve up the data, give these a try:
There are some really good open source javacript tools for supporting programming data visualisation in a browser.
WEAVE project home page including live demos. Don't expect anything nearly as slick and user-friendly as Tableau, but it looks like an interesting, powerful project for someone prepared to put the time in to learning to use it. Unlike Tableau, it's open source: you can download the source code and install your own version on your own machine which can be as private or as public as you want it to be. Like Tableau, it's intended to let you explore data through an interactive click-based interface. I've never tried it, but there's an open source desktop / browser-based visualisation suite called WEAVE (short for Web-based Analysis and Visualization Environment).