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 […]
Back in early May I realised that there was not much in the way of a dedicated forum for PowerPivot users, especially for the general user. There are some specialised forums out there for Microsoft Developers but not much for the average user. As a result I went ahead and set up […]
This is a very interesting question “How much does a BI Project cost?”, and one that many people want the answer to. The standard response from IT is “how long is a piece of string?”, and that is a valid response in many senses. ie how would you know how […]
Query Plan Analysis: The 5 Culprits that Cause 95% of Your Performance Headaches I am fairly new to SQL Server, and I am by no means an expert. I learnt my database ‘skills’ using MS Access. In a recent engagement with a client, I had a need for a tool […]
This is a continuation of my series on “best of” from TechEd 2014. This session by Kasper de Jonge makes my best of list. It is quite technical in places and digs in deep. I particularly like when he talks about “evaluation context”. Erik explains that there are 2 types […]
As I spend more and more of my time working full time with PowerPivot and associated Excel products, I have been looking for suitable forums that are focused around PowerPivot. I have not found anything out there that I really like. So I spent some time over the weekend setting […]
I have been doing some work with a customer over the last couple of weeks preparing to produce a new data model. Part of the process is to get an extract of invoices (header detail and line item detail) from the mainframe so that I can easily access all the […]
Yesterday I read this post called “Why Excel is costing you millions” by Gayle Ryan. I have never seen a more misleading and ill informed post about Excel, and I was motivated to provide a response to this article here. Ryan starts out by talking about static reporting, and how […]