Here’s the 5 things I’m hoping will change in 2018 regarding ACL.
They are all related to each other and feed off each other…
One) The ACL Analytics user interface (UI) finds a good plastic surgeon.
While I have criticized the ACL interface over the years on this blog, I provide some examples in 5 Things I Hate About ACL.
I wrote this in January 2014, and not one of them has been addressed. Just saying…
Many auditors tell me that one struggle they have with using ACL is that it’s hard to remember how to use it. Because they aren’t using it every day, they say they have to relearn some of the key functions over and over. It’s just not intuitive. The interface looks as old as ACL itself (25+ years).
You can tell that ACL is NOT catering to millennials with their flagship software. :)
Now, having said all that, I always try to be fair. Updating the interface means that ACL has to revamp their help file, ACL Academy training, cheat sheets, ACL boot camp videos, and the list goes on.
Plus all the ACL trainers and support people have to be retrained.
All of this is expensive, so in their chase to expand the revenue stream at the company, I understand why they haven’t done it. It means starting over on many fronts.
But in my opinion, ACL passed the tip-over point in 2017, especially since Excel Power Query and Power BI have gained popularity (more on this below).
And they were already losing ground to Tableau and other products before that.
One other thing….unlike Mack, who likes the new ACL Overview article (ACL’s article that Mack writes about) that describes the first ACL screen a user sees, I see that article as further proof that the UI is poor.
When you have to explain the first screen a user sees, you are NOT user friendly!
Back in the good ‘ole days, when you opened ACL, you never saw all these options, which are confusing (they are add-ons to ACL or links back to their website, and were added after the ACL CEO arrived and cleaned house).
I missed the days when you could open ACL and get to work immediately.
By the way, I heard in late 2017 that an updated interface is coming SOON to a screen near you. We’ll see.
Two) ACL makes transforming data as easy as CLICKING buttons and SELECTING options.
If you don’t know what I’m talking about, you must not use either Excel’s Power Query add-in or Microsoft’s Power Business Intelligence (BI)–these programs and others have this amazing function.
In the Power BI example shown below, to change the format of a field BEFORE you load it, note the Zip field (see yellow on the far right), which is in number format (notice the 1 2 3 in white text in front of the Zip field header).
To change that field to text format, go to the Transform tab (see red box), then click Data Type, then Text (see yellow on left).
While you’re at it, notice all the other transformations available (not all are shown).
In ACL, you not only have to load the data FIRST, but you have to add a new field, and write a function to change the format.
The other thing I like about Power BI is that as you click and select what to transform, Power BI writes its own script for you (called M script).
In ACL, you have to find the procedures in the log, copy it into a script, and add additional info to the script. For that reason, a lot of auditors are scared of scripting.
After you load and format/clean the data in Power BI the first time, the next time you load that data or need to refresh that data, the M script does it all for you the same exact way.
Again, in fairness, M script is not as flexible as ACL script, but M script is perfect for transforming data and that’s what it does.
My point: not only is ACL’s interface killing the product, it is not keeping up with up and coming features that other products already have. And ACL is trying to sell this product to non-auditors? To millennials?
No wonder they need to expand the revenue stream!
Other analytic products on the market don’t take as much technical expertise to do simple loads, transformations, or graphics–not true of ACL.
Update: Speaking of ACL graphics–ACL analysis apps, which was ACL’s attempt to deal with its poor graphic capabilities (and add other features), I seldom hear of anyone using analysis apps. I just did an Internet search and didn’t find even 1 mention of ACL analysis apps anywhere, except @ ACL’s website and other websites announcing the launch of analysis apps.
That tells me that no one cares about analysis apps. Dan and Keith, do you realize you built something that most ACLers don’t care about? All that time and effort, and I’ll bet not even 25% of ACLers use it. Meanwhile, your core product flounders….
Sure, you can now purchase some ‘premium’ pre-built analysis apps to do some of your typical analysis. But does that lead audit departments to dive into really learning analytics and creating their own ACL projects? I doubt it, based on how internal audit as a whole likes to be spoon-fed.
Either way, ACL has created another revenue stream (I think I see a theme here….).
One auditor I work with refuses to use ACL, but she learned Power BI by herself and produced a monthly dashboard that audit management loves! Other auditors in the department are thinking of doing the same.
Maybe my next most-read blog post should be Teach Yourself Power BI!
Three) ACL starts blaming audit management for lack of analytic growth.
Numerous reasons are given for the slow adoption of analytics in most audit departments: lack of skilled talent, too hard to get data, dirty data is hard to clean, no budget for licenses or training, etc.
But everyone knows the REAL reason, which is audit management refuses to act.
Audit management either doesn’t want analytics, doesn’t understand it, or is unwilling to fight for it. But all audit managment says they want more analytics in audit!
Passivity on management’s part is the real reason for the slow growth of audit analytics. All the other ‘reasons’ are CAE excuses. Period. You can do analytics on a shoestring budget if need be.
In this article, ACL provides 4 reasons for the slow growth (see below; emphasis below is ACL’s). ACL almost nails it in Reason #4, but they fail to close the deal.
I realize this is a summary of several reports (and author Verver isn’t directly an ACL employee any more [Hmmmm]), but ACL published the article, so I still call out ACL for the conclusions offered;
I added my comments after each quoted reason…
- “Internal audit leadership recognizes the valuable role of data analysis in audit.” This disagrees with item #4; it also directly convicts audit leadership. They ‘get it’, but aren’t doing much about it. Knowing or Recognizing something isn’t the same as believing it and living it. Reason #1 is a non-truth, also know as ‘fake news’.
- “Internal audit leadership expects in the next three to five years to be using data analytics far more extensively, in the way that they have said they want to for the past several years.” Yeah, kick the can down the road. In other words, play catch-up someday. This why I have repeatedly said that internal audit will soon become irrelevant.
- “Internal audit teams currently lack the skills and the time to achieve what they want to do with data analytics.” Who hires those ignorant teams? Who determines where auditors spend their time? Who is supposed to provide ‘audit supervison’? Audit management perhaps? Reality: CAEs lack the ‘current skills’ and ability to lead.
- “However (and perhaps revealing a disconnect), the majority of internal audit leaders do not recognize data analytics skills as particularly important.” Perhaps? It IS the disconnect, and the main reason, but ACL can’t say that, or they’d upset their prime audit management customers, who just might cancel all those ACL licenses the audit team is NOT using.
I insist that ACL (and all the big 4 firms) stop beating around the bush, and call out audit management for their failure.
Isn’t that what auditors do? ACL says their staff was originally built on auditors (like VP Dan Zitting). The big 4 says they’re all auditors.
If they really want to have an impact on the profession, and increase analytics in audit, they will call CAEs and audit committees out.
At the same time, I realize you can’t bite the crippled hand that feeds you. But ACL and the big 4 can do better.
Perhaps they should strive to educate audit committee members directly, and bypass CAEs all together.
Four) ACL stops selling their GRC platform so hard.
ACL has lost its first love!
And unless it repents and does the things it did at first, its candlestick will be removed.
ACL needs to turn its focus back to its main product.
But in every email, phone call, webinar, training class, and article the company publishes, and in the ACL conference especially, it’s push, push, push. Sell, sell, sell.
Again, I understand ACL is widening their revenue streams (their main product is dying?), and all that, but I still think ACL is doing so at the expense of their ORIGINAL (read ‘analytics’ customers).
But the user interface hasn’t been updated (see One above) and the ACL app is as bloated as the Windows OS, and lacks key features.
Sure, ACL is adding and improving some features, but ACL is consistently behind other analysis and scripting apps (see Two above).
Another example: remember when ACL added color coding to the scripting screen? That was great, but other products delivered that years before!
Five) ACL reboots their annual user conference.
For a couple years, the conference was great. But in the past 2 years, the conference is mostly about GRC!
Interesting statistic: According to a discussion in the 2017 conference town hall, less than 25% of those attending the conference use GRC. See the disconnect?
Also, are the ‘free’ training classes at the end of the conference really that valuable?
I was told that 1 session in 2017 had horrible technical glitches, as well as instructors who weren’t ready to lead the class. So much of the content was confusing that several people got up and left.
Finally, experienced ACLers don’t often go to the conference. Almost everyone you meet is brand new to ACL.
Why? Here’s my thoughts:
- Experienced users want challenging sessions. Session quality has dived in the past 2 years, especially the General Sessions and some of the Keynotes.
- Experienced users want more opportunities to network with other experienced users, but the networking opportunities currently at the conference don’t work.
- The conference app is useless as a networking tool. Too many stupid posts and pics.
- If the best thing about the conference is the food and entertainment, that’s a huge problem.
- New people attending the conference end up not using ACL much, which feeds the cycle.
One Last Note
Okay, I’ve said my piece, and you can tell I’m frustrated. Big time.
But I still love using ACL and how it helps me and my department shine. I’m just concerned that ACL is headed in the wrong direction.
I’m already being pressured to abandon ACL in favor of ‘standard company tools’, and the further behind ACL gets, the harder it will be to resist.
Especially as I gain more experience in the ‘company tools’. I’m currently importing and transforming data AND creating a dashboard in Power BI, and have several other projects that don’t use ACL in progress. Audit projects!
You have a great tool, ACL. But I need your help in keeping it!
AGREE OR DISAGREE with any of my points? Let me know in the comments!
If you’ve gone to a conference, please state the year, your experience level (beginner or experienced), and provide your input.
I’m betting most of my readers have never gone to an ACL conference, and half of those who have, have only gone once…