Excel - Excelerator BI

Excel

Excel Keeps Crashing? Check your VBA code

I use Excel 2013 64 bit and sometimes Excel just keeps crashing on me.  It used to happen to me a lot more in the past, but after I discovered what was causing the repeat …

Excel Keeps Crashing? Check your VBA code Read More

Power Pivot Calendar Tables

Level: Beginners Technically you don’t need a calendar table to use Power Pivot, however in all but the most basic use cases you really should use one.  Reasons to use a Power Pivot calendar table include: …

Power Pivot Calendar Tables Read More

How to Copy and Load VBA for Excel

I love VBA for Excel. VBA can automate tasks that you use often, making the process faster, easier and more accurate to execute. I like writing VBA for myself to solve my own problems, I …

How to Copy and Load VBA for Excel Read More

Start a Second Instance of Excel

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 …

Start a Second Instance of Excel Read More

Excel is the Swiss Army Knife of Business Intelligence

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 …

Excel is the Swiss Army Knife of Business Intelligence Read More

Create Incremental Backups when using Power Query

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 …

Create Incremental Backups when using Power Query Read More

Fill Table with Last Survey Result

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 – …

Fill Table with Last Survey Result Read More

Power Query Performance Improvements – Test Drive

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.  …

Power Query Performance Improvements – Test Drive Read More

I’m Speaking at the PASS BA Conference

I’m really excited to be speaking at this year’s PASS Business Analyst Conference in San Jose California.  I will be sharing what I have learnt in my time working as BI Director at The Coca-Cola Company …

I’m Speaking at the PASS BA Conference Read More

Use Power Query to Create Power Query Documentation

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 …

Use Power Query to Create Power Query Documentation Read More

How to Correctly Install Power Pivot for Excel 2010

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 …

How to Correctly Install Power Pivot for Excel 2010 Read More

Power Query Issues with Power Pivot

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 Query Issues with Power Pivot Read More

VBA to Insert a Power Pivot Table

When Power Pivot was originally released by Microsoft, it was introduced as a Plug-In to Excel 2010.  After the second version of the Plug-In was built and released, the Microsoft Build team moved its focus …

VBA to Insert a Power Pivot Table Read More

Power Pivot Forum now supports DAX Formatter

Well Power Pivot Forum has been live for 8 months now and has over 100 users, more than 400 posts and many thousands of page views. The Power Pivot forum continues to grow as new …

Power Pivot Forum now supports DAX Formatter Read More

What is Power Pivot and Why You Should Care

I have been meaning to write this post for a long time – today is the day!  The answer to the question “What is Power Pivot?“.  You may also have landed here by searching for …

What is Power Pivot and Why You Should Care Read More

Should I delete or re-import a column in PowerPivot?

One thing I learnt in my early days of PowerPivot was that you should never delete an imported column from a table in PowerPivot.  The rationale was that PowerPivot compresses the columns during import, so …

Should I delete or re-import a column in PowerPivot? Read More

Problems Importing Access and Excel 2010 into SQL Server 2012?

Edit 10 Dec 2015: This blog post was written to solve a problem with SQL Server import drivers, however the process of addressing the issue should also work (in reverse) for people that are running …

Problems Importing Access and Excel 2010 into SQL Server 2012? Read More

How to Bulk Refresh PowerPivot Workbooks on your PC

There are a number of different ways that you can refresh PowerPivot workbooks automatically on a schedule. The main ones I know of are: Using Power BI Using SharePoint Auto Refresh Using some sort of …

How to Bulk Refresh PowerPivot Workbooks on your PC Read More

How to access PowerPivot on iPad

One thing I find when working with my customers and meeting PowerPivot users is that a lot of people want to know how to access PowerPivot when they are mobile.  Most frequently people want to …

How to access PowerPivot on iPad Read More

Data Model for WordPress Data

WordPress Reporting using Power Query

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 …

WordPress Reporting using Power Query Read More

Scroll to Top