Videos: Microsoft BIG Data

Big Data videos released to YouTube A Growing World of Data – Part 1 of a 4 part series on Microsoft’s unique approach to Business Intelligence and Big Data –       The World of Big Data – Part 2 of a 4 part series on Microsoft’s unique approach to Business Intelligence and Big Data…


Selecting the right Self-Service BI Tool

Self service BI is getting lot of attention, and there are lot of tools out there in the market from multiple vendors. Some with real great visualization and leveraging the new in-memory processing models. Remember that when it comes to Self-service BI you want to make it as easy as possible for the people in…


BigData! Hype or Reality?

I have recently had the opportunity to present on the topic of BigData at several forums including the DW 2.0 Asia-Pac Summit and at the Microsoft Big Picture event. At both these events there were sceptics of BigData and as such I thought I might write this blog post. I must agree partly though with…


SharePoint 2010 Service Pack 1 Now Available

You are reading right, sqlman is talking about SharePoint . The reason for this is that by applying SP1 to your SharePoint 2010 environment, you can improve the performance of PowerPivot based and Excel Services based BI solutions. You can download SharePoint 2010 SP1 from – The main reason for this performance improvement is…


PowerPivot in Action

Microsoft partners Extended Results have done it again. They have released another great PowerPivot based Analytics tool – this time for analysing Twitter feeds. The first was a calendar based analytics tools which allowed you to analyse how you and/or your team spend time based on your calendar events in Microsoft Exchange. Analytics for Twitter…


HPs Business Decision Appliance–Special Pricing for Australia

  HP Business Decision Appliance Quick Start Offer – Make better, faster, more relevant business decisions with the HP Business Decision Appliance The HP Business Decision Appliance, optimized for SQL Server 2008 R2 and SharePoint Server 2010, has been designed together with Microsoft to empower business users to develop unique business insights by analysing massive…

PowerPivot SharePoint Integration Install Bug

I have recently been doing a lot of work with PowerPivot, and installing it at customers site. I have on two occasions now come across the below error message:     Error: Your SQL Server 2008 R2 installation completed with failures.             Object reference not set to an instance of an object. When you view…


Whitepaper: PowerPivot Planning and Deployment

An comprehensive whitepaper regarding the installation and deployment of PowerPivot has been recently released by the SQL CAT Team. It can be accessed from the below site: Direct link to whitepaper: Microsoft SQL Server PowerPivot Planning and Deployment Summary: Microsoft® SQL Server® PowerPivot technology redefines how IT departments deliver and succeed with BI. This…


To BI or not to BI?

My blog post on the Australian IT news site has gone live, and can be found at – Please provide your feedback and comments.


Want to try PowerPivot for Excel 2010, but don’t have access to Excel 2010

Well then follow the below link and you can launch an virtual lab that takes you through the PowerPivot add-in. The only thing you need to install is an ActiveX control to let you access the virtual lab environment.