We use BIRT, R and RRDtools to extract reports, statistics and charts from Moodle. In this source repository you can find some useful sql queries, scripts and reports...