QuerySimon

Yet another blog about BI

Analytics over streaming data reference architecture

More and more companies want to build real-time analytics that enables them to do analysis over a...

Date: 01/26/2015

Book review: Machine Learning Hands-On for Developers and Technical Professionals

The third book that I finished this vacation were Machine Learning Hands-On for Developers and...

Date: 01/01/2015

Book review: Data Scientists at Work

Second book that I read this vacation is Data Scientists at Work by Sebastian Gutierrez published by...

Date: 12/31/2014

Book review: Predictive Analytics with Microsoft Azure Machine Learning

Right now I am on an extended holiday and I have had some time to tick of some books from my reading...

Date: 12/27/2014

Preview of Power BI dashboards is available and book promotion

Couple of things before vacation starts first the Power BI preview has been released. It contains...

Date: 12/19/2014

Big Data patterns

Big data is the buzz of the day, many talk about it but few have done anything with the technology....

Date: 07/02/2014

SQL Bits UK

This summer I am attending and speaking at several conferences. Most of them are internal to...

Date: 06/30/2014

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...

Date: 03/20/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...

Date: 11/01/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...

Date: 10/10/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...

Date: 11/25/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...

Date: 11/10/2012

SQL 2012 Service Pack 1 is released

Now during SQL PASS they have announced the availability of SQL Server 2012 Service Pack 1 (SP1)....

Date: 11/07/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....

Date: 10/23/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...

Date: 09/17/2012

PASS SQLRally 2012 Nordic here we come

Be sure to attend the PASS SQLRally 2012 in Copenhagen. You have the opportunity to listen to the...

Date: 08/14/2012

PPS future in SharePoint 2013

The development team have released a new blog post outlining the improvements that have been made...

Date: 08/09/2012

Installing the BI features of SharePoint 2013 Preview

I have now added a new post on how to install the BI features in the released version of SharePoint...

Date: 07/24/2012

Creating your first PowerPivot Workbook in Excel 2013 Preview

Please note I am not a member of the Dev team. My posts are just things that I have found when...

Date: 07/23/2012

SQL Server 2012 has been released

More information can be found on https://www.microsoft.com/presspass/presskits/sqlserver/

Date: 03/06/2012

Will you be at SQL Rally Nordic?

  I got my session submission accepted to SQL Rally Nordic. I will be speaking about how to...

Date: 08/30/2011

Enabling Crescent in SharePoint 2010

  If you followed my earlier post...

Date: 07/22/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...

Date: 07/18/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...

Date: 07/15/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...

Date: 07/13/2011

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

The new service pack for SharePoint 2010 has been released to the web as communicated in the...

Date: 07/06/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...

Date: 05/22/2011

Handling Dates in PowerPivot

Recently a former colleague contacted me on how to format dates in PowerPivot. She had a date column...

Date: 05/10/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...

Date: 03/03/2011