Analysis Services Team Blog
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