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

A very frequent question, when performing business analysis, is to count the number of working days in a certain period of time. Creating a data model with PowerPivot that gracefully handles working days is pretty easy, nevertheless it is worth a post.  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

Jeffrey Wang wrote a new post about DAX Time Intelligence functions. This is an “under the cover” description that explains the rationale behind these functions, which need to be used following particular guidelines (described at the beginning of the  Read more

As always, I am a bit later than Marco in producing news. Nevertheless, I am very excited to tell you  the new date for the Frankfurt workshop on PowerPivot: February 21-22, 2011 . Save the date and find all the relevant information on www.powerpivotworkshop.com  Read more

Hurry up! On January, 17 the early bird rate for the London PowerPivot Workshop will finish. You have a few days to save £150 from the regular price. Don’t miss the opportunity to attend the best PowerPivot workshop in Europe saving some money too.  Read more

One week ago I described the PowerPivot Workshop Roadshow that we are planning in several European countries. The news today is that the Workshop will be in Frankfurt (Germany) on February 21-22, 2011 ! The registrations are open on www.powerpivotworkshop.com  Read more

Alberto Ferrari wrote an interesting post about a “different approach” in creating a ranking measure with PowerPivot . If you know DAX or you read our book , you will find that a DAX expression can solve the issue. However, such a formula is more complex  Read more

I have a friend (Sandro Rizzetto) that is also a photographer. A good one, but his job is in IT. For these reasons, after reading some posts of mines, he built a PivotViewer page to navigate its photo database. You can drilldown by category, date, lens,  Read more