All of the above: Query, business logic, RDP class, and AX enum provider are the data source types that you can select.
Open in Excel uses data entities that let you publish changes to the data back to finance and operations: Export to Excel uses the grid data and does not give you the option to publish data back to finance and operations.
Remove the unused fields from the report: Removing any unused fields from the report can help the performance of the report.