3 ms·
This. The stuff I am working on is mostly glorified ETL. Some sheets of course are user facing and will have a nice sheet inside the workbook where everything i
by huhnmonster 6y ago
This. The stuff I am working on is mostly glorified ETL. Some sheets of course are user facing and will have a nice sheet inside the workbook where everything is summed up.
Generally it looks like this:
1. Get data from a central source (data warehouse/other departments)
2. Transform/combine different sources etc. (mostly with pivot tables)
3. output to a sheet
4. add some sort of automation so it runs on its own the next time