Microsoft recently gave away some of the changes that will be incorporated into SharePoint 2013 and Microsoft Office 2013. Here are a few of those changes:

PowerPivot – PowerPivot’s capabilities will be dramatically improved upon in the updated versions of these Microsoft flagships. The new version of Excel 2013 will now be able to import millions of rows of data, and will be capable of bringing this data in from several different sources at once.

This is where the cloud will become especially helpful, as it can now be leveraged for data processing. The SQL Server 2012 analytics engine will make it possible to process this data relatively quickly in order to compress these massive quantities of data into interfaces that are simple to understand and familiar to users.

Additionally, it will now be possible to filter the data as it is imported, so that irrelevant information isn’t collected by the system. Users will be able to define which performance indicators are most important, and to define data types. They will also be able to create advanced mathematical formulas for processing the data using a new expression language called “Data Analysis Expressions.”

Clearly, these monstrous data capabilities will require new tools for IT management. SharePoint 2013 is expected to include several new tools that will make this process much simpler. It will include new spreadsheet analysis tools with diagnostics that can be customized via an interactive interface. SharePoint will also be able to discover newly generated spreadsheets.

 

Power View – Capabilities that were available for Power View via SharePoint in 2010 will now also be available through Excel 2013 as well. Additionally, new features will be available through both interfaces. This means it will now be possible to do data modeling directly from Excel 2013.

On the downside, Power View is not expected to be directly useable through SkyDrive, Microsoft’s cloud storage system. When using Office 365, instead of the standard Office 2013, Power View will need to be used via the new Excel Web App Data Center, which will be useable through a wide variety of devices.

 

By Mike Marcin, DynamicPoint a California (CA) Microsoft SharePoint Partner