I'm setting up BI infrastructure for my company. At the moment, this consists of a data warehouse, SSAS cubes and dashboards with KPI indicators. This is all going well.
Before this was available, every quarter, staff would produce a word document with graphs (comparing stats they had calculated with KPIs - essentially what is in the dashboards) and commentary in, and send it to management for comment/approval. I am
trying to map this process to what I can do in sharepoint/performancepoint - specifically the commentary on the various measures, but am not very clear how to go about it.
I had imagined producing a basic infopath form/workflow to prompt users to submit commentary each month/quarter, and then producing some sort of view which presented the commentary and the relevant graph on one page, for management to look up.
By changing a date filter, the month range of the graph and the comments shown would change, essentially allowing viewing of different quarters' reports.
To what extent can I use components of the dashboard in other pages, as a webpart? Is there anything out of the box in sharepoint/performancepoint that might help with this?
View Complete Post