In this blog I want to describe possibilities of importing Microsoft® Excel files into ACL™, and offer tips for solving the problems that may occur. This import functionality is needed on an increasing scale in actual practice. An everyday example: We use ACL™ to conduct portfolio analyses in the context of credit financing for clients from the banking sector. Here different places deliver contract, payment and currency data in Microsoft Excel™ file format that have to be imported to ACL™ for reconciliation with other data.
Perhaps you feel the same way – you look at the calendar and are surprised that yet another year is past. For us it was very much a successful year, one that we would like to take a brief look back upon together with you.
Here we'd like to present one of our highly rated partners. DataConsulting (www.dataconsulting.co.uk) plays a major role in making the products and services of dab:GmbH highly successful in an international forum.
Runners are likely to understand something by this. In sport PACE is the time a runner needs for a certain distance, e.g. for a kilometer. If you want to run a marathon in less than 4 hours for instance, you should aim for a PACE of 5:40 minutes per kilometer.
On September 30 this year, together with my executive colleague Martin Riedl, I was able to represent dab:GmbH at the IIA Data Analytics Event in Zurich. The one-day IIA meeting – for the first time after a longish break in Switzerland – revolved around data analytics.
The biggest German Audit conference will take place again in Dresden this year, on Thursday and Friday 8th and 9th of October 2015. For those of you visiting it for the first time, the location will be the “International Congress Centre Dresden”, Ostra Ufer 2, 01067 Dresden. For us, this conference is – speaking for Germany - one of the most important places to be, as a lot of our partners and customers will be there. The full agenda can be downloaded here as PDF document.
In this blog post everything is about fields for date and time entries, and the DATETIME data type intended for this purpose. The latter has been in the functionality of ACL™ since version 10.0, offering numerous advantages that the DATE data type cannot give you in earlier versions.
For 11 years now we have been offering digital data analytics by ACL™, and in this blog post I would like to tell you a few reasons why. Why is our choice ACL™? Of course it helps if you like to use the software you are working with (in our concrete case have even been selling since this year started). But must it really be ACL™. What about Microsoft Excel™ or Access™ or other data analytics tools like IDEA?
For the first time after a longish pause an IIA event with the keynote data analytics is again set to take place in Switzerland. (*By the way, the quote in the header is from Sir Arthur Conan Doyle, author of Sherlock Holmes, and is used by the organizers on the invitation flyer, which you can -> download here.)
We would like to invite you to an advanced training event by our US sales partner HWA (High Water Advisors, www.highwateradvisors.com), in the staging of which we are participating. It is a pleasure for us that HWA with its Managing Director Steve Biskie (Author of the book "Surviving an SAP® Audit") is organizing the event and has invited us to Denver to participate.