Tag Archives: PowerPivot

Analyzing Bank File Conversions XML Data Files using Power Query and PowerPivot

In a previous post, I showed how to use the Bank File Conversions App for Excel 2013 (BFC) to: convert BAI Version 2 and BTRS files, set the data in tables in Excel 2013, add them to the Excel Data Model … Continue reading

Posted in Bank File Conversion, Working With the XML Data | Tagged , , , , | Comments Off on Analyzing Bank File Conversions XML Data Files using Power Query and PowerPivot

Using Bank File Conversion App for Excel with PowerPivot

Bank File Conversion App for Excel 2013 (BFC) is designed with PowerPivot in mind. In fact, the three outputs provided by the conversion (Excel Tables, XML and CSV) are readily imported into PowerPivot for further analysis. This post uses a sample workbook … Continue reading

Posted in Apps for Excel, Bank File Conversion | Tagged , , | Leave a comment

Auto Dealerships Need Business Intelligence

Turn data into actionable information in ADP. Business Intelligence is simply Microsoft Excel used in a new way. A way that takes a little help to set up but is extremely simple to use thereafter. The introduction of Microsoft’s PowerPivot … Continue reading

Posted in Management Reporting | Tagged , , , | Leave a comment