Topper wrote: ↑Fri Nov 30, 2018 7:32 am
Databases >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
spreadsheets
So, basically saying that a warehouse is better than a newspaper?
Different things with different purposes.
Although.... since Office 2010c came out, you can actually build relational databases in excel. No need for access anymore.
Since we at present have no business intelligence software worth its name at my current workplace, I just use a backdoor in the accounting software, upload the sql information I need into excel, using the powerpivot addition, and then present it in a dozen or so dynamic spreadsheets where you can filter the information to find the nuggets you look for in no time.
Sure, if they'd just buy the good software I wouldn't have to, but excel gives me the tools I need to juggle the numbers anyway.
Don't know what I'd do without it.