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 […]
Edit 16 May 2015: I now know the exact cause and cure for this problem. See this post here This backup tip is still useful though. This is a follow up to this post where I talked about Power Query and warned to take frequent backups when editing your Power […]
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 […]
I wrote a blog post on PowerPivotPro.com last week on how to create a standard Power Pivot calendar using Power Query – from scratch. I was doing some research this morning on how I could extend this concept to create a 4/4/5 Calendar (which is often used in the Retail […]
As most subscribers of my blog would already know, I am a professional trainer of Power Pivot here in Australia. I do a lot of work for Corporations at their own premises with their own PC equipment. Not every company has made the move to Excel 2013, and in fact […]
Edit 16 May 2015: I now know the exact cause and cure for this problem. See this post here PhilC at PowerPivotForum.com.au asked me for advice on the best way to use Power Query with Power Pivot. If you have come to this post via Google, it is probably because […]
In this post I cover everything you need to know about the Power Pivot 2013 Update (December 2014), how to get, and what can go wrong. As you may have heard, Microsoft has released a number of patches that improve the stability of Power Pivot, Power View and Power Map […]
I recently created a Book Shop on my WordPress website using WooCommerce. The next logical thing I wanted to do was to get an extract of all my orders/invoices that have been sold through the shop into Excel. I couldn’t find a way to do this in the WordPress UI […]
I have been waiting for this book Power Query for Power BI and Excel by Chris Webb for some time and I am pleased to advise it is a great book for a broad range of people with anything from zero to medium skills in Power Query. I fall into the […]
In this session, Matt Masson and Tess Palmer do a great job of showing everyone the depth and power of the Power Query M language that is the backbone of Power Query – it makes my list. Clearly they didn’t expect too many people in the audience to be able […]
Microsoft has announced a new version of Power Query on the MSDN blog this week. There is a full decscription of the new features available at the following link, however I have provided a summary of the key features I am looking forward to. http://blogs.msdn.com/b/powerbi/archive/2014/05/06/new-updates-for-power-query.aspx Features and Benefits New Feature […]
I really love PowerPivot and Power Query. I have been doing Rob Collie’s on line training course on using PowerPivot. When I got to the section on Time Intelligence, it occurred to me that Power Query could be used to create the date table that you need. I did a […]
There is a good Microsoft site for the Power Query M formula language reference. There is a lot of really useful information about the key functions of the language on that page, and I recommend it for anyone that is looking to do more with Advanced Power Query functions. If you […]
I had read an interesting request on the Whirlpool forum over the weekend. Whirlpool user Alicia2 wanted to extract Word document metadata into a Spreadsheet. That seemed like an interesting problem and something I could use some time. So I decided to help her out. I built this Spreadsheet that […]
Excelerator BI | © 2023 | Sitemap