search:    enquiries@irw.co.uk
0141 840 6860
0207 873 2268

Effective Software Solutions for your Business: Guaranteed.

  • Expert Business Intelligence Consultants
  • IRW proved to be a very capable and highly skilled organisation to work with. Their process of bringing the business user into the development team, continuously analysing and reporting on functionality, allowed us to have complete control - Brian Webb, K7X

Business Intelligence via SharePoint

Consultancy and Solutions

 

Microsoft SharePoint Server 2010 helps organisations provide business intelligence capabilities to every employee, so they can share, control and re-use business information in order to make better business decisions.

Business Intelligence with SharePoint provides an infrastructure that makes it easy for decision-makers to access information anytime, anywhere. People can get up-to-date information where they work, collaborate and make decisions, whether it's on the desktop or over the Web. 

The business intelligence (BI)  features in SharePoint 2010 provide Web and programmatic access to published Microsoft Office Excel spreadsheets, programmatic reuse of critical LOB data, and easy development of Web-based business intelligence dashboards that can incorporate rich, data-bound KPIs, Web Parts, and published spreadsheets. As a Gold Partner and proven Sharepoint expert provider, we can assist your business in getting the best out of the Sharepoint product set and capabilities.

Sharepoint BI tools can include the following:

  • Business Data Catalog: With Microsoft Office SharePoint Server 2010 you can include data from back-end systems in SharePoint lists, Web Parts, and search results by using the Business Data Catalog. The Business Data Catalog also allows access to data by using Microsoft ADO.NET.
  • Dashboards: Microsoft SharePoint Server 2010 helps create interactive business intelligence (BI) dashboards that assemble and display business information from disparate sources by using built in Web Parts. These Web Parts include dynamic key performance indicators (KPI), Office Excel 2010 spreadsheets, Microsoft SQL Server 2008 Reporting Services reports and a collection of business data connectivity Web Parts that can visualize information residing in back-end line-of-business applications.
  • Microsoft Excel Services: Microsoft Office Excel 2010 Services help information workers publish spreadsheets to SharePoint sites, including spreadsheets that incorporate powerful new client capabilities such as data visualisation and richer PivotTable views and PivotChart views. Users require no additional software to access these interactive spreadsheets in a Web browser, and all calculations are performed on the server.
  • Report Centre: Microsoft Office SharePoint Server 2010 includes out-of-the-box websites optimised for report access and management. These sites, hosted by the new Report Centre, provide consistent management of reports, spreadsheets, and data connections.