Hacker News new | ask | show | jobs
by OzCrimson 2066 days ago
How do you have so many answers to situations you haven't been in?

Do I need to say it again? My Excel skills were necessary because of garbage in databases.

I could sit at my desk; extract a data-dump of 50k rows of data; locate the fuzzy matches, identify which records needed to be kept and which ones deleted; merge it with the client's spreadsheet that they emailed to me and compare them; identify problems and report back to the angry client.

Why was the client angry? Because of inflexible garbage reports coming out of the database that people were blindly trusting.

Why was there garbage in the database? Not because of Excel.