Thursday, 5 July 2012

SharePoint 2010 - Business Intelligence Services

Business Intelligence generally consists of SSIS, SSRS, and SSAS, however Business Intelligence in SharePoint means a platform which helps to connect, author, publish render business data from various services such as excel, analysis service to design reporting and dashboard solutions.

Business Intelligence Services

1.       Excel Services
2.       Access Services for Web Databases
3.       Visual services for web diagram and strategy maps
4.       Chart Web Part
5.       Business Connectivity Services
6.       SSRS integration
7.       SSAS integration
8.       Power Pivot for SharePoint and Excel
9.       Key Performance Indicator
10.   Performance Point Services for Analytics and Dashboard reporting

Business Intelligence Features

1.       Excel Services
a.       Options to publish Excel works as browser enabled, html content,
b.      Data Connection library support for connecting data sources
c.       Excel web access web part support for rendering tables, ranges and charts
d.      REST support to Excel Services to access Excel components independently
e.       Analysis services data source support for better pivot charts and tables
f.        Macro support in rendering(ActiveX based macros are not supported)
g.       USF assembly support for custom calculations
h.      Excel Service web Service support for programmatic access
i.         Cashing support for better rendering performance
2.       Visio Services
a.       Options to publish and render vision diagrams as Silverlight enabled web diagrams(Silverlight prevents from content extraction)
b.      Options to design strategy map diagrams connected to data sources.
3.       SSRS integration
a.       Options to store report definition in content database
b.      Inter-connection enabled
c.       Report viewer web part for rendering report
d.      SQL
e.      Charts and graphs control support in rendering reports
4.       SSAS integration
a.       Power pivot for Excel(Part of Office licensing)
b.      Easier solutions in terms of analysis volume of data.
c.       Leverage existing excel skills to build analytical solutions
d.      Options to connect various data sources such as SQL server, RSS feeds, oData, analysis services, XML and Web services
e.      Browser compatibility support in rendering power pivot, chart and table
f.        Dedicated site template for power pivot gallery
5.       KPI(Key Performance Indicator)-
a.        inbuilt SharePoint list definition for creating KPI entries
b.      Options to connect various data sources in defining KPI goals, actual values and trends
6.       PerformancePoint Service  is one of the most important features of BI
a.       Part of SharePoint EE licensing
b.      Dedicated site template for BI centre to design pps services
c.       Option to connect various data sources, SQL, Analysis services, excel services, XML, OLEDB compatible services and excel services
d.      Easy to create KPI solutions compared to SharePoint features
e.      Built in support to de-composition trees(mainly used for digging data deeply to get more analytic information)
f.        Built in support to designing score cards
g.       Support for creating analytics report
h.      Options to Link vision service enabled strategic maps
i.         Easy to design dashboard reporting solutions
j.        Options to include filters to allow users to get right information
k.       Options to publish dash board reports as browser compatible HTML solutions

Google+ Followers