During the recently concluded Mini iMoot 2015 (#imoot15mm), Ben Haensel has presented a beautiful presentation on making different Moodle reports by using the configurable reports plugin.
In the presentation Ben discuss about utilizing a pre-created reports and adding various filters and permissions to the reports.
Configurable Reports plugin is a block plugin to create custom reports without SQL knowledge, maintained by Juan Leyva which you can download here.
You can watch the presentation below or check out this direct link.
The best thing in the presentation is that Ben has covered all parts in getting your custom reports like which data to be collected, difference between Adminer and configurable reports plugin,various report examples, and dealing with the dependencies.
Which tool you are using to create custom reports from your Moodle site? Do let us know in the comments below.