At a database level, you get several performance charts (you have to wait 30 seconds or 10 seconds for each, the module builds charts by calculating deltas of the increasing cumulative values) and the "biggest tables" report.

You can click on any stored procedure to inspect the source code:

Finally, for every table you can get fragmentation and selectivity reports, and for tables with datetime columns distribution of the values by date (number of records per date):

The index coverage report lists all columns, covered by any index at least once. Leading column in an index is marked with '1', second with '2' etc. You can easily spot overindexing and bad indexing.