They're good for aggregating data, but they're not designed for precise querying, manipulating and cleaning data. If they were, we'd likely see powerpivot replacing sql server management studio:)