James,
I'm assuming someone already maintains the company Intranet site, so you can provide them the sql to pull the information from the database. The types of reports you liseted are default reports. Within the process manager, find the reports you want to show on the company intranet site, edit the report and look for the options tab. You should then see "Show SQL."