In this series Simon Hurst examines some of the Power BI techniques in more depth in order to understand what they are capable of, and how best to use them, not only when working with external data, but also for changing the way that we work within Excel workbooks.