Interested in learning more about Analysis Services 2012?

As you all know I published a book about Getting Started with SQL Server 2012 Cube Development http://www.packtpub.com/getting-started-with-sql-server-2012-cube-development/book. The aim of the book is to teach beginners that want to start their career in Business Intelligence and specifically Analysis Services how to create their first cube and then progress to become an intermediate BI developer….

1

Creating a BI test machine in the cloud and allowing anonymous access to it

I got a question from a colleague that wanted to know how he could create and connect anonymously to a BI machine in the cloud. There are several whitepapers available but they can be hard to follow if you never have done it before so I thought that I would write a small simple instruction…


New book, new job

The reason that this blog has been awfully quite for the past months is that I have written a book on Analysis Services cube development. This book targets new SSAS developers or people wanting to become one. Readers of this blog will recognize the style of the book, it takes a step-by-step approach and contains…


Installing the BI features of SharePoint 2013

Now that SharePoint 2013 and SQL Server 2012 SP1 have been released I thought about revisiting my post on how to install the BI features of SharePoint 2013. As in the previous post I am installing the bits on a fully updated Windows Server 2008 R2 machine, I have added the Web role as well…

30

SQL 2012 Service Pack 1 is released

Now during SQL PASS they have announced the availability of SQL Server 2012 Service Pack 1 (SP1). You can find the download here. There are two options for the download either a slipstream package or a standalone installation package.   As part of the SP1 release we also released the Microsoft® SQL Server® 2012 SP1…


Working with map data in Power View in Excel 2013 Preview

  One of the new options that you have in Excel 2013 and Power View is to show data on maps. This is a feature that is awaited for, most data in the BI world contains some sort of geographical information.   This could be sales territories, customer locations or production plants, etc. When I first…

8

BI data on maps in SQL Server 2012 part 2

In my previous post http://blogs.msdn.com/b/querysimon/archive/2012/06/17/bi-data-on-maps-in-sql-server-2012.aspx I described how to create a Reporting Services report that contains custom map data. One of the drawbacks with the mapping component in SSRS is that you cannot zoom interactively in your reports. One way to solve this shortcoming is to use linked reports that uses parameters to drill down…

8

BI data on maps in SQL Server 2012 part 1

I often get questions around how to show business intelligence data on maps in the Microsoft BI stack. Some people thinks that we do not support this for the entire world but only for US. I think that this misunderstanding comes from the fact that the map gallery in Reporting Services only shows data from…

2