Excel Services SharePoint 15, Excel Services SharePoint 2012, SQL Server, Analysis with Excel Services, SharePoint 2013 Excel Services, SharePoint 15 Screenshots

Excel Services SharePoint 15
Excel Services SharePoint 2012, SQL server, Analysis with Excel Services
SharePoint 2013 Excel Services
SharePoint 15 Screenshots
Excel Services SharePoint 2012
PlexHosted – Excel Services SharePoint 2012
Excel Services SharePoint 15, Excel Services SharePoint 2012, SQL Server, Analysis with Excel Services, SharePoint 2013 Excel Services, SharePoint 15 Screenshots

Greetings, everyone! I have tested the SharePoint 2013 preview edition’s new Business Intelligence Center. The following are some of my experiences and thoughts while conducting these tests.

SharePoint 2013 overview

SharePoint 15 screenshot – Business intelligence

At first I created a new SharePoint 2013 Business Intelligence site. It`s look and feel are much more attractive than a SharePoint 2010 Business Intelligence site. The Home page of the Business Intelligence center is more clear and simple to use.

SharePoint 15 screenshots Business Analysis
SharePoint 15 screenshots – Business Intelligence

Taking a look at Excel Services and at the data in the new BI site Excel workbook, we see a less cluttered page with clear charts and more useful Excel items with graphics and indicators.

Excel services SharePoint 2012
Excel services in SharePoint 2012

With Excel Services SharePoint 2013 you can sort your data, filter it and refresh data entries at the web-browser without pressing F5. Since it`s a cross-browser service, you can view your data on IE, Mozilla FF, Google Chrome, and Safari and at mobile devices as well. As an example I chose two years on the “Date” scroll-bar and the graphic for “Reclining Lawn Chair Historic Prices” was refreshed automatically.

sharepoint 15 screenshots - analysis with excel services
Excel Services Analysis

SharePoint 15 screenshot – Analysis with Excel Services

At the bottom of the Excel workbook`s page you can see the usual Excel work sheets.

sharepoint 15 screenshots - excel services sheets
Excel Services sheets

At the top of the Excel workbook page we can find the new Metro Style Excel Services Ribbon.

sharepoint 15 screenshots - excel services ribbon
Excel Services ribbon

If you have a lot of data and need to find a specific item, use Find. Just click the Find button on the Excel ribbon and find required data with just one click.

Analysis with Excel services find Excel items
Analysis with Excel services – find Excel items
analysis with excel services - excel data
Excel Service Analysis – Work with Excel Data

SharePoint 15 screenshot – SharePoint 2013 Excel Services style

At the File tab you can see the Metro Style Excel 2013 panel. It’s easy to use, right?

sharepoint 2013 excel services
SharePoint 2013 Excel Services Style

SharePoint 15 screenshot – PerformancePoint SharePoint 2012

Another useful service of SharePoint 2013 Business Intelligence is PerformancePoint services. The start page of PerformancePoint is more helpful and useful than before. The Run Dashboard Designer is on the start page so you don`t need to search for it on subsequent pages.

SharePoint 15 screenshots performancepoint SharePoint 2012
SharePoint 15 screenshots – PerformancePoint SharePoint 2012

Additionally in SharePoint 2013 we can see the PerformancePoint tab on the main SharePoint Ribbon. The Run Dashboard Designer button and Export/Import buttons are there as well. This lets you work faster with your PerformancePoint dashboards.

performancepoint sharepoint 2012
PerformancePoint SharePoint 2012 ribbon

SharePoint 2013 Business Intelligence

During my testing, I noticed other useful changes in SharePoint 2013’s Business Intelligence Center. Some of these changes are the result of SharePoint 2013 development and some were from Microsoft’s new SQL 2012. I think you will agree that the new SharePoint 2013 BI capabilities will bring new life to and faster user adoption of Microsoft’s Business Intelligence Center.

PlexHosted SharePoint overview
SharePoint Business Intelligence overview