If you are in IT, audit, or security (or any other job requiring data analysis), you should NOT be cleaning data manually.
Let me share a recent experience with you….
A young IT auditor texted me at work and asked for some Active Directory user account data that I capture automatically every week, using some scheduled ACL scripts.
If you’re not familiar with my ‘Quote of the Weak’ series, I described it briefly in About. For a list of posts in this series, see here.
Continue reading →
Like this:
Like Loading...
Filed under Audit, Case Files, Data Analytics, Excel, How to..., Quote of the Weak, Security, Technology
Tagged as analysis, clean, data, drive, excel, experience, formula, manual, map, network, transform, user ID
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…
Interesting.
Continue reading →
Like this:
Like Loading...
Filed under ACL, Audit, Data Analytics, Excel, Scripting (ACL), Technology, Written by Skyyler
Tagged as 5 ACL Things to Hope for in 2018 #ACLanalytics #2018 #hope, acl, analytics, Audit, audit command language, CAE, capability gap, ceo laurie schultz, charts, clean, Conference, connections, dan zitting, dashboard, data, excel power query, fake news, general session, graphics, grc, hate, John Verver, keith cerny, keynote, M script, management, millennials, plastic surgeon, Power BI, push, sell, skills, supervision, tableau, time, training, transform, user friendly, user interface, visualizations
Your management says it wants more analytics, but does it really support analytics? Here’s 10+ signs that indicate that your mgmt:
- Does NOT knows what it takes to get analytics off the ground
- Believes that analytics multiply like rabbits, naturally
- Is NOT willing to make the adjustments required to deliver and sustain real value.
Continue reading →
Like this:
Like Loading...
Filed under Audit, Data Analytics, How to..., Technology, Top 10, Written by Skyyler
Tagged as access, analytics, Audit, backup, challenge, champion, clean, data, dedicated, dog food, format, goals, hiring, infrastructure, interview, leader, measure, metrics, pllaning, profile, rabbit, signs, support, Top 10, transform
Do you know the #1 reason auditors don’t do data analytics (DA) much?
It is so simple, so obvious, I hesitated to blog about it. Let me know if you agree.
Continue reading →
Like this:
Like Loading...
Filed under ACL, Audit, Data Analytics, Scripting (ACL), Technology, Written by Skyyler
Tagged as #1, analytics, clean, excel, filter, full population, inspect, join, pivot table, profile, reason, results, SALY, same as last year, time, transform, vlookup
If you’re new to the blog in 2013, you might think that Skyyler is only an ACL gear-head. But he DOES write about non-ACL topics. Occasionally.
Continue reading →
Like this:
Like Loading...