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