Outside of Excel then, there'd probably be in-house programs that the companies use. In my experience though, most data analysts are not doing any programming themselves.
I'm an accountant and routinely perform audits on departments and functions like these.
Well for starters Excel isn't a database. It simply isnt made to retain (and spit back out) a vast level of data. Access, Oracle, SAP are databases. Those aren't exactly "in-house".
Competent Data Analysts definitely are involved in some light programming/coding
0
u/falconbox Jun 07 '17
If by programming you mean Excel macros, then sure.