Companies need to create a help desk for data, similar to the help desk they created for hardware, software, application, network, and user problems.
Can you imagine if companies didn’t have a computer help desk and each department had figure out their own computer issues? If each department had to find, load, configure, and troubleshoot their own hardware and software?
But isn’t that how most companies operate when it comes to data and data projects?
Continue reading →
Like this:
Like Loading...
Filed under Audit, Data Analytics, How to...
Tagged as analytic, analyze, backlog, champion, citizen, cost, data, data scientist, drill, driven, expense, help desk, hole, ODBC, query, REST, Security, transform, validate, value
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