I had attended an awesome training on QlikView where they  showed how to easily visualize data and create views using it.

The only limitation with it is that it gets too slow after about a million or so rows of data.

Didn’t get a chance to work on it much post that, but it was a nice experience.