Author Archives: John Donnelly

About John Donnelly

Businessman, Economist, Developer, Writer

Dealership Internal Reporting Systems

I have officially opened Automotive Systems Consulting (ASC) where we will be doing all manner of consulting assignments. Initially we will focus on much needed systems for the automobile dealership that of  internal management reporting. Currently in dealership management systems there are rather … Continue reading

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

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

Storing Bank File Conversion XML Output in SQL Server

The purpose of this post is to give users (or prospective users) an idea of the benefits of storing their bank data in SQL Server (2005 or greater) as an XML data type. In particular converting BAI and BTRS files … Continue reading

Posted in Apps for Excel, Bank File Conversion, Working With the XML Data | Tagged , , | Comments Off on Storing Bank File Conversion XML Output in SQL Server

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 Dealership Group Used Vehicle Department Objectives

Last year I rolled out what I considered a simple and effective objective for the Used Vehicle Departments in a large dealership group. I was addressing a room full of dealership General Managers (GMs) and Used Vehicle Department Managers (UVMs); about … Continue reading

Posted in Auto Dealerships, Used Vehicle Director | Tagged , , | 2 Comments

ADP (CDK Global) Expertise – Your Team, Making You More Money

This blog post appeared originally on our ADP (CDK Global) Expertise blog. ADP (CDK Global) has recently announced a new data server product available to their customer base. The product is currently called Managed Data Access (MDA). I was considering … Continue reading

Posted in Auto Dealerships | 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

Bank File Conversion App for Excel 2013 Overview Video

A quick overview of the Bank File Conversion App for Excel 2013 allowing BAI V2 and BTRS bank files to be securely converted to Excel tables, CSV text blocks and validated XML.

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

New Bank File Conversion App for Excel – Securely Analyze Bank Transaction Data

Automotive Systems Training (AST) has some exciting news to share with all of you who interact with bank data. AST released an App for Excel to the Microsoft Store which was approved last week. You can purchase this app here at an introductory price. … Continue reading

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

Bank File Conversion Overview

BAI and BTRS File Conversion – Overview A division of Automotive Systems Training – A Microsoft Partner Application: The Bank File Conversion App for Excel 2013 has been approved as of September 30, 2014. You can get your copy here. … Continue reading

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