QuerySimon

Yet another blog about BI

May, 2011

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

    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

    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...
Page 1 of 1 (2 items)