Using PowerBI to help you look at different scenarios
Recently I was working as part of an instructor team delivering PowerBI. One of the topic covered was parameters. Basically what this allows you to do is create a range of values (or other options) so you can assess the effects of various changes. This tutorial would be aimed at people doing this for the […]
How to easily combine files in a folder using Power Query (PowerBI)
In this post I want to show you how you can use Power Query to automatically combine the contents of multiple files. A common requirement is that the same file is produced every month but year to date figures are needed from it. In Power Query you can put all these files into a single […]
How to create a data model in PowerBI with multiple tables from a single Excel file
One of the issues I have noticed coming up with learners after PowerBI training is that when they go back to their desks, they find that what they have to deal with is a SINGLE file so one of the first jobs they have to do is create what is called a star schema (tables […]