January 2011 - Posts

• 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

• Self-Service BI: BI to Excel or Excel to BI?

  I spend most of my time developing complex BI solutions and, doing that, I always talk with DBA, developers, CEO, data analysts and the many kind of people that work around a BI solution. Nevertheless, in these last months, publishing posts about PowerPivot Read More... Posted Monday, January 24, 2011 12:51 PM by AlbertoFerrari | 5 Comments

• Working days computation in PowerPivot

  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... Posted Wednesday, January 19, 2011 9:00 AM by AlbertoFerrari | 18 Comments

• 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

• Dynamic Ranking with Excel and PowerPivot

  Ranking is useful and, in our book , I and Marco provide a lot of information about how to perform ranking with PowerPivot. Nevertheless, there is an interesting scenario where ranking can be performed without complex DAX formulas, but with just some Read More... Posted Tuesday, January 11, 2011 9:00 AM by AlbertoFerrari | 6 Comments

• PowerPivot Workshop in London #ppws

  As you might have read in Marco’s post , the PowerPivot Workshop I and Marco Russo have prepared is now starting its European tour. We will be in London on February 7,8 2011 and then touch most of the European countries during the next few months. We Read More... Posted Friday, January 07, 2011 12:00 PM by AlbertoFerrari | 0 Comments