-
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
-
As you might have read in the previous post, May is a busy month for all the editions of the SSAS Tabular Workshop. We’ll start with an online edition next week in a time slot that should be good for… Read more
-
We are going very close to the release of SQL Server 2012 and after using Analysis Services 2012 for almost one year in a relatively small number of scenarios, I’m really curios to see the questions and the issues that… Read more
-
In DAX you don’t have the LIKE operator and you have to use SEARCH instead. However, performance are not very good and it is better to use LEFT and RIGHT if you just need to compare the initial (or ending)… Read more
-
You should have already read that DAX is simpler than MDX. It’s true, and sometime you have to pay a price for simplicity. I am used to say that DAX is somewhere between SQL and MDX. In fact, SQL requires… Read more
-
I just published the article Converting MDX to DAX – First Steps on the renewed SQLBI web site about converting MDX to DAX. The reason is that with BISM Tabular in Analysis Services 2012 you will be able to write… 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
-
Javier Guillén wrote several blog post about how to implement certain common calculations in PowerPivot. It is interesting to read his posts not only because of the solutions he propose, but also because he uses several techniques that can be… Read more
-
link In many workshops and sessions about PowerPivot the most frequently asked question has always been: how can I automate the PowerPivot Data Refresh in Excel? I talked about that a few weeks ago. The sad answer is that this… 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