08 6210 8500
Excel or Power BI - where to start? So... Excel has Power Query and Power Pivot built in. Power BI uses the same technology. So which one should you learn first? I say which should you learn "first" because if you learn one it's a relatively small step to learn the other 2 Questions: 1. What's your aim? [...]
3 Easy Steps to Manage your Data Fields Want to control which data fields to keep in Power Query when removing other columns? When using the ‘Remove Other Columns’ transformation in Power Query (‘Get & Transform’ in Excel 2016+) the query editor hard-codes the remaining column names in the Advanced Editor. This is fine if your [...]
Get & Transform to the rescue! Is it a bird? Is it a plane? No it's way better than that, it's Excel! Get & Transform, also known as Power Query, gives Excel users super powers. Here's the latest scenario where it has helped out and also is an opportunity for me to demonstrate a method [...]
Power Query Data Cleansing - solving all sorts of Excel issues by Wyn Hopkins Some may see Power Query simply as a brilliant way of connecting to multiple data sources and loading that data into a Microsoft Power BI development environment (Excel Power Pivot or Power BI desktop). Having spent 25 [...]
Introducing Power Pivot In this video I introduce Power Pivot and how you can use it to join multiple tables of data together and display your data in a Fiscal Year format. In part 1 I demonstrated how Power Query can quickly consolidate all of the files in a folder and bring that data [...]
Power Query (Get & Transform) - Part 2 In part 1 I demonstrated how Power Query can quickly consolidate all of the files in a folder and bring that data into Excel. In this 6 minute video I follow on from that introduction and add an extra transformation step to get the dates I need. Once [...]
Power Query (Get & Transform) Part 1 Power Query is amazing at linking to data sources and cleansing / transforming that data as it's loaded into Excel (or Power BI Desktop). Watch this 4 minute video and see how you can consolidate all of the files from a folder instantly using Power Query. Build the transformation steps [...]
Check out our YouTube channel with weekly videos dedicated to Excel, Power Query and Power BI Power Query is the best thing to happen to Excel since Tables were introduced in Excel 2007 **Updated May 2018** When developing Power Query solutions for others to use, or when needing parameters that can be changed [...]
Power Query Trap: Formula Autofill If you output the results of Power Query to a table in Excel then it’s often really useful to be able to add an extra calculated column or two onto the end of this output table. I used to do this all the time when using Microsoft Query. However, now [...]
How to combine multiple tables with Excel Power Query If you have multiple tables of data in a file and you want to view a single report based on these tables then it can be time consuming and risky to manually copy and paste them into a single table before creating pivot [...]
Pay my invoice
