THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus

Stock Analysis and Moving Average with PowerPivot

One week ago Alberto Ferrari wrote a post about how to do working days calculation in PowerPivot. You might think this is necessary only for accounting department or something like that… but in reality the same techniques are really useful to implement calculations that might be useful when you want to implement some stock analysis using PowerPivot and Excel!

As you might know, in PowerPivot it is important having a Dates table containing all the days, without exceptions. But when you manage stock data, you don’t have values for holidays and probably you have all the stock data into a single table, for all the stocks. If you want to calculate the moving average for each ticker, you need to get always the same number of days with data, without counting days without stock prices.

Yesterday Alberto wrote a new post that describes how to calculate the moving average with PowerPivot, which is a useful technique whenever you want to calculate time-based indicators used to generate charts like that:


If you want to know more about PowerPivot, don’t miss the opportunity to follow one of the workshops I and Alberto are bringing all over Europe in the next few months.

You can find more info on Hope to see you there!

Published Thursday, January 27, 2011 7:09 PM by Marco Russo (SQLBI)
Filed under: , ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Claire said:

Those workshops look amazing! Are you planning to do one after Frankfurt?

January 31, 2011 1:01 PM

Marco Russo (SQLBI) said:

Yes, we are planning other dates in March, April and May in other European countries.  We'll announce some date very soon.

We are looking for some training partner in US to make a similar roadshow there - but it's still in the works.


January 31, 2011 4:00 PM

Leave a Comment


About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement