Creating burndown charts for Project using Power Pivot and Power Query

When you are managing a project and tracking the work done versus the work planned or the remaining time left, it is common to use a burndown chart In this article, we show you how to create a report of all tasks for the last 90 days, using Excel 2013 and oData streams. This example will also introduce you to some key Power Query and Power Pivot functions.