Nexpose supports several flexible and configurable methods for generating reports.
See Community-built SQL Query Export examples for guidelines, best practices, and video material on building your own SQL queries. The subpages contained therein hold several example queries that you can use to demonstrate these capabilities.
For more information on SQL Query Export, see our blog post.
You can ETL Nexpose data to an external warehouse in a Dimensional Model using Enterprise Edition 6.4.6 or later.
Documentation for the Data Warehouse Export Dimensional Schema is located here.