One of the biggest new features in Excel 2013 is the ability to import and analyze massive amounts of multi tabular data. However, it’s not really all that new –… Continue reading Using the new Excel 2013 Data Model with SharePoint
Tag: PowerPivot
Quick PowerPivot/PowerView Demonstration on SharePoint Shop Talk
On a recent SharePoint Shoptalk, I presented a quick overview of PowerPivot and PowerView working in SharePoint. The demonstration uses some real world data, and covers a number of the… Continue reading Quick PowerPivot/PowerView Demonstration on SharePoint Shop Talk
The Health Analyzer and PowerPivot for SharePoint
*Note – Updated 2012-09-07 The Health Analyzer that first appeared in SharePoint 2010 is a fantastic idea. Periodically, (you say when) timer jobs run to check predefined health rules, and… Continue reading The Health Analyzer and PowerPivot for SharePoint
Fixing Access Errors When Creating a BISM Connection for PowerView
PowerView is one of the shiny new features that are available to SharePoint users with the implementation od SQL Server 2012. To be sure, you don’t need to convert your… Continue reading Fixing Access Errors When Creating a BISM Connection for PowerView
Connecting to Cubes and External Data with Excel in SharePoint
While many people are still unaware of it, Excel 2010 (and even previous versions) is a very powerful business intelligence client. That’s right, I said Excel. And I don’t mean… Continue reading Connecting to Cubes and External Data with Excel in SharePoint