February 2011 - Posts

• Microsoft BI Conference 2011 in Lisbon

  Anyone interested in BI from Portugal or Spain should not miss the Microsoft BI Conference 2011 in Lisbon : one full day ( March, 25, 2011 ) with three tracks on Business Intelligence: Decision Makers BI pros Intro to BI. I am going to present two sessions Read More... Posted Wednesday, February 23, 2011 11:36 PM by AlbertoFerrari | 4 Comments

• 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 course: Copenhagen, Dublin and Zurich new dates available for booking

  Wow, this time I have been able to make an announcement before Marco Russo! The PowerPivot course we are bringing in tour all over Europe has three new dates available for booking: Copenhagen : 21-22, March 2011 at the Radisson Blu Royal Hotel. Dublin Read More... Posted Monday, February 14, 2011 4:01 PM by AlbertoFerrari | 0 Comments

• 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