3 ms·
The analysts I knew at my last job would use Excel to prototype huge, incredibly complex business logic and calculations, and then have programmers (or the skil
by antihero 6y ago
The analysts I knew at my last job would use Excel to prototype huge, incredibly complex business logic and calculations, and then have programmers (or the skilled ones would do it themselves) implement this stuff in SQL or whatever language made the most sense when it came to analysing billions of rows of real data.
It's an exceptionally powerful tool for prototyping.
- pyromine 6y agoI often do a fair amount of exploratory data analysis in Excel, and then take it to a BI tool or some other process to actually formalize it. In excel the ability to be sloppy is actually really nice to just sling together a few random models and call it good when I don't need to be precise.