QuerySimon

Yet another blog about BI

Blog - About

About QuerySimon

My name is Simon Lidberg and I have been working for Microsoft with SQL Server since 2000, when I joined from Compaq where I used to work as a SAP Basis consultant. At Microsoft I have had various roles within support and sales but always with SQL Server since many years I have now moved into the BI space. It is really a fascinating to help companies and organizations get data out of their databases in a way that ordinary people can understand and consume. Right now I work as a Solution Architect in the Data Insights Center of Excellence.

  • QuerySimon

    Installing the BI features of SharePoint 2013

    • 24 Comments
    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...
  • QuerySimon

    Installing the BI features of SharePoint 2013 Preview

    • 14 Comments
    I have now added a new post on how to install the BI features in the released version of SharePoint 2013 you can find it here http://blogs.msdn.com/b/querysimon/archive/2012/11/26/installing-the-bi-features-of-sharepoint-2013.aspx Since the release...
  • QuerySimon

    Writeback to Analysis Services cubes from Excel 2010

    • 8 Comments
    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...
  • QuerySimon

    BI data on maps in SQL Server 2012 part 1

    • 0 Comments
    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...
  • QuerySimon

    Creating your first PowerPivot Workbook in Excel 2013 Preview

    • 2 Comments
    Please note I am not a member of the Dev team. My posts are just things that I have found when playing with the new Office bits. My findings may be inaccurate or an error on my part. After installing Excel 2013 you may would like to create a new workbook...
  • QuerySimon

    Working with map data in Power View in Excel 2013 Preview

    • 4 Comments
    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...
  • QuerySimon

    BI data on maps in SQL Server 2012 part 2

    • 3 Comments
    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...
  • QuerySimon

    How to control allocations when using write-back in Excel 2010

    • 2 Comments
    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...
  • QuerySimon

    Installing SharePoint 2010 together with Denali CTP3

    • 0 Comments
    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...
  • QuerySimon

    Using the Bing API to geocode data in SSIS

    • 4 Comments
    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...
  • QuerySimon

    Handling Dates in PowerPivot

    • 0 Comments
    Recently a former colleague contacted me on how to format dates in PowerPivot. She had a date column in a PowerPivot workbook that she wanted to show on the row axis in a PivotTable. However no matter how she formatted the column either in the PowerPivot...
  • QuerySimon

    First impressions installing Denali CTP3 SSAS

    • 8 Comments
    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...
  • QuerySimon

    Problems with the SSAS Tabular Model Projects Denali CTP3 samples

    • 0 Comments
    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...
  • QuerySimon

    SharePoint 2010 SP1 is here, what’s in it for BI

    • 0 Comments
    The new service pack for SharePoint 2010 has been released to the web as communicated in the official blog at http://sharepoint.microsoft.com/blog/Pages/BlogPost.aspx?pID=984 You can now download it from here: http://www.microsoft.com/download/en...
  • QuerySimon

    SQL 2012 Service Pack 1 is released

    • 0 Comments
    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...
  • QuerySimon

    Enabling Crescent in SharePoint 2010

    • 0 Comments
      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...
  • QuerySimon

    PPS future in SharePoint 2013

    • 0 Comments
    The development team have released a new blog post outlining the improvements that have been made for PPS in SharePoint 2013 and is asking for feedback on what other priorities they should focus on. Read more at http://blogs.msdn.com/b/performancepoint...
  • QuerySimon

    Running SQL Server 2012 and earlier versions on Windows Server 2012

    • 2 Comments
    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...
  • QuerySimon

    Running SharePoint and BI services in the cloud

    • 0 Comments
    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...
  • QuerySimon

    Will you be at SQL Rally Nordic?

    • 0 Comments
      I got my session submission accepted to SQL Rally Nordic. I will be speaking about how to build a forecasting and planning solution based on SQL Server, Excel 2010 and SharePoint 2010. If you have the opportunity to attend you can come around and...
  • QuerySimon

    PASS SQLRally 2012 Nordic here we come

    • 0 Comments
    Be sure to attend the PASS SQLRally 2012 in Copenhagen. You have the opportunity to listen to the best speakers in the industry, see http://www.sqlpass.org/sqlrally/2012/nordic/Speakers.aspx for a list of speakers. I got my session called B(r)inging...
  • QuerySimon

    Interested in learning more about Analysis Services 2012?

    • 0 Comments
    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...
  • QuerySimon

    SQL Server 2012 has been released

    • 1 Comments
    More information can be found on http://www.microsoft.com/presspass/presskits/sqlserver/
  • QuerySimon

    New book, new job

    • 0 Comments
    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...
  • QuerySimon

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

    • 0 Comments
    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...
Page 1 of 2 (27 items) 12