Recent Posts: ADP (CDK Global) Technical
CDK letter explaining the end of Telnet
Start Collecting Your Dealership’s Data So You Can Understand & Improve Your Store’s Results – Reposted
This is a re-post of my post on ADP (CDK Global) Expertise today.
Recent Posts: Auto Dealership Group Management
TagsADP Apps for Excel ASC Automotive Systems Consulting BAI BAI2 Bank File Bank FIle Conversion App for Excel BFC BI BTRS CDK Global Excel 2013 Excel Data Model Inventory Management Management Objectives MDA Microsoft MIS M language PowerPivot Power Query SQL Server summary Used Vehicle Department Winners Circle XML XQuery
Author Archives: John Donnelly
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
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
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
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
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
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
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
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.
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