Archive for the ‘Off-topic’ Category
Voting has closed in the Power BI competition, and I just wanted to say thank you to everyone who supported me. I ended up in 6th place with 681 votes and 4812 votes – so I made it to the top ten, and I’m very pleased with that result.
There are too many people to thank individually, but I would like to single out Carmel Gunn, Jen Stirrup, and the whole of the UK, Irish, Belgian and French SQL Server communities, as well as the (literally) hundreds of people I contacted to ask for their support. Special thanks is reserved for my long-suffering wife Helen. I am extremely grateful, and I promise I won’t be bothering you like this ever again!
I am very much aware that the number of votes that I or anyone else received doesn’t necessarily correspond to the quality of the entry. There are a number of other entries that I thought were great that didn’t get any attention and I recommend you check them out while you still can here.
In case the Power BI competition site disappears at some point in the future, you can see my entry on YouTube here. If you want to see the workbook I created for the demos, that can be downloaded here; I’ll be doing a session on March 27th for the PASS Business Analytics Virtual Chapter showing in a lot more detail how I built it, exploring the data more thoroughly, and covering topics like Q&A that I wasn’t able to include in the original video.
So here we are again, yet another blog birthday – the seventh anniversary of my first ever post on this blog and a chance to review 2011.
From a technical point of view this year has been dominated by learning SSAS 2012 Tabular. I’m right in the middle of writing a book about it with Marco and Alberto, and it’ll be published sometime in the first half of next year. As usual writing a book turns out to be ten times more effort than I’d originally planned but it is undoubtedly the best way of learning a new technology: however well you think you know a product, you always find gaps in your knowledge when you have to write about it. My opinion of Tabular continues to grow the more I use it and DAX so I’m feeling very positive about the future and I’m interested to see what the uptake of it will be like after RTM. I’m also very excited to see how Microsoft’s cloud-BI strategy pans out in the next year: products like Data Explorer suggest that Microsoft is serious about this area and, more importantly, coming up with innovative new solutions to its challenges rather than just producing cloud-hosted versions of the software we’ve already got. There are going to be a lot of cool blog posts to write in 2012…
Business-wise I’ve continued to spend more and more time running training courses and a few months ago launched my new training website Technitrain to market not only my SSAS and MDX courses but those run by other well-known SQL Server pros. Our first third-party course with Christian Bolton went well, and next year we’ve got several others booked in. You can see the full course catalogue here; I’d also like to point out the new, lower prices on Jeremy Kashel’s Master Data Services course and Andy Leonard’s SSIS course. Frankly £1248 for a full week of training, let alone from someone of the calibre of Andy Leonard, is a bargain… although I’d argue it only looks that way because we’re too used to the inflated prices of most traditional training companies. More course dates will be announced very soon.
As far as the SQL community goes, I’m very busy speaking at user groups and helping to run SQLBits. The two SQLBits conferences last year in Brighton and Liverpool were great successes, and I still can’t believe we had Steve Wozniak turn up to speak at Brighton; SQLBits 10, which will be running from the 29th-31st of March next year, is already looking like it will beat all previous records for attendance (we’ve got 582 registrations at the time of writing) and will be the biggest and best yet. Next month I’ll be speaking in the UK at the Southampton SQL Server User Group on January 11th, and on January 12th I’ll be speaking at the PASS BI Virtual Chapter so I hope to see some of you there.
Anyway, that’s enough of me going on – it’s time to get back to my writing. Happy New Year everyone!
In December 2004 I made the decision to start a blog: it was Christmas, I didn’t have much to do at work, blogging was the hot new thing and since Mosha had just started one I thought I might as well too. I looked around for somewhere to host my blog and being a good Microsoft person I thought their new free blogging platform would be ideal; I started posting and quickly got hooked. 676 posts and six and a half years later here I am.
As you may have noticed I migrated my blog to WordPress today in response to last week’s news that Windows Live Spaces is being discontinued. I’m not sad about this and indeed had wanted to move my blog for several years, but up until this announcement there was no easy way to migrate away from the Live Spaces platform (MS have now provided a very smooth migration path); I could have started from scratch somewhere else but I didn’t want to lose my old posts and comments and break all the links to my blog that were already out there. Also, I’ll be honest and say that I was lazy and so long as my blog did what I wanted it to do – namely give me somewhere to post and hopefully drive some business for my consulting – then I was ok. I can already see I’m going to be much happier on WordPress though.
Now also seems a good point to sound off about the rubbish treatment I received over the years at the hands of Windows Live Spaces. It seems amazing but in the six years I used it it never got any better, and indeed got noticeably worse with each revision it received: functionality disappeared (including the ability to see any kind of statistics earlier this year) and UI changes made it much harder to find pages in the admin area. It’s services like this that have given MS the bad reputation it’s got today, and it pains me to say that as an MVP whose entire livelihood is built on MS being successful as a company. Why bother creating services and products if they’re just going to be a source of frustration for everyone that uses them, if you’re not going to commit the money and talent to developing them into serious competitors to whatever else is out there? MS should be concentrating on doing the things it does well (like SQL Server) rather than messing around in the world of social media; hopefully the death of Windows Live Spaces means that MS is going to start doing this in the future…
Data audiolization is clearly a real subject that someone, somewhere is researching… and after the fad for data visualisation, why shouldn’t we be thinking about how to represent data with sound? Anyway, I’ll cut to the chase. This video has been doing the rounds on Facebook, it made me laugh and if I didn’t have a hundred better things to be doing I’d be downloading a copy of Microsoft Songsmith right now and working out how to hook it up to Analysis Services:
Adventure Works the musical, anyone?