PowerPivot - Excelerator BI

PowerPivot

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

Solved: Power Query Issues with Power Pivot – Exception from HRESULT: 0x80020009

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 …

Solved: Power Query Issues with Power Pivot – Exception from HRESULT: 0x80020009 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

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

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

Use Simple SQL to Manage your data in Power Pivot

When I started learning Power Pivot, I learnt there are 2 ways to import data. There is the “standard way” that uses the table import wizard – good for us Excel folk. There is a …

Use Simple SQL to Manage your data in Power Pivot 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

Save your SharePoint Password on iPad

I am a big believer that the browsing experience must be seamless before real world users will fully embrace PowerPivot when mobile. The Standard SharePoint iPad Experience One of my biggest issues up until now …

Save your SharePoint Password on iPad 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

Scroll to Top