Alberto Ferrari wrote a very interesting white paper about DAX query plans. We published it on a page where we’ll gather articles and tools about DAX query plans: http://www.sqlbi.com/topics/query-plans/ I reviewed the paper and this is the result of  Read more

The sessions recorded at TechEd 2013 are online. I and Alberto Ferrari delivered the same sessions and the recording are available for both TechEd North America and TechEd Europe. It’s nice for me being able to compare two deliveries of the same session.  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

If you think PowerPivot and Tabular are good tools but sometime the design tools are not fast/complete/flexible enough, please consider voting this suggestion on Connect to request a textual representation Tabular or PowerPivot Data Models . This is the  Read more

I received the communication from the PASS Program Committee that none of my proposals have been accepted at PASS Summit 2013 . Probably this year there was too many proposals and I made a mistake not using all the possible proposals available per speaker.  Read more

I and Alberto Ferrari will moderate the following Birds of a Feather session at TechEd North America 2013 : CODE: BOF-ITP21 TITLE: How Far Can You Push Tabular? SPEAKER: A. Ferrari; M. Russo TIMESLOT: June 5, 2013 at 1:30 pm ROOM: 263 Abstract: Tabular  Read more

In June I and Alberto will deliver a pre-conference seminar at both TechEd North America (New Orleans, LA) and TechEd Europe (Madrid, Spain). This day is a very good quickstart for those of you that still didn’t complete one of our books , or those of  Read more

I published an article describing how to implement the grouping of sales transactions by age of customer at the moment of the transaction by using PowerPivot or Analysis Services. The same pattern can be used also for any kind of banding operation, this  Read more

I’m so happy that DAX Studio finally supports Excel 2013! As Darren Gosbell described in his blog , this release has a few internal changes that will better support future enhancements. I will port the code to capture the query plan for a query in this  Read more

Microsoft released the Workbook Size Optimizer for Excel , the first version of an Excel add-in for Excel 2013 that inspects the data model and suggest possible optimizations. Fundamentally, it tries to apply the best practices descripted in a white paper  Read more