Tag Archives: Power Query

Bob The (Proto) Builder

I have been building a prototype application over the past week, using Power Query to take the principal data management sheet, and create a form of normalised data that I could load into a SQL Server database which I would then … Continue reading

Posted in Power Query | Tagged , , , , | Leave a comment

Excel is for Parameters

In my last two posts, I have shown how to build a datamodel in Excel from an Excel workbook that had two levels of headings, and then I showed how to improve the code  using functions. In the second I … Continue reading

Posted in Power Query | Tagged , , , , | 6 Comments

A Case For Functions

One of the things I don’t like about Power Query is that the list of instructions gets quite long, when a transformation is more than just a simple replace or add columns, and becomes less easily maintained. I am a … Continue reading

Posted in Power Query | Tagged , , | 3 Comments

Unpivot Nested Headings With Power Query

If you are a data analyst, you undoubtedly know and love Excel, and undoubtedly know and love pivot tables, they must be a core part of your analysis toolbox. No doubt at some time you will have faced the need … Continue reading

Posted in Power BI, Power Query | Tagged , , , , , , | 9 Comments