I thought I will share with everything my SSRS Dashboard that Katie created and I presented on SQL Bits X in London in a presentation called SSRS vs Google Analytics. Decision making Video should be available at then end of May 2012.
SSRS is a very powerfull tool that is able to deliver dashoard functionality that is not possible or not easy to do with other dashboard tools. The problem with SSRS is that if you are not an experienced developer you most likely will struggle to deliver high quality dashboard. Additionally SSRS is very poor with filters. Something that Microsoft seems not be interested to improve in SSRS but provided certain improvements in Performance Point.
Below is website traffic SSRS dashboard example which is very easy to use as most elements are clicable and allows to provide the same level of inforation both on very high level (entire website) and very low level (one page or one keyword).
If you have any questions about the dashboard or would like to share your ssrs dashboard experience feel free to post a comment.