Delighted to announce that I'm be attending and presenting at the Professional SQL Server SQLRally Nordic 2011! The event will be taking place on 8th – 9th November, at the Aronsborg Conference Centre just outside Stockholm, in Sweden. The FaceBook page can be found here. To register for the event, click here and we’ll see… Continue reading Why I’m Excited to be Attending SQLPass SQLRally Nordic 2011!
The current blog will take three different ways of representing the same data set, in order to see how it can be done simply and clearly - or not so clearly. I have taken some samples, and reworked them as a progression throughout this blog.Although I am discussing the iPad here, this is not a… Continue reading Representing data about the iPad
Here, we will look at an example of PowerPivot user feedback that is improved in Denali from SQL Server 2008 R2. User feedback is a vital part of any software. In particular, this is especially important in the case of error handling, regardless of whether it is a pre-emptive measure in preventing error handling, or… Continue reading PowerPivot in Denali: User Feedback and the Fourth Golden Rule of Interface Design
Excel Slicers are incredibly useful for filtering data in Pivot Tables. I like them since they are so very visual; it is easy for users to see the state of the columns that they are filtering. If you've ever been given a large spreadsheet with many, many columns, and tried to work out which field… Continue reading Excel Slicers and Good Interface Design