3 ms·
1 = Yes, that's exactly what I think we need here. A perfect example is the "data frame" concept in R (that you can implement as a list of tables in other langu
by viandante 15y ago
1 = Yes, that's exactly what I think we need here. A perfect example is the "data frame" concept in R (that you can implement as a list of tables in other languages). Excel doesn't have decent high level abstractions of your data, that forces the user to do a lot of boiler plate work that can be extremely time consuming and dangerous (as the more more manual work, the more mistakes).
2 = Excel 2003 limits (still used in my company): http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx http://office.microsoft.com/en-us/excel-help/excel-specifica.... Especially when you make deep analysis (first 10 customers of segment B, low margin products, lost due to low margin products, pricing, etc.), you hit the limit and you are forced to do bad things (like using 12 columns instead than 2 to represent 12 months).
3 = As 'small data' I just mean all those data people use in companies. Usually those are the result of extracting data using a business warehouse system (ie cognos) or financial data submitted by entities (ie 30/40 files from different parts of the world of PnLs to consolidate...) or KPIs, or... you get the idea...
p.s. I will be sending you an email later today. It would be really great to discuss those concepts.
- gruseom 15y agoPlease do. I look forward to it.