Compared to Hyperion, it has much more advanced abilities with subqueries. Some reports that needed multiple queries in Hyperion can be executed with one run in Toad.
After using Brio for many years in Canada, Staples Professional needed a new business intelligence tool. Quest® Toad® Data Point and Quest Toad Intelligence Central enabled Staples users to share and view queries, files, objects and automation scripts with other Toad users in this on-premises deployment. Toad Data Point made it easy to convert existing queries, while Toad Intelligence Central helped automate standard reports.