4% of Country = "NONE" sounds like they're running a tight ship compared to some places I've seen.
At least those date fields don't have "Unknown" as a value. Yes, I have seen the date field stored as text.
You are absolutely right. The ETL side, nailing down appropriate business logic, chasing down source errors and inconsistencies, altering processes to capture the data we need to give good answers; these are the challenges that take >80% of our time. If we do our job right in these pieces, the reporting can be done by an intern who learned how to use a pivot table yesterday.
A few responses:
I hope that list was sorted.
4% of Country = "NONE" sounds like they're running a tight ship compared to some places I've seen.
At least those date fields don't have "Unknown" as a value. Yes, I have seen the date field stored as text.
You are absolutely right. The ETL side, nailing down appropriate business logic, chasing down source errors and inconsistencies, altering processes to capture the data we need to give good answers; these are the challenges that take >80% of our time. If we do our job right in these pieces, the reporting can be done by an intern who learned how to use a pivot table yesterday.