4 ms·
1. Power Query/Pivot Tables/Power Pivot Directly connecting to SQL from Excel for data exploration 10x for me. Personal record is 77,000,000 rows in Excel via
by wkmeade 6y ago
1. Power Query/Pivot Tables/Power Pivot
Directly connecting to SQL from Excel for data exploration 10x for me. Personal record is 77,000,000 rows in Excel via Power Pivot. Lining up count vs count distinct on year-week is my go to garbage data detector. Weather data suppliers have an unseemly habit of over as well as under reporting. :-)
2. SYGRAPH, the data visualizer Lee Wilkinson to accompany SYSTAT, before he wrote THE GRAMMAR OF GRAPHICS which we now now as ~ggplot2
3. NT 3.51 - the first vision of what a stable workstation could be
4. SSDs "20 times faster" but non-users can't process the meaning of those 3 perfectly good English words