4 ms·
Excel as a database
- jsjenkins168 19y agoAt my previous job I did some "data cleansing" of transactional data for our customers, to ensure it was in a usable format to perform ETL on and eventually load into an OLAP datamart for analytics. You would be surprised how many big (like household name) companies use Excel/Flat file formats to record their data..