On January 18th, 2012 at 12pm Eastern Time (which is 5pm GM) Alberto Ferrari will deliver a free online session for the PASS DW/BI Virtual Chapter. This is the official description of the session. Many-to-Many Relationships in DAX The introduction of many to many dimension relationships in SSAS (since 2005) opened new scenarios that can be ...

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 ...

These are the last days to register for the PowerPivot Workshop in Zurich on April 4-5, 2011. If you are willing to attend, hurry up!Moreover, on Thursday evening there will be also a Swiss PASS Chapter meeting in Zurich and Alberto Ferrari will present the session we already delivered in Copenhagen two weeks ago. This is 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 ...