If you’re trying to open a workbook from the SharePoint 2010 PowerPivot Gallery and you get this error: Data overflow converting to the data type for table ‘xxxxxxxxxxxxx’ column ‘Tape_Date’.” This is Excel Services saying that the PowerPivot Workbook is…
Getting started with Master Data Services in SQL Server 2012
Setting up MDS in a 2012 environment isn’t the most straight forward process. 2 issues I encountered while configuring on a standalone Hyper-V VM were IIS related, plus sample MDS package deployment. The following links will help to make the…
More BI videos – Ad-hoc reports, Data Mining
Data Mining: http://youtu.be/YrnD46xMFNk Ad-hoc reports : http://youtu.be/RWjUYpwOx70
SQL Server Business Intelligence – PowerPivot
MS SQL Server 2008 R2 Business Intelligence: PowerPivot http://youtu.be/hDCTr0AsGOg another vid
SQL Server Business Intelligence – Maps Integration
MS SQL Server 2008 R2 Business Intelligence: Maps Integration http://youtu.be/7Ukl6h06YDc A video I put together regarding Maps integration and MS SQL Server.
PowerPivot…
…is only supported by Excel 2010. While the Data mining add in will work with Excel 2007, Powerpivot will not.