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

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

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

<Previous Next>