April has been a month full of conferences and May will be full of workshops! I’m also working on other things and I hope to be able to publish more technical content in my blog very soon! In the meantime, we just announced an edition of the PowerPivot  Read more

As I blogged last month , the spring is a season full of events and this is a reason why I’m not writing technical articles in these weeks. But I promise I’ll write again in a few weeks, there are a lot of interesting ideas that need to be written down.  Read more

As you might know, I wrote three books about LINQ with Paolo Pialorsi. He’s an expert in SharePoint development and after one year of tough writing it is finally available its Microsoft SharePoint 2010 Developer Reference book. If you want to write code  Read more

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

Several months ago I wrote about the issue importing measures from an Analysis Services cube in PowerPivot. The short story is that, when you define the MDX query, all columns are imported as Text. Of course, this is not a good thing for the numeric measures.  Read more

Chris Webb posted a wonderful solution to the Last “ever” non empty calculation in MDX . I never thought to this solution and it is really a nice approach. I think that DAX might be faster in this scenario – a similar calculation has been shown in this  Read more

A common feature request for PerformancePoint is importing a briefing book from ProClarity. As far as I know, this is not available. Today (thanks to a tweet from @denglishbi ) I discovered a product, Pyramid Analytics bioXL , which has a specific feature  Read more

Most of the readers of this blog probably have a good knowledge about MDX. But if you are new to MDX or want to improve a basic knowledge, and you’re in London or you are looking for a very good reason to visit the city, then you cannot miss the public  Read more

Last week Alberto published an interesting post about Counting Products in the Current Status with PowerPivot . Starting from a question raised from a reader, Alberto described how to solve a common issue (let me know the “current status” of each item  Read more

The next Monday, March 21st, I will join a special event organized by the Danish SQL Server User Group , Excelbi.dk and the Swedish SQL Server User Group . The meeting will start at 18:00 at the Radisson Royal Blu in Copenhagen, and this is the topic  Read more