New videos and slides on SQL Server 2008 R2 and PowerPivot

June 22, 2010

Two big resources on SQL Server 2008 R2 and PowerPivot just came out lately. The first is the videos and slides from BI track in TechEd 2010 in New Orleans. You can download all the slides and video recordings on the sessions that you want (and you can use the "list" view for quick and easy access). This one is free for everyone.Another resource that is free, but requires registration, is 24 Hours of PASS. Registration to PASS is free and very recommended as it gives you access to a lot more information and resources. 24 hours of PASS...

Donald Farmer on SQL Server 2008 R2, SharePoint and PowerPivot

June 14, 2010

If you're following this blog, then you know that Sunday, May 30th 2010, I went to the SQL & BI Data Platform convention held in Tel Aviv. Specifically, I went to Mr. Donald Farmer's seminar on Data Integration in Large Organizations. I did live blogging from most of the event, though actually, I didn't manage to blog about the last part of it, because I was preparing for something that was pretty big for me.... I'll start over. When I first heard Mr. Farmer was coming to lecture in Israel, I was like "What? Really? Like, Donald Farmer? Like THE...

Data mining in Excel 2007

June 1, 2010

Mr. Donald Farmer gave a lecture yesterday, May 31st 2010, at the Israeli BI User Group. This is what I summed up from the session. Predictive AnalyticsA good predictive analytics project would have:Actionable - you get useful information from itInnovative - gives something new, new insight from the modelTrustworthy - the model makes senseSeamless - part of your everyday operations, so that it will get used more easily by the users "All models are wrong, but some are useful" George BoxNo model is perfect, you can't predict everything, but even then the model is useful. Don't expect to build a perfect...