Tag archive for ‘Linking to Excel’
Last time we talked about how much data can comfortably be put into and Excel spreadsheet and I’ve found that more than a few hundred thousand rows can get awkward. Plus, certain types of operations are more difficult to automate in excel (often requiring programming skills with macros or visual basic for applications (VBA)). So- this means […]
-
Data mart Data Modelling 101
Last time we talked about how much data can comfortably be put into and Excel spreadsheet and I’ve found that more than a few hundred thousand rows can get awkward. Plus, certain types of operations are more difficult to automate in excel (often requiring programming skills with macros or visual basic for applications (VBA)). So- this means […]