Alberto Ferrari published an interesting blog post regarding how to write particular calculations over a parent-child hierarchy in PowerPivot Denali (and in BISM Tabular, of course). One case is the Sum of Leaves (summing only the leaves of a parent-child…  Read more

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…  Read more

In PowerPivot you can import data from several sources and it is often the case that you import a DateTime column from a database. From an analytical point of view, you usually make analysis over dates (day/month/year/quarter/week) and over time…  Read more

I just returned from my second SQLBits, this time in Liverpool, and I have to say it is a really great conference. Everything can be improved, but I have to say that it’s hard to find a conference where you…  Read more

Yesterday I and Alberto delivered the PreCon day about BISM Tabular in Analysis Services 2012. We received very good feedback and now I am looking forward to meet people that read our blogs and our books! Ping me on Twitter…  Read more

This is the second day at TechEd North America 2012 and yesterday I had many conversations about PowerPivot and SSAS Tabular. In the evening the book signing at O’Reilley booth has been a big success! I’m writing this post from…  Read more

I will deliver two sessions at the next PASS Summit 2012: one is title Inside DAX Query Plans and the other is Near Real-Time Analytics with xVelocity (without DirectQuery). These will be two sessions that require a lot of preparation…  Read more

Short update about community events in Europe where I will speak. On October 11 I will present DAX in Action in Köln – all details in the PASS local chapter here: http://www.sqlpass.de/Regionen/Deutschland/ I will be speaking at a community event…  Read more

Spring is a conferences’ season and the upcoming one is no exception. I will be speaking at PASS Business Analytics Conference 2013, which will be the first event this year, so I’d like to spend a few words about my…  Read more

I received this request in many courses, messages and also forum discussions: having an Analysis Services Tabular model, it would be nice being able to extract a correspondent PowerPivot data model. In order of priority, here are the specific feature…  Read more