In the comments of a recent post from Alberto Ferrari there was an interesting note about different performance related to the order of conditions in a FILTER call. I investigated about that and Jeffrey Wang has been so nice to give me some info about  Read more

One new nice feature of Excel 2010 is the Slicer. Usually, slicers are used to filter data in a PivotTable. But they might be also useful to parameterize an algorithm or a chart! We discussed this technique in our book , but Alberto Ferrari wrote a post  Read more

One week ago Alberto Ferrari wrote a post about how to do working days calculation in PowerPivot . You might think this is necessary only for accounting department or something like that… but in reality the same techniques are really useful to implement  Read more

Short post about PowerPivot Workshop : there are still a few days to register for the London date (7-8 February 2011). If you are interested in the Frankfurt date (21-22 February 2011), the next week will be the last one to get the discounted Early Bird  Read more

Recently I have seen a long demo of BonaVista Dimensions . It is a product that is able to create reports and, most important dashboards. You can use it also without SQL Server and Analysis Services, just by importing data in a local cube file that you  Read more

As you probably read so often in this blog, we are arranging a roadshow of out PowerPivot Workshop . If you are a trainer or works in a training center to select products to offer to your customer, you might be interested in delivering the same course  Read more

Whenever you have to calculate the distance between two dates, you can simply subtract two dates and DAX in PowerPivot will give you the answer. However, in case you want to calculate the difference in terms of working days you have to instruct your data  Read more

We just added a page in the PowerPivot Workshop web site containing an introduction to PowerPivot. There are already several web sites with a general description of PowerPivot and we adapted parts of the first chapter of the book PowerPivot for Excel  Read more

HP and Microsoft announced an appliance for PowerPivot . This is very interesting and might solve the issue of PowerPivot adoption in certain companies (where the problem is the support required for installing and maintaining SharePoint 2010). You can  Read more

I lost the count of how many SQLBits I lost for one reason or another, but now it’s the time! I and Alberto will present a full day training on April 7 at SQLBits 8 in Brighton. Our seminar will be dedicated to the SQLBI Methodology and is based on the  Read more