One month ago I wrote about my sessions at PASS Business Analytics Conference 2013, in Chicago, IL on April 10-12, 2013. If you still have not registered, you can save $200 by using the code BAC228BL and you should hurry up, because there is another discount if you register within March 15, 2013. If you are too lazy to click on the previous post, ...

Recently I had to write a DAX formula containing a LASTDATE within the logical condition of a FILTER: I found that its behavior was not the one I expected and I further investigated. At the end, I wrote my findings in this article on SQLBI, which can be applied to any Time Intelligence function with a <dates> argument. The key ...

Last week the final session evaluations from PASS Summit 2011 have been communicated to speakers and best scores have been made public. My session was not particularly good: it had very good feedback (overall average 4.32) and some average one, mostly because the title (Vertipaq vs OLAP: Change Your Data Modeling Approach) suggested to someone a ...

I already announced a few weeks ago that I and Alberto will speak at SQLBits in Liverpool. We will also speak at SQLPASS Summit in Seattle and at SQLRally Nordic. A few details about my sessions: SQLPASS Summit (Seattle, WA – October 11-14, 2011): My session will be Vertipaq vs OLAP: Change Your Data Modeling Approach, which will replicate the ...

Microsoft recently announced a new roadmap for its BI architecture. The next version of SQL Server, codenamed “Denali”, is going to introduce a new semantic model named BISM (Business Intelligence Semantic Model). Analysis Services will host it and it will be queryable through MDX and DAX. DAX has been introduced in PowerPivot as an expression ...

This week I was at PASS just like many other folks from here. Good times as always, although less partying than in the past. Since I am still in recovery and relying on Percoset to get me through the day, I was wiped every evening. Here are a few thoughts and observations:- I salute PASS marketing for being able to keep the number of registrations ...