Business Intelligence Center demonstration, PowerPivot SharePoint 2010 demo, PowerPivot pages customization

Business Intelligence Center demonstration, PowerPivot SharePoint 2010 demo, PowerPivot pages customization in SharePoint 2010
PlexHosted Business Intelligence Center Demonstration
PlexHosted – Custom BI Center Demonstration
Business Intelligence Center demonstration, PowerPivot SharePoint 2010 demo, PowerPivot pages customization in SharePoint 2010, “Clean” Business Intelligence pages at SharePoint 2010

Greetings everyone!
Today I have a great news for you and your business. PlexHosted offer a new view for the standard SharePoint 2010 Business Intelligence site. There is you can see “clean” BI pages, without unnecessary ribbons. But, please no worries about the PowerPivot demo pages functional – all of them are meet all inquiries of end users. I have a couple screens for you to show pages, but if you are interesting in real Business Intelligence Center demonstration – PlexHosted can give you this opportunity! Please visit PowerPivot and Excel Services page, complete a form with your email address, company name there, and PlexHosted team will send you login credentials to the Power Pivot SharePoint 2010 demo site.
You would be able to check all PowerPivot for SharePoint 2010 functionality in real time. You don`t need to search BI screens by googling, you have a real chance to test Business Intelligence Center demonstration site by yourself.
The other great thing is that PlexHosted developersteam have created sample examples of “clean” Business Intelligence PowerPivot pages. They want to show you how you can customize SharePoint 2010 PowerPivot pages for your end users.
Please, go ahead and request an access to the Business Intelligence center demonstration site with PlexHosted. You can do it here: PowerPivot and Excel Services

Business Intelligence Center

The Business Intelligence Center enables you to collaborate, discover and manage the information you need to drive the business forward.
With Business Intelligence, users are empowered with the right business insights enabling them to make informed decisions, and move the business forward, one activity at a time.
Test it with PlexHosted at Business Intelligence Center demonstration site!

Business Intelligence Center improvements

You can see a PowerPivot Demo Site Home Page without any customization at the screen below:

PlexHosted PowerPivot Demo Site standard home page
PlexHosted – PowerPivot Demo Site standard home page

A most of you have seen a standard SharePoint 2010 Site Action menu. This menu is fine for a SharePoint user with admin rights, but not for all SharePoint 2010 users. So, PlexHosted team have decided get this menu out from SharePoint demonstration site. Please no worries, this menu is present for all users with admins rights, so you can get a standard SharePoint experience.

SharePoint 2010 Ribbon

Again, on a Business Intelligence site, the user`s task is to navigate as quickly as possible to actionable information. So, you can create “clean” SharePoint home page with quick links there. PlexHosted team have create an example page for you.

You can see all described changes at the screen below:

PlexHosted PowerPivot Demo Site clean home page
PlexHosted – PowerPivot Demo Site clean home page

Excel Services File Tab and Toolbar

In a Business Intelligence site a lot of File Tab items aint required for SharePoint end-users. Often these items could confusing because end-users usually have a read only permissions and can`t contribute PowerPivot workbook.
The only one most used item is “Download Snapshot”, so, PlexHosted developers have add this item to the clean ribbon as button. You can see it at the screen below:

PlexHosted PowerPivot Demo Site with Download Snapshot button
PlexHosted – PowerPivot Demo Site with Download Snapshot button

PlexHosted delete this bug from PowerPivot SharePoint 2010 demo site.

You can see all described changes at the screen below:

PlexHosted PowerPivot Demo Site with clean Excel Services view
PlexHosted – PowerPivot Demo Site with clean Excel Services view

There is a list with PowerPivot for SharePoint 2010 demo site improvements:

  • No SharePoint Ribbon or Site Actions menu.
  • No Excel Services “File” ribbon.
  • No “Unsupported Features” warning
  • The “Download Snapshot” item appears as a button.
  • No Excel filename in the title bar.
  • “Breadcrumbs” navigation bar in the header, for navigation back to the site home page

These new capabilities will certainly make creating and sharing your report workbooks efforts much easier.

So, if you have interested in Business Intelligence Center demo site or SharePoint 2010 Excel Services custom pages, please visit PlexHosted PowerPivot and Excel Services page and get login credentials to Business Intelligence Center demonstration site.

SharePoint 2010 Business Intelligence overview

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