If you are in Portugal or you are looking for a very good reason to visit Lisbon, don’t miss the sessions about PowerPivot that Alberto Ferrari will present at the Microsoft BI Conference in Lisbon on March 25, 2011. The conference is free and Alberto  Read more

The PowerPivot Workshop roadshow will continue in Europe in March and April. Registrations are now open for the following new dates in Denmark, Ireland and Switzerland: Copenhagen : 21-22, March 2011 at the Radisson Blu Royal Hotel Dublin : 28-29, March  Read more

You might already know that I and Alberto Ferrari will present the SQLBI Methodology in a Training Day at SQLBits 8 . What you might need to know is that registrations are very good and there are not so many seats available. I don’t know whether it will  Read more

Flash news about PowerPivot Workshop : this is the last week to register for the Frankfurt date (21-22 February 2011). We are going to announce the next dates in Europe in March/April 2011: Copenhagen (Denmark), Dublin (Ireland) and Zurich (Switzerland).  Read more

During the PowerPivot Workshop in London we received many interesting questions and Alberto had the inspiration to write this nice post about Slowly Changing Dimensions handling in PowerPivot. It is interesting the consideration about SCD Type I attributes  Read more

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