3 ms·
From what I've seen at my work most of the analysts tend to use specialized BI tools rather than excel. Excel is mostly used for data transformations. Pretty m
by bigger_cheese 10y ago
From what I've seen at my work most of the analysts tend to use specialized BI tools rather than excel.
Excel is mostly used for data transformations. Pretty much every tool can "speak" excel so typical work flow is to extract data using tool A dump it into excel. Save it and Upload from excel into tool B.
This is for business analytics rather than Finance/banking. Is excel really that common in that world?
- intended 10y agoExcel is hugely common. More "code" (simple logic or transformation) is probably done in excel than anything else. I'd be surprised to find a normal (non tech, non SV) firm which didn't work on excel.
- bigger_cheese 10y agoI work at an industrial plant. Excel is used a lot here too. But not for technical analytic work. Nothing you'd need to pass an exam to know how to do. The Analysts here tend to use programs like Cognos, SAP Business Objects etc.