Microsoft SharePoint 2013. Creating a PowerPivot gallery

Hi, You may be interested to know how to create PivotPivot gallery.

  1. Login to the SharePoint 2013 site as an administrator
  2. Click on the Settings icon and choose Site Settings from the drop-down menu


3.  Navigate to the Site collection features under Site Collection Administration header


4. Make sure that PowerPivot Integration for Site Collections feature is activated. If not, activate this feature



5. Click on the Settings icon and choose Add an app from the menu


6. Choose PowerPivot Gallery app



7. Provide the name for your PowerPivot Gallery and click Create



8. Now you can see that PowerPivot Gallery has been added to your SharePoint site



PowerPivot BI, SharePoint 2013 and SQL 2012 Business Intelligence, Power View 2012 Features, Power View 2013

PowerPivot BI, SharePoint 2013 and SQL 2012 Business Intelligence, Power View 2012 Features, SharePoint Power View 2013, SQL 2012 BI

SharePoint Power View 2013
SharePoint 2013 and Power View 2012
PowerPivot BI, SharePoint 2013 and SQL 2012 Business Intelligence, Power View 2012 Features, SharePoint Power View 2013, SQL 2012 BI
Hi all,
Today I want to discuss about the great feature of SharePoint 2013 and SQL 2012 Business Intelligence – SharePoint Power View 2012.

PowerPivot workbooks – work with large number of data

Have you ever stuck on task of improving business in the branches of your company? If yes, then you found what you were looking for. Please let me explain it.
Suppose that you want to compare large amounts of data, make reports of analysis with graphs, tables, etc. and pass all reports to other departments of your company. To simplify your task you can use MS Office 2013 (Microsoft Access 2013 or Microsoft Excel 2013) to create reports that contained a lot of data with graphs, pictures and tables. Let’s imagine that you spent a lot of time and created many reports, but you still can not decide how to share all reports with a lot of data for other departments of your company?
There are several of major problems you can get when try to share files to other departments:

  • security (in my opinion send all data by mail not very secure way to share reports for other, is not it?)
  • different software (how often do you were asked about how to open the file you sent?)
  • opportunity making changes that are available instantly for anyone
  • opportunity for all employees from different departments to see the same document at the same time

As you can see there are a lot of problems which must be solved to make easy your work. Please no worries I have a solution for you! It`s a SharePoint Power View feature which is included to the SharePoint 2013 and SQL 2012 Business Intelligence. You can get all of Business Intelligence 2012 benefits with PowerPivot for SharePoint 2013. Please stay with me and let`s take a look at the Power View SharePoint 2013 feature overview.

SharePoint 2013 Power View feature overview

Power View in Excel 2013 and Power View in SharePoint 2013 both provide an interactive data exploration, visualization, and presentation experience for all skill levels. Pull your data together in tables, matrices, maps, and a variety of charts in an interactive view that brings your data to life. The Power View feature enables quick and easy visualization of large data while allowing sharing and collaboration of business insights in a familiar SharePoint 2013 Business Intelligence environment.

SharePoint 2013 and SQL 2012 Business Intelligence (BI hosting, PowerPivot hosting)

If you already have some kind of BI hosting probably you already enjoyed the SharePoint Power View feature. In other case you need to get PowerPivot hosting from one of the Business Intelligence hosting providers (please note that PlexHosted offer such kind of the BI hosting) and store workbooks and reports to the one place – SharePoint 2013 site. Please see the example of Power View Chart at the screen below:
SharePoint 2013 Power View
SharePoint 2013 Power View

Power View 2012 features (SharePoint 2013 and SQL 2012)

A Power View report is always presentable – you can browse your data and present it at any time, because you’re working with real data. You don’t need to preview your Business intelligence report to see how it looks. Power View 2012 does have reading and full-screen presentation modes, in which the ribbon and other design tools are hidden to provide more room for the visualizations. All workbooks and reports are still fully interactive, with filtering and highlighting capability. You can export an interactive version of your Power View 2013 report to PowerPoint 2013 (each view in Power View becomes a separate PowerPoint slide). Interacting with Power View reports exported to PowerPoint is similar to interacting with Power View views in Power View reading and full-screen modes: You can interact with the visualizations and filters that the report creator has added to each view, but you cannot create visualizations or filters.
Power View 2012 report with multiple views featuring tiles, slicers, a chart filter, and a number of visualizations, including cards, small multiples, and a bubble chart. With SharePoint 2013 Power View you can use such great features as:
  • Power View Time Series Analysis: ability to perform dynamic and interactive time series analysis with Power View.
  • Power View: ability to visualize and interact with data in new ways with Power View.
  • Power View Trellis Charts: ability to compare your data in Power View with trellis charts.

Power View for SharePoint 2013

So, as you can see, the Power View feature for SharePoint 2013 meets all your requirements and can resolve all problems described previously. Now, you can share your workbooks and Power View reports in the secure way without worry about the installed at the other user PCs software. In addition you can get the ability making changes that are available instantly for anyone. Now, all employees from different departments and geographical locations can see the same document at the same time.

Try the Power View feature of SharePoint and make your business more effective!


BI Hosting with PlexHosted, BI 2012, PowerPivot Hosting, SharePoint 2013 Business Intelligence, SQL 2012 BI

BI Hosting with PlexHosted, BI 2012, PowerPivot Hosting, SharePoint 2013 Business Intelligence, SQL 2012 Business Intelligence

Microsoft SQL 2012, BI 2012, BI Hosting, SQL 2012 Business Intelligence, SQL 2012 BI, SharePoint Power View, PowerPivot for SharePoint, PowerPivot BI, SharePoint 2013 Business Intelligence
Business Intelligence with SharePoint 2013
Business Intelligence with SharePoint 2013
Hi my dear reader,
I would like to inform you about the ability of PowerPivot 2012 workbooks hosting. You can share your BI workbooks and big BI data to the PowerPivot services for SharePoint 2013 and easily manage them at the SharePoint 2013 site. What more – you can use and check all great features of the SQL 2012 platform without installing it to the local server.

PowerPivot workbooks at the SharePoint 2013 site

With PowerPivot service for SharePoint 2013 you can easy share, manage created via MS Excel 2013 PowerPivot workbooks. With SQL 2012 Business Intelligence which PlexHosted have there you can get more fast analyzing and pretty BI SharePoint site with Power View and other great features of SharePoint 2013 BI.

PowerPivot Hosting 2013 Announce

PlexHosted Company is pleased to announce the availability of PowerPivot SharePoint 2013 Hosting.
With the PlexHosted Business intelligence plan of SharePoint 2013 you can store a lot of workbooks with big data more effective and easily to set up web sites to share information with others, manage BI reports and publish PowerPivot reports to help everyone make better decisions.
PlexHosted staff will be happy to help you set up PowerPivot SharePoint 2013 sites in shared (multi-tenant) or dedicated environment depended of your needs and insure that your SharePoint PowerPivot 2013 hosting environment is secure with faster response times and superior throughput.

With SharePoint Business Intelligence 2013 services from PlexHosted you can appreciate a lot of new PowerPivot 2012 features. Please see a couple of SharePoint 2013 and SQl 2012 benefits:

  • Create and share PowerView reports
  • Store and show PowerPivot workbooks more easily
  • Fast analyzing big data from stored PowerPivot workbooks
  • Improved from previous version SharePoint 2013 Business Center design

Improved from previous version SharePoint 2013 Business Center design