-
Does PowerPivot handle Parent/Child hierarchies? The common answer is “no”, since it does not handle them natively. During last PowerPivot course in London, I have been asked the same question once more and had an interesting discussion about this severe… Read more
-
Kasper de Jonge wrote a blog post last year introducing an interesting new feature in Excel 2013: you can write a DAX query that extracts data from the PowerPivot model and returns a table in Excel. Such a table 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… Read more
-
I just read the Dave Wickert post about his sessions about PowerPivot from Microsoft at TechEd 2010 in New Orleans (June 7-10, 2010) and there are at least two things I’d like to add. First of all, there is also… Read more
-
A few days ago a post about VSTO-based PowerPivot Workbook in the PowerPivot Team Blog shown a workaround for the lack of PowerPivot API in Excel. In reality, I don’t like this workaround at all, because it relies on displaying… Read more
-
UPDATE Aug 16, 2013: Excel 2013 stand-alone now includes Power Pivot and Power View! Rob Collie Ken Puls (thanks Bob!) wrote a very interesting post about the PowerPivot for Excel 2013 licensing. Short recap: PowerPivot for Excel 2013 is only… Read more
-
The Microsoft has launched the new Office 2013, we are proud to announce the availability of the new PowerPivot Workshop for Excel 2013! We have a fresh new website that offers all the training options: online and classroom courses. The… Read more
-
The query designer in PowerPivot has a few limitations that require the manual modification of the MDX query to get data that are often needed to create a PowerPivot model that compares data from cube with data from other sources… Read more
-
A few days ago Kasper anticipated that I and Alberto will teach a 2-day PowerPivot course based on our PowerPivot book. The location will be next the Amsterdam airport, at Schiphol, Netherlands, and the dates are December 1st and 2nd,… 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… Read more