Alberto Ferrari : PowerPivot

Parent/Child Hierarchies in Tabular with Denali

AlbertoFerrari — Mon, 18 Jul 2011 22:15:21 GMT

Some time ago, I wrote a post about how to handle Parent/Child hierarchies in PowerPivot 1.0. It was pretty intricate, because P/C are not handled natively in PowerPivot. Now, with the advent of Denali, Microsoft gave us all the functions needed to handle...(read more)

PowerPivot, basket analysis and the hidden many to many

AlbertoFerrari — Thu, 19 May 2011 20:44:00 GMT

Surfing on the web, here , I came into this intriguing question: How do we ask something like "Show me how many customers have an iPad but don't have a book?" We are speaking about a sales analysis where the canonical entities are Customers, Products...(read more)

Thinking in DAX: Counting Products in the Current Status with PowerPivot

AlbertoFerrari — Tue, 08 Mar 2011 07:00:00 GMT

One of my readers came to me with an interesting formula to compute in PowerPivot. Even if I don’t normally post about very specific scenarios, I think this time it is interesting to write a blog post since the formula can be easily created, if you think...(read more)

PowerPivot, Parent/Child and Unary Operators

AlbertoFerrari — Tue, 01 Mar 2011 07:00:00 GMT

Following my last post about parent/child hierarchies in PowerPivot, I worked a bit more to implement a very useful feature of Parent/Child hierarchies in SSAS which is obviously missing in PowerPivot, i.e. unary operators. A unary operator is simply...(read more)

PowerPivot and Parent/Child hierarchies

AlbertoFerrari — Tue, 15 Feb 2011 07:00:00 GMT

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)

PowerPivot and the Slowly Changing Dimensions

AlbertoFerrari — Wed, 09 Feb 2011 07:00:00 GMT

Slowly changing dimensions are very common in the data warehouses and, basically, they store many versions of the same entity whenever a change happens in the columns for which history needs to be maintained. For example, the AdventureWorks data warehouse...(read more)

PowerPivot: Putting two stocks on the same PivotChart

AlbertoFerrari — Wed, 02 Feb 2011 08:03:00 GMT

In a previous post , I have used a stock exchange scenario to speak about how to compute moving averages in a complex scenario. Playing with the same scenario, I felt the need to compare two stocks on the same chart, choosing the stock names with a slicer....(read more)

PowerPivot, Stocks Exchange and the Moving Average

AlbertoFerrari — Wed, 26 Jan 2011 07:00:00 GMT

In this post I want to analyze a data model that perform some basic computations over stocks and uses one of the most commonly needed formula there (and in many other business scenarios): a moving average over a specified period in time. Moving averages...(read more)

PowerPivot Workshop: new announcement and early bird expiring soon #ppws #PowerPivot

AlbertoFerrari — Fri, 14 Jan 2011 08:30:57 GMT

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)

End of Early Bird for the London PowerPivot Workshop is approaching

AlbertoFerrari — Fri, 14 Jan 2011 07:00:00 GMT

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)