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 […]
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 […]
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 […]
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 […]
A couple of weeks ago Microsoft held a full day online session called Faster Data Insights With Power BI. There were 8 sessions of about 50 mins each that covered various aspects of the new Power BI suite. The sessions have now been converted to YouTube videos and are available […]
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