Recently I have given a presentation on the Business Intelligence tools available for SharePoint 2010 and its related infrastructure (e.g. SSRS).
I delivered this session at the inaugural SharePoint Saturday UK event which I also co-organised earlier this year. Also more recently, I delivered this at the SharePoint User Group in Cambridge.
The key points I try to get across to the audience are as follows:
– All Business Intelligence tools built into SharePoint are only available with Enterprise CALs BUT its still a far cheaper alternative to the other big players.
– For non Enterprise and even Foundation users, SQL Reporting Services (SSRS) is your friend. If you have a Standard SQL 2008 R2 licence, make the most of SSRS to deliver dashboards, reporting and geo-spatial mapping. You even have a top quality report authoring tool in Report Builder, and all your content can be managed like any other document (workflow, versioning etc).
– Again for the non-enterprise, take a look at the Google/Bing APIs for charting and mapping.
– Lots of tools to solve quick (tactical) problems for BI in SharePoint such as the Chart Web Part, Status Lists
– Use PerformancePoint when you have OLAP Cubes as your data source. It is the best tool for ‘exploratory’ reporting.
My presentation slides can be found on slideshare here: Business-Intelligence-Armoury-Whats-the-Best-Tool-for-the-Job