Confidential Microsoft BI Document Overview and Dashboard Creation Guidelines

1. Welcome THIS DOCUMENT IS CONFIDENTIAL and intended solely for the use of the individual to whom it is addressed or any other recipient expressly authorised by Edenbrook Limited, in writing or otherwise, to receive the same. If you are not the addressee or authorised recipient of this document, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited.

2. Microsoft's integrated end-to-end BI offering ? Andrew Sadler MS BI Team Sept 2008 THIS DOCUMENT IS CONFIDENTIAL and intended solely for the use of the individual to whom it is addressed or any other recipient expressly authorised by Edenbrook Limited, in writing or otherwise, to receive the same. If you are not the addressee or authorised recipient of this document, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited.

3. Agenda & timings THIS DOCUMENT IS CONFIDENTIAL and intended solely for the use of the individual to whom it is addressed or any other recipient expressly authorised by Edenbrook Limited, in writing or otherwise, to receive the same. If you are not the addressee or authorised recipient of this document, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited. 1. MS BI - "the art of the possible” 2. MOPPS - “my first dashboard" 3. MS BI front ends - "tips & tricks“ Possible BDC time permitting

4. MSBI “the art of the possible” • Excel • ProClarity • End to end BI • Integrated search • PPS THIS DOCUMENT IS CONFIDENTIAL and intended solely for the use of the individual to whom it is addressed or any other recipient expressly authorised by Edenbrook Limited, in writing or otherwise, to receive the same. If you are not the addressee or authorised recipient of this document, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited.

5. MOPPS “my first dashboard” THIS DOCUMENT IS CONFIDENTIAL and intended solely for the use of the individual to whom it is addressed or any other recipient expressly authorised by Edenbrook Limited, in writing or otherwise, to receive the same. If you are not the addressee or authorised recipient of this document, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited. • Create dashboard page with 2 views (Analytic Chart and Analytic Grid) • Create page with other content • PAS / MSRS / Excel Services / … • Create dashboard page with above views on it and filter by geography grid to top 10 customer and graph to top 5 city • Create filter passing axis members to grid and graph. • Add custom web part – team discussion panel • Add name / desc of web part – for search stuff • Simple Scorecard • Hyperlinks in scorecard • Conditional display

6. MSBI Tips & tricks THIS DOCUMENT IS CONFIDENTIAL and intended solely for the use of the individual to whom it is addressed or any other recipient expressly authorised by Edenbrook Limited, in writing or otherwise, to receive the same. If you are not the addressee or authorised recipient of this document, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited. • ProClarity • Gifs • Colours • UI parameters • Custom book • PPS • Redir – web page http://servername:40000/redir.aspx (OverridingURL) • PAS report work around – http://servername/pas/en/src/proclarity.asp • MOSS Link error • Add argument 1=1

7. Useful Links • http://blogs.msdn.com/performancepoint • http://technet.microsoft.com/en-us/bb499788.aspx • http://www.microsoft.com/bi • http://blogs.technet.com/proclarity/Default.aspx?p=1 • http://andrewjsadler.spaces.live.com/

8. Questions THIS DOCUMENT IS CONFIDENTIAL and intended solely for the use of the individual to whom it is addressed or any other recipient expressly authorised by Edenbrook Limited, in writing or otherwise, to receive the same. If you are not the addressee or authorised recipient of this document, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited.

9. Now I need a … THIS DOCUMENT IS CONFIDENTIAL and intended solely for the use of the individual to whom it is addressed or any other recipient expressly authorised by Edenbrook Limited, in writing or otherwise, to receive the same. If you are not the addressee or authorised recipient of this document, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited.