Level: Beginners I have blogged before about how to combine multiple files in a folder using Power Query. The way I have always done it is to use a Function, and this is not hard to do if you follow the instructions I provided on my last blog on this topic […]
Level: Beginners One of the topics in my book “Supercharge Power BI: Power BI is Better When you Learn to Write DAX” talks about the optimal shape of your data tables. It is such an important topic that I have decided to share some modified extracts from the book here. When […]
Level: Beginners I have been working with a client here in Sydney were we are producing some Human Resource (HR) reporting tools to analyse what is happening across the business. HR data is quite often very sensitive because it can contain personal information as well as salary information. A lot […]
Level: Beginners I was working with a client recently and was asked a question… “How do I remove duplicate connections in Power Pivot”? I know this is an issue and I specifically advise people to be careful in my training courses and also in my book. But of course once […]
Level: Beginners Edit: March 2021 I love books. Even in this world of the Internet I still like to buy a good book of structured “curated content” that takes the reader on a journey. There are quite a few books out there about the various Microsoft BI products. I plan […]
Level: Beginners It can be reasonably difficult to find the exact download you need for the various Power Products in the Microsoft BI stack. Some of these products (particularly Power Pivot) have a number of versions. This article is provided to help you get the correct download first time. You […]
Excelerator BI | © 2023 | Sitemap