Browse by Tags

• BISM
• CTE
• DAX
• Dimensional Model
• Parent/Child
• Tabular

• Parent/Child Hierarchies in Tabular with Denali

  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... Posted Tuesday, July 19, 2011 1:15 AM by AlbertoFerrari | 21 Comments Filed under: PowerPivot

• PowerPivot, basket analysis and the hidden many to many

  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... Posted Thursday, May 19, 2011 11:44 PM by AlbertoFerrari | 4 Comments Filed under: PowerPivot, BISM, Tabular, DAX

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

  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... Posted Tuesday, March 08, 2011 9:00 AM by AlbertoFerrari | 3 Comments Filed under: PowerPivot

• PowerPivot, Parent/Child and Unary Operators

  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... Posted Tuesday, March 01, 2011 9:00 AM by AlbertoFerrari | 3 Comments Filed under: PowerPivot, Parent/Child

• PowerPivot and Parent/Child hierarchies

  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... Posted Tuesday, February 15, 2011 9:00 AM by AlbertoFerrari | 22 Comments Filed under: CTE, Dimensional Model, PowerPivot, Parent/Child

• PowerPivot and the Slowly Changing Dimensions

  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... Posted Wednesday, February 09, 2011 9:00 AM by AlbertoFerrari | 3 Comments Filed under: PowerPivot

• PowerPivot: Putting two stocks on the same PivotChart

  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... Posted Wednesday, February 02, 2011 10:03 AM by AlbertoFerrari | 8 Comments Filed under: PowerPivot

• PowerPivot, Stocks Exchange and the Moving Average

  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... Posted Wednesday, January 26, 2011 9:00 AM by AlbertoFerrari | 9 Comments Filed under: PowerPivot

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

  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... Posted Friday, January 14, 2011 10:30 AM by AlbertoFerrari | 0 Comments Filed under: PowerPivot

• End of Early Bird for the London PowerPivot Workshop is approaching

  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... Posted Friday, January 14, 2011 9:00 AM by AlbertoFerrari | 0 Comments Filed under: PowerPivot