Microsoft has introduce a great tool with biztalk i.e. called BAM (Business Acitivity Monitoring) which helps greatly in real time reporting, KPIs etc, Let me first define what is BAM.
This tool can really resolv e the problem of getting real time MIS, KPIs, Dashboards etc. Just think of it , if a marketing manager get his real time sales, if finance manager get his real time funds position , research analyst can get realtime market trends, CEO can get his realtime company position (Sales-Expense / Market trends / Business deceissions etc), CIO/CTO , I.T. Heads can get Helpdesk KPIs.
What is BAM ?
BAM is a collection of tools that allow you to manage aggregations, alerts, and profiles to monitor relevant business metrics (called Key Performance Indicators or KPIs). It gives you end-to-end visibility into your business processes, providing accurate information about the status and results of various operations, processes, and transactions so you can address problem areas and resolve issues within your business.
Who Uses BAM ?
BAM can be used by Business Analyst, End Users, Management (CEO, CIO, Marketing SVPs etc) and on the technical side Programmers, Software Engineers, System Analyst etc.
What Technology Used in BAM ?
BAM used as Excel Addin by which any end user can design Activities, Views, Aggregations etc, at back end BAM used biztalk engine, orchestration (for workflows), Sql server database to mangage its data in active and temporary tables.
BAM web portal can be used in sharepoint, also we can directly interact with data from BAM databases created during installation of BAM.
For more detail on BAM , dowload microsoft training KIT