Level: Beginners No software company can build every single feature that everyone wants to see all at once. Ultimately there has to be some prioritisation, and along with the prioritisation comes compromises and ultimately disappointments for some (many?). Back in July 2015, Microsoft started a chain of actions and announcements […]
Before showing you how to do cross join in power query, let me tell you a story. I had a situation this week where I need to create a budget table in Power Pivot. I had a choice of either loading a weekly budget as a single record per store […]
Level: Beginners When you write a Power Query workbook in Excel 2013, you are given 4 choices of what to do with results. One of the choices is to load the resulting query directly to the Power Pivot data model. This choice does not exist in Excel 2010. It is […]
As regular readers of my blog would know, I attended the PASS Business Analyst Conference in Santa Clara California this year (April 2015). Here is the link for next year if you are interested. While I was there, I had the pleasure of presenting on one of my favourite topics […]
I was helping a participant at http://powerpivotforum.com.au with a problem. Long story short, she needed to return a table to Excel from a data model – not a Pivot Table. This concept can be a bit strange at first – let me explain. Tables – Not Pivot Tables A Pivot […]
Level: Beginners I helped a couple of people this week on the topic of creating multiple relationships between two tables. There is not a lot of information on this topic on the web so I thought I would write about it here. Power Pivot is not the Same a Relational […]
I am really looking forward with anticipation and excitement about the future of http://PowerBI.com. Microsoft has just released the August 2015 update to Power BI Desktop just 1 month after PowerBI.com becoming generally available (GA). Power BI Desktop used to be called Power BI Designer, and it is the tool […]
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 […]
I was working with a client last week and the unthinkable happened. The client made a simple editing mistake inside the Measure editing dialogue box and it corrupted the Power Pivot workbook. We could still edit the corrupt workbook, but the Pivot Tables stopped working. Oh No!! Now what? He […]
level: Intermediate I have written a couple of posts here and here about the problems and dangers of using Power Query with Power Pivot. Well I am very pleased to say that I now fully understand the problem, how it is caused and how it can be avoided. Edit: Nov […]
Seriously, this has been the best 3 days of my life. Well except for my wedding day of course (sorry honey). There were many great sessions at the PASS BA Conference – about half of them I attended I would classify as “invaluable”. And there were many other sessions I […]
It is late on day 1 of the PASS BA Conference – quite late actually. I really enjoyed the first day and wanted to share some of the highlights with those that couldn’t make it. Keynote Speaker: Carlo Ratti. This man is living the dream! Carlo is an MIT Professor […]
Excel is a bit like a drug for me – the more I use Excel, the more I need to use Excel. I work on a lot of Power Pivot workbooks these days and sometimes these workbooks need to run a refresh or recalc that can take a bit of […]
I was recently asked by an Industry Excel expert what made Excel such a compelling product for Business Intelligence, Reporting and Analysis. As many people know, I have worked in IT as well as commercial business roles over the years, so I have seen ‘both sides’ of the story and […]
I have come across this problem a few times recently. There was no immediately obvious solution that worked at first. I knew what I wanted to do but I couldn’t get it to work – but now I have a solution and I want to share it for the benefit […]
Microsoft has just released the March ‘15 update to Power Query. On the official blog, MS called out 3 things: Performance improvements Microsoft Dynamics CRM Online connector New transformations Performance improvements? You have my attention. I have found that Power Query (and Power Pivot for that matter) are both slow […]
Excelerator BI | © 2023 | Sitemap