Yet another blog about BI
Translate This Page
Translate this page
Excel 2013 Preview
Office 2013 Preview
Service Pack 1
SharePoint 2013 Preview
SQL Server 2012
SQL Server 2012 SP1
Windows Server 2012
Browse by Tags
Tagged Content List
SQL Bits UK
This summer I am attending and speaking at several conferences. Most of them are internal to Microsoft such as TechReady which is similar to TechEd but only for the Microsoft field. However one of them is external and that is SQLBits on the 17th - 19th July 2014 at The International Centre, Telford,...
30 Jun 2014
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 on how to...
1 Nov 2013
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...
10 Oct 2013
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 as the Application...
25 Nov 2012
Running SQL Server 2012 and earlier versions on Windows Server 2012
I have got a lot of questions on how to install and run SQL Server on Windows Server 2012. Now we have released a knowledge base article that outlines the required software prerequisites for running SQL Server on Windows Server 2012. The article talks about all versions of SQL Server 2005, 2008, 2008...
10 Nov 2012
Using the Bing API to geocode data in SSIS
During my talk at SQLRally Nordic Bringing maps to SQL Server I showed how to geocode data in SSIS. The way I did this was to create a custom component in SSIS. In this post I will show how this was done. The first thing that I did was to create a new project in Visual Studio 2012. The type...
23 Oct 2012
Running SharePoint and BI services in the cloud
I have been thinking about writing a post about this for a long time. However now a new whitepaper was released that explains how to configure a BI environment in Azure. It is called SharePoint Deployment on Windows Azure Virtual Machines and describes the steps in detail. You can find the paper here...
17 Sep 2012
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...
18 Jun 2012
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...
17 Jun 2012
SQL Server 2012 has been released
More information can be found on http://www.microsoft.com/presspass/presskits/sqlserver/
6 Mar 2012
Enabling Crescent in SharePoint 2010
If you followed my earlier post ( http://blogs.msdn.com/b/querysimon/archive/2011/07/18/installing-sharepoint-2010-together-with-denali-ctp3.aspx ) about installing Denali CTP3 together with SharePoint 2010 then you will find that Reporting Services have not been enabled in the SharePoint site...
22 Jul 2011
Installing SharePoint 2010 together with Denali CTP3
Now that Denali CTP3 is out I would like to setup a complete demo environment on one of my VM’s for a base image I suggest that you can use the pre-installed one from http://www.microsoft.com/windowsserver2008/en/us/virtual-hard-drive.aspx . The installation of Denali CTP3 was very straight forward,...
18 Jul 2011
Problems with the SSAS Tabular Model Projects Denali CTP3 samples
UPDATE: The samples have been refreshed if you experience this problem please download the samples again and it has been fixed. As part of understanding the new Tabular Model in Analysis Services I downloaded the sample databases from http://msftdbprodsamples.codeplex.com/releases/view/55330...
15 Jul 2011
First impressions installing Denali CTP3 SSAS
Now that Denali CTP3 have been released to the public I wanted to post a blog post of the installation procedures. Installation is very similar to previous versions. First thing to do is to run the SQLFULL_x64_ENU_Install file that will unpack the installation files. By default it will unpack the files...
13 Jul 2011
How to control allocations when using write-back in Excel 2010
One of the first questions that I usually gets when showing write-back in Excel 2010 to Analysis Services cubes is how you can control the allocation of values between dimension members. By default you will get an equal allocation based on the number of dimension members. This setting will divide the...
22 May 2011
Writeback to Analysis Services cubes from Excel 2010
Analysis Services have had write back functionality for a long time; however there has been no client support for writeback in the most used BI client on the market (Excel). One of the new features in Excel 2010 is the ability to perform writeback to Analysis Services cubes. In order to write back...
3 Mar 2011
Page 1 of 1 (16 items)
© 2014 Microsoft Corporation.
Privacy & Cookies