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.
Recently we released a great TechNet Virtual Lab that will take you through many of the new...
Author: Kasper de Jonge [MSFT] Date: 02/19/2016
What is new in SQL Server Analysis Services 2016 CTP3.3 It is a new year and again we are delivering...
Author: Kasper de Jonge [MSFT] Date: 02/03/2016
Second White Paper Published: Deploying SQL Server 2016 PowerPivot and Power View in a Multi-Tier SharePoint 2016 Farm
Last month, we published a white paper about Deploying SQL Server 2016 PowerPivot and Power View in...
Author: KayUnkroth Date: 01/19/2016
What is new in SQL Server Analysis Services 2016 CTP3.2 Just a few weeks after releasing SQL Server...
Author: Kasper de Jonge [MSFT] Date: 12/17/2015
The PowerPivot add-in for SharePoint Server 2016 was published for the first time as part of the...
Author: KayUnkroth Date: 12/08/2015
After last month’s SQL Server Analysis Services 2016 CTP3 we are shipping yet again this...
Author: Kasper de Jonge [MSFT] Date: 11/30/2015
We are really excited to announce the SQL Server 2016 Analysis Services CTP 3 update can be...
Author: Kasper de Jonge [MSFT] Date: 10/28/2015
Extended Events were introduced into Analysis Services in SQL Server 2012. This made use of a common...
Author: Adam W. Saxton Date: 09/22/2015
One of the great new features that was actually added back in CTP 2.0 of SQL Server 2016 Preview is...
Author: Kasper de Jonge [MSFT] Date: 09/16/2015
In my previous blog post “What’s new in Microsoft SQL Server Analysis Services Tabular...
Author: Kasper de Jonge [MSFT] Date: 09/08/2015
This is an exciting time for SQL Server Analysis Services as we start to release updates to our...
Author: Kasper de Jonge [MSFT] Date: 09/02/2015
Update: Download the latest version of Data Mining add ins here that solve this issue. Unfortunately...
Author: Kasper de Jonge [MSFT] Date: 08/05/2015
Imagine that you wanted to see a daily sales report for each day that also included month to date...
Author: Josh Caplan -MSFT Date: 06/24/2014
Let’s say I wanted to analyze query performance on my SQL database. I have a log that has all...
Author: Josh Caplan -MSFT Date: 06/05/2014
Yesterday we released SQL Server Data Tools – Business Intelligence for Visual Studio 2013...
Author: Kasper de Jonge [MSFT] Date: 04/02/2014
This week, we released Management Packs for SQL Server 2008 and 2012 Analysis Services. The...
Author: KayUnkroth Date: 01/31/2014
In this pre-release version of SQL Server 2014, SSDT BI is no longer included in setup. For SQL...
Author: Eswar Perla Date: 07/02/2013
On November 29, 2012 we released the “Power View for Multidimensional Models --...
Author: Siva Harinath Date: 05/31/2013
Kerberos Configuration Manager for SQL Server (KerberosConfigMgr) was released on May 15th 2013, and...
Author: KayUnkroth Date: 05/23/2013
Accounting and Finance Professionals have a new learning resource. The Profit and Loss Data Modeling...
Author: Kasper de Jonge [MSFT] Date: 05/14/2013
Back in 2011, we released a great PowerPivot sample application to query Twitter and analyze tweets...
Author: KayUnkroth Date: 03/15/2013
Today we are releasing SQL Server Data Tools – Business Intelligence for Visual Studio 2012...
Author: Kasper de Jonge [MSFT] Date: 03/06/2013
On the surface the SQL Server 2012 SP1 looks very much like SQL Server 2012 RTM but there are some...
Author: Kasper de Jonge [MSFT] Date: 01/04/2013
In SharePoint 2013, Excel Services comes with numerous improvements. One of the most significant for...
Author: KayUnkroth Date: 12/21/2012
Hi everyone, We’re doing a survey of BI Professionals and we’d love to get input from...
Author: T.K. Anand Date: 11/30/2012
Microsoft is offering SQL Server customers the opportunity to test and provide feedback on new...
Author: T.K. Anand Date: 11/29/2012
Over recent months, we had a lot of fun creating a Microsoft BI poster for SQL Pass and SharePoint...
Author: KayUnkroth Date: 11/26/2012
This was a big day for us as Ted Kummert (Vice President for SQL Server) announced the general...
Author: KayUnkroth Date: 11/07/2012
The new SharePoint 2013 release is bringing lots of excitingnew things, and on this blog post we...
Author: Mariano Teixeira Neto [MSFT] Date: 11/05/2012
JuanPablo just released an interesting cmdlet library to manage Tabular Models using PowerShell. It...
Author: KayUnkroth Date: 10/02/2012
The previous blog post, Supporting Multiple PowerPivot Versions, contained a PowerShell script that...
Author: Ron Pihlgren [MSFT] Date: 10/01/2012
Over the past few weeks, I had an opportunity to work with colleague Denny Lee and David P Mariani...
Author: KayUnkroth Date: 09/26/2012
Last Thursday, we released SQL Server 2012 Service Pack 1 (SP1) CTP4. Both the Service Pack and...
Author: KayUnkroth Date: 09/24/2012
SharePoint has practically always relied on a Central Administration Web site to provide a...
Author: KayUnkroth Date: 08/20/2012
SQL Server 2012 Analysis Services (SSAS) supports three different deployment modes:...
Author: KayUnkroth Date: 08/17/2012
The configuration of PowerPivot for SharePoint entails a critical phase concerning the deployment of...
Author: KayUnkroth Date: 08/14/2012
In this article, I will use the following features: Parent Child Relationships, Row Level Security...
Author: BradleyOuellette Date: 08/10/2012
Verifying the SharePoint 2013 Configuration for Accessing Workbooks as a Data Source from Within the Farm
My previous blog post, “Verifying the Excel Services Configuration for PowerPivot in...
Author: KayUnkroth Date: 08/06/2012
In SharePoint 2013, Excel Services natively supports core PowerPivot functionality. This is an...
Author: KayUnkroth Date: 08/02/2012
Ideally, you can find the Microsoft BI stack in every SharePoint farm across the enterprise so that...
Author: KayUnkroth Date: 07/27/2012
PowerPivot for Excel, first introduced with SQL Server 2008 R2 in April of 2010, opened...
Author: Julie Strauss [MSFT] Date: 07/26/2012
Last week, we released the public CTP of Microsoft SQL Server 2012 Service Pack 1. For most SQL...
Author: KayUnkroth Date: 07/23/2012
Since the release of SQL Server 2012, users can choose between two different versions of PowerPivot...
Author: KayUnkroth Date: 07/18/2012
Along with the SQL Server 2012 launch, Microsoft announced xVelocity in-memory technologies,...
Author: KayUnkroth Date: 03/09/2012
This is it! Microsoft SQL Server 2012 has been released to manufacturing (RTM), with an evaluation...
Author: KayUnkroth Date: 03/06/2012
Never had the time to learn DAX? Now is the time!Author Owen Duncan just released a DAX 101 course...
Author: KayUnkroth Date: 01/26/2012
This article is a follow-up on a previous blog post titled “How to Build a VSTO-Based...
Author: KayUnkroth Date: 01/06/2012
Happy New Year 2012, everybody! With the release of SQL Server 2012 ante portas, this is going to be...
Author: KayUnkroth Date: 01/04/2012
Today, we’ve reached the next big milestone on the road to unlocking breakthrough insights...
Author: KayUnkroth Date: 11/17/2011