PowerPivot News

April 12, 2012 - Microsoft released CU1 for SQL Server 2012 PowerPivot

webadmin@SSAS-Info.com (PowerPivot-Info.com) — Fri, 13 Apr 2012 02:36:53 +0000

April 12, 2012 - Microsoft released Cumulative Update 1 (CU1) for SQL Server 2012.

This update contains hotfixes for issues that were fixed after the release of SQL Server 2012. This release has separate download for SQL Server 2012 PowerPivot.

Note: This build number of this cumulative update package is 11.0.2316.0.

List of fixes related to SQL Server 2012 PowerPivot:

Bug number	KB Number	Description
885539	2636425	FIX: Incorrect result when you update multiple Excel 2010 worksheets that use PowerPivot for Excel 2010 at the same time in SQL Server 2008 R2 or in SQL Server 2012
893254	2693568	FIX: Out-of-memory error when you run a DAX query against a Tabular model in SQL Server 2012 Analysis Services

March 6, 2012 - Microsoft released SQL Server 2012 PowerPivot for Excel 2010

webadmin@SSAS-Info.com (PowerPivot-Info.com) — Tue, 06 Mar 2012 22:37:03 +0000

March 6, 2012 - Microsoft released Microsoft SQL Server 2012 PowerPivot for Microsoft Excel 2010.

Download this release here...

To learn more about PowerPivot check SQL Server Virtual Launch event on March 7th, 2012. This event has 20min session "Rapid Data Exploration: Powerful Self-Service Analysis with PowerPivot".

Feb 23, 2012 - Microsoft released Cumulative Update package 5 (CU5) for SQL Server 2008 R2 SP1

webadmin@SSAS-Info.com (PowerPivot-Info.com) — Thu, 23 Feb 2012 18:18:32 +0000

On Feb 23, 2012 - Microsoft released Cumulative Update package 5 (CU5) for SQL Server 2008 R2 Service Pack 1 (SP1).

Cumulative update package 5 for Microsoft SQL Server 2008 R2 SP1 contains hotfixes for issues that were fixed after the release of SQL Server 2008 R2 SP1.

Note This build of this cumulative update package is also known as build 10.50.2806.0.

List of fixes related to PowerPivot:

SQL Bug Number	KB Article Number	Description
854092	2636425	FIX: Incorrect result when you update multiple Excel 2010 worksheets that use PowerPivot for Excel 2010 at the same time in SQL Server 2008 R2
853102	2653917	FIX: "The data refresh job failed because it has been inactive for more than 3600 seconds" error message when you use SQL Server 2008 R2 PowerPivot for SharePoint in some non-English environments

Feb 10, 2012 - Microsoft released Cumulative update package 11 (CU11) for SQL Server 2008 R2

webadmin@SSAS-Info.com (PowerPivot-Info.com) — Mon, 13 Feb 2012 03:21:06 +0000

Feb 10, 2012 - Microsoft released Cumulative update package 11 (CU11) for SQL Server 2008 R2

This update contains following fix related to PowerPivot:

SQL Bug Number	KB Article Number	Description
824538	2636425	FIX: Incorrect result when you concurrently update multiple Excel 2010 sheets that use PowerPivot for Excel 2010 in SQL Server 2008 R2

Nov 17,2011 - Microsoft released SQL Server 2012 PowerPivot for Excel 2010 RC0

webadmin@SSAS-Info.com (webadmin) — Thu, 17 Nov 2011 18:30:13 +0000

Nov 17, 2011 - Microsoft released SQL Server 2012 PowerPivot for Excel 2010 Release Candidate 0 (RC0).

Download here...

July 12, 2011 - Microsoft released SQL Server code name 'Denali' PowerPivot for Microsoft Excel CTP3

webadmin@SSAS-Info.com (PowerPivot-Info.com) — Wed, 13 Jul 2011 01:07:06 +0000

July 12, 2011 - Microsoft released Microsoft SQL Server code name 'Denali' PowerPivot for Microsoft Excel Community Technology Preview 3 (CTP 3)

Download PowerPivot for Excel CTP3 (Denali) here...

Read Microsoft PowerPivot Code-Named "Denali" CTP3 Release Notes here...

Read important installation prerequisites in this SSAS Team post...

Read Project Crescent Overview here...

Getting Started with Project “Crescent” and PowerPivot for Excel in SQL Server Code-Named “Denali” Community Technology Preview 3 (CTP3)...

Available reviews

By Rob Collie here...

June 28, 2011 - Microsoft released Service Pack 1 (SP1) for SharePoint 2010

webadmin@SSAS-Info.com (PowerPivot-Info.com) — Wed, 29 Jun 2011 01:47:01 +0000

June 28, 2011 - Microsoft released Service Pack 1 (SP1) for SharePoint 2010. This service pack has important PowerPivot for SharePoint performance improvements.

You can download SP1 here...

June 5, 2011 - New book released "Business Intelligence in Microsoft SharePoint 2010"

webadmin@SSAS-Info.com (PowerPivot-Info.com) — Mon, 06 Jun 2011 01:25:46 +0000

June 5, 2011 - New book released "Business Intelligence in Microsoft SharePoint 2010" by Norm Warren, Mariano Teixeira Neto, John Campbell, Stacia Misner.

Amazon US

Amazon UK

Amazon Canada

Dive into the business intelligence (BI) features in SharePoint 2010—and use the right combination of tools to deliver compelling solutions. This practical guide helps you explore several BI application services available in SharePoint 2010 and Microsoft SQL Server® 2008 R2. You’ll learn each technology with step-by-step instructions, and determine which ones work best in specific BI scenarios—whether you’re a SharePoint administrator, SQL Server developer, or business analyst.

Choose the BI tools that meet your needs—and learn how they work together
Examine the BI lifecycle, from determining key performance indicators to building dashboards
Take Microsoft Excel® further—gain more control and functionality with web-based Excel Services
Mash up data from multiple sources using PowerPivot for Excel 2010
Create data visualizations with objects, context, and metrics using Microsoft Visio® Services
Build dashboards, scorecards, and other monitoring and analysis tools with PerformancePoint® Services
Use SharePoint to view BI reports side by side, no matter which tools were used to produced them

Note: 35 pages in this books charpter 5 "PowerPivot for Excel and Sharepoint" are about PowerPivot.

March 19, 2011 - New book released "PowerPivot for Business Intelligence Using Excel and SharePoint"

webadmin@SSAS-Info.com (PowerPivot-Info.com) — Sat, 12 Mar 2011 23:17:22 +0000

March 19, 2011 - New book released "PowerPivot for Business Intelligence Using Excel and SharePoint" by Barry Ralston.

Amazon US

Amazon UK

Amazon Canada

PowerPivot Solutions for Excel and SharePoint is aimed at information workers and data analysts who typically use Excel to drive business decisions. The book shows how you can apply PowerPivot to problems typically addressed through complicated and arcane spreadsheet techniques. Business people without the time and interest in learning Excel arcane will especially appreciate how PowerPivot enables them to easily create models and perform analysis far in advance of anything they could do using Excel alone.

What you’ll learn

Install and verify the PowerPivot software
Integrated existing, available data to deliver business intelligence
Leverage Time Intelligence to report change over time
Write Data Analysis Expressions (DAX) to create custom measures
Identify and implement solutions for role-playing dimensions
Recognize and work-around PowerPivot’s missing features

Feb 5, 2011 - New book released "Getting Started With PowerPivot For Excel 2010"

webadmin@SSAS-Info.com (PowerPivot-Info.com) — Sat, 05 Feb 2011 21:47:11 +0000

Feb 5, 2011 - New book released "Getting Started With PowerPivot For Excel 2010", by Indera E Murphy

Amazon US

Amazon UK

Amazon Canada

In a user friendly, step-by-step way, you will learn the following: How to use the Table Import Wizard, How to import data into PowerPivot, How to create pivot tables and pivot charts using data in PowerPivot, How to create DAX formulas and much more.