Power Pivot - Excelerator BI

Power Pivot

Creating a Desensitised Copy of a Power Pivot Workbook

Level: Beginners I have been working with a client here in Sydney were we are producing some Human Resource (HR) reporting tools to analyse what is happening across the business.  HR data is quite often …

Creating a Desensitised Copy of a Power Pivot Workbook Read More

How do I remove duplicate connections in Power Pivot?

Level: Beginners I was working with a client recently and was asked a question…  “How do I remove duplicate connections in Power Pivot”?  I know this is an issue and I specifically advise people to …

How do I remove duplicate connections in Power Pivot? Read More

Extract Measures from an Excel Workbook

I was working with a client last week and the unthinkable happened.  The client made a simple editing mistake inside the Measure editing dialogue box and it corrupted the Power Pivot workbook. We could still …

Extract Measures from an Excel Workbook Read More

Scroll to Top