Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Information, tips, news and announcements about Azure Analysis Services (Azure AS) and SQL Server Analysis Services (SSAS) directly from the product team.
Released: DAX Editor for SQL Server
I am very pleased to announce that the DAX Editor for SQL Server has been released to CodePlex for...
Author: Cathy Dumas - Date: 11/03/2011
Impact of the SQL Server OLE DB Deprecation on Analysis Services
A few weeks back, the SQL Server connectivity team announced on their blog that the SQL Server OLE...
Author: T.K. Anand Date: 09/13/2011
Exploring the PowerPivot for SharePoint Configuration Tool
The PowerPivot Configuration Tool included in SQL Server Code Name “Denali” CTP3 is...
Author: KayUnkroth Date: 09/01/2011
Released: SQL Server Code Name “Denali” CTP3 Product Guide
Looking for datasheets, white papers, click-through and auto-running demonstrations, hands-on lab...
Author: KayUnkroth Date: 08/10/2011
Analysis Services Blog Post Roundup for Denali CTP3
A few AS team members have started blogging on Denali functionality at their personal blog...
Author: KayUnkroth Date: 08/08/2011
How to Build a VSTO-Based PowerPivot Workbook
Microsoft Visual Studio Tools for Office (VSTO) is an awesome development suite for building...
Author: KayUnkroth Date: 08/04/2011
About the Relativity of Large Data Volumes
Some conversations in our team are really priceless. The other day, while working on an article...
Author: KayUnkroth Date: 07/26/2011
The Diagram is here…
Probably one of the most frequently requested features we have had for PowerPivot V1 has been...
Author: Julie Strauss [MSFT] Date: 07/20/2011
Released: Denali CTP3 Samples and TechNet Wiki
This was a big announcement week for us. Let’s finish it with a note about our new Denali CTP3...
Author: KayUnkroth Date: 07/15/2011
Adding Values to Rows and Columns
The release notes for CTP3 references the ability to add values to rows and columns. But what...
Author: Julie Strauss [MSFT] Date: 07/15/2011
Released: Microsoft SQL Server 2008 R2 Service Pack 1
This week is packed with big announcements: We released Microsoft SQL Server Code Name...
Author: KayUnkroth Date: 07/13/2011
Welcome to Tabular Projects
With SQL Server “Denali” CTP3, there are two types of Analysis Services projects in...
Author: Cathy Dumas - Date: 07/13/2011
Submit Your Feedback on Analysis Services and PowerPivot
Now that the Microsoft SQL Server Code Name “Denali” Evaluation edition is available for...
Author: KayUnkroth Date: 07/12/2011
Announcing Microsoft SQL Server Code Name “Denali” Community Technology Preview 3 (CTP3)
Today we released our next public CTP of Microsoft SQL Server Code Name “Denali.” This...
Author: KayUnkroth Date: 07/12/2011
Creating a Stock Ticker View for Performance Data in PowerPivot
My previous blog post “Analyzing Performance Data in PowerPivot” explained how to create...
Author: KayUnkroth Date: 07/05/2011
Released: Service Pack 1 for Microsoft SharePoint Server 2010
Today is a great day for us PowerPivoteers because Service Pack 1 for Microsoft SharePoint Server...
Author: KayUnkroth Date: 06/28/2011
PowerPivot at the Microsoft.com Download Center
The Download Center team just released a new version of the Microsoft.com Download Center (DLC). It...
Author: KayUnkroth Date: 06/27/2011
Analyzing Performance Data in PowerPivot
PowerPivot is an absolutely fantastic performance analysis tool. You might say that I’m...
Author: KayUnkroth Date: 06/14/2011
Sample Application Released: Analytics for Twitter
This week, we released Microsoft Analytics for Twitter, an awesome PowerPivot application to query...
Author: KayUnkroth Date: 06/11/2011
White Paper Published: Using SharePoint List Data in PowerPivot
Do you want to analyze SharePoint document libraries or lists? Then read Uday S. Unni’s...
Author: KayUnkroth Date: 06/10/2011
Analyzing Event Log Entries in PowerPivot
PowerPivot for Excel is a great analysis tool for information workers. You can import data from any...
Author: KayUnkroth Date: 05/31/2011
Analysis Services – Vision & Roadmap Update
At the TechEd North America 2011 conference in Atlanta this week, the SQL Server team is providing...
Author: KayUnkroth Date: 05/16/2011
PowerPivot TechCenter
So in PowerPivot User Education, we're regularly approached by someone who says something like, "You...
Author: Ed Price - MSFT Date: 02/22/2011
Install PowerPivot for SharePoint on a Domain Controller
Take a video tour of this 4-part PowerPivot video series: How to install a system and get it up and...
Author: Ed Price - MSFT Date: 01/10/2011
Optimized DataMarket integration available with updated version of PowerPivot
Yesterday at PDC2010, Microsoft announced the RTW of Windows® Azure™ Marketplace DataMarket...
Author: Julie Strauss [MSFT] Date: 10/29/2010
Behind the scenes of PowerPivot’s automatic relationship detection
At times you will see a notification for the automatic relationship detection appear at the top of...
Author: Julie Strauss [MSFT] Date: 09/16/2010
Using PowerPivot with “Dallas” CTP3
What is Codename "Dallas"? Codename "Dallas" is a service allowing developers...
Author: Julie Strauss [MSFT] Date: 08/16/2010
Looking for PowerPivot information?
It’s been just about a couple of months since PowerPivot was available for customers, and the...
Author: Ashvini Sharma [MSFT] Date: 07/29/2010
Win a signed PowerPivot Architecture Technical Diagram at TechEd NA 2010
There are many reasons to go to TechEd North America 2010 in New Orleans this year. After all,...
Author: Dave Wickert (MSFT) Date: 06/04/2010
PowerPivot RTM launch
We got some emails from readers of this blog asking about the RTM build of PowerPivot. This blog...
Author: T.K. Anand Date: 06/01/2010
PowerPivot: Content + Community
[This blog post was authored by Ed Price from the PowerPivot user education team.] We’ve been...
Author: T.K. Anand Date: 06/01/2010
Sorting month by natural sort order
When a field containing month names is added to a PivotTable or to a Slicer the field is sorted in...
Author: Julie Strauss [MSFT] Date: 04/21/2010
Fix for PowerPivot Expiration Released
The PowerPivot team is pleased to report that the fix for the November CTP expiration issue has been...
Author: T.K. Anand Date: 04/07/2010
PowerPivot for Excel 2010 November CTP Expired
If you are running the November 2009 CTP version of the PowerPivot for Excel 2010 add-in, your...
Author: T.K. Anand Date: 04/02/2010
PowerPivot Component Architecture
(excerpt from a pending “Microsoft SQL Server PowerPivot Planning and Deployment” technical white...
Author: Dave Wickert (MSFT) Date: 03/22/2010
New enhancements to the PowerPivot user experience
Throughout the release of PowerPivot for Excel we have continuously been working on evolving the end...
Author: Julie Strauss [MSFT] Date: 03/16/2010
Comparing Analysis Services and PowerPivot
As more customers are getting aware of PowerPivot, they’re looking for more guidance on when to use...
Author: Ashvini Sharma [MSFT] Date: 03/12/2010
Data Import In November CTP
New Data Sources This post takes a closer look at the variety of sources PowerPivot can to import...
Author: Ashvini Sharma [MSFT] Date: 12/07/2009
PowerPivot Data Refresh
In this posting we will take a look at the data refresh facility in PowerPivot for SharePoint and...
Author: Dave Wickert (MSFT) Date: 11/20/2009
Sharing workbooks using PowerPivot Gallery
Now that you have downloaded the PowerPivot for Excel November Technology Preview at PowerPivot.com,...
Author: johnchanc Date: 11/20/2009
November Technology Preview of PowerPivot is here!
If you thought everything in the August Technology Preview was great (for a reminder of what was...
Author: Sherry Irwin [MSFT] Date: 11/18/2009
Linked Tables
In our previous blog post, we discussed how easy it is to use the Copy/Paste feature of the...
Author: T.K. Anand Date: 10/26/2009
Introducing PowerPivot
At the Microsoft SharePoint Conference yesterday in Las Vegas, we announced the official name for...
Author: T.K. Anand Date: 10/20/2009
Copy/Paste
One of the core tenets of Gemini is that the user should be able to import data from virtually any...
Author: T.K. Anand Date: 10/12/2009
Introduction to Data Analysis Expressions (DAX) in Gemini
Gemini and DAX Extend the Power of PivotTables Excel PivotTables are not new, but Excel PivotTables...
Author: Howie Dickerman [MSFT] Date: 10/01/2009
Data Feeds
One of the keys to self-service BI is that people need the highest quality, up-to-date data for...
Author: johnchanc Date: 09/24/2009