3 ms·
I have 2.4 billion data points loaded in Excel at the moment. Not that it matters. "Data science" is not something that magically kicks in after you go beyond
by blahi 10y ago
I have 2.4 billion data points loaded in Excel at the moment.
Not that it matters. "Data science" is not something that magically kicks in after you go beyond some "big data" threshold.
Excel is heavily used in managerial science type of positions and I can assure you those are rather heavy on the "data science" workflows.
- ramblenode 10y agoThe maximum number of rows in the most recent version is 1,048,576 [0]. I'm deducing then that your data is in wide format. What would happen if you wanted it in long format? It seems you would just be out of luck with Excel, which is not a problem in any other major statistics software. [0] https://support.office.com/en-us/article/Excel-specifications-and-limits-ca36e2dc-1f09-4620-b726-67c00b05040f https://support.office.com/en-us/article/Excel-specification...
- blahi 10y agoExcept that there is Power Pivot which is xVelocity - the same columnar store database use in SQL Server.
- goatlover 10y agoWhy on Earth would you use Excel for that many data points?
- blahi 10y agoQuik self-service OLAP. Blazing fast slice & dice and multidimensional expressions (cube formulas). I would need a corporate BI solution to get that and it won't be self-service. Nothing beats Excel + Power BI in reporting.