Business Intelligence

So much information, so little time!

Office SharePoint Server 2007 can link to business applications, such as SAP, Siebel, and Microsoft SQL Server 2005, allowing you to easily publish reports, lists, and key performance indicators (KPIs). aXelerate has developed a complete end-to-end data management reporting and analysis set of services to help you build your business intelligence reporting, from customizing reports in SharePoint Server 2007 to mapping CRM data against geographical information:

The capabilities of SharePoint Server 2007 around Business Intelligence are based on the Report Center and a combination of 6 other elements. aXelerate can provide you with all the services to deploy a successful business intelligence solution. We can work with you on any of the following elements which form the basis of Business Intelligence on SharePoint Server 2007:

Report Center	The Report Center site provides a central location for business intelligence related information. It contains special libraries for storing reports, lists, and connections to external sources. It also provides access to page templates and Web Parts to help you create pages and lists that contain business information. Within the Report Center, users can search for items by using categories, view a calendar of upcoming reports, and subscribe to reports that are relevant.

Dashboards	Dashboards are tools that are used to communicate status and to drive action. An Office SharePoint Server 2007 dashboard is a Web page template that allows you to assemble and display information from disparate sources such as reports, charts, metrics, and key performance indicators. aXelerate Solutions can create customized dashboards to fit your exact requirements.

Key Performance Indicators	A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a goal. KPIs are valuable for teams, managers, and businesses to evaluate quickly the progress made against measurable goals. By using SharePoint KPIs, you can easily visualize answers to the following questions: What am I ahead or behind on? How far ahead or behind am I? What is the minimum I have completed? Each area of a business may choose to track different types of KPIs, depending on the business goals they are trying to achieve. Working with aXelerate solutions, you can decide exactly on which KPI you want to set of each of your team.

Excel Services	Excel Services enables you to store an Excel workbook on a server and then publish any part of that workbook on a Web page. Users need only a browser to view and interact with the live data. The workbook is published on the Web page by using the Excel Web Access (EWA) Web Part and the end users never have to see the business logic.

Connection to external data sources	In addition to using external data sources in Excel workbooks, you can use data from other business applications, such as SAP and Siebel, in SharePoint lists, pages, and Web Parts. Administrators usually create the system connections and can store them in a Data Connection Library in the Report Center. That way, the central pool of connections can easily be accessed and reused by anyone with permissions. However, you can create and store data connections anywhere in the Office SharePoint Server 2007 system.

Filter Web Parts	Filters allow you to display only the subset of data that you are interested in viewing. For example, a data set can contain five years' history of multiple products for the entire country/region. By using filters, you can display something more meaningful, such as only one sales region, only one product, or only the current year. Office SharePoint Server 2007 has 10 Filter Web Parts that enable you to enter or choose one or more values to change the contents of one or more Web Parts on a page to display exactly the information you need with the ability to add many more.

Business Intelligence

So much information, so little time!

Report Center

Dashboards

Key Performance Indicators

Excel Services

Connection to external data sources

Filter Web Parts

Are you ready to learn more on how we can help you creating your business intelligence solution?