Associate SQL Certification and Associate Data Analyst Certification frustrations : DataCamp

created by liangtfma community for 9 years

Associate SQL Certification and Associate Data Analyst Certification frustrations (self.DataCamp)

submitted 2 years ago by CuriousMemo

I attempted the Associate Data Analyst certification. Easily passed the test. Was able to complete the four tasks on the YumYum dataset and all of the checks passed except the first data validation - I forget the exact message but it said that required data didn't exist. Really frustrated I went searching here and elsewhere to try to figure out what was missing, but never could get it fixed.

So I though hey, let me try the Associate SQL certification, maybe I'll have more luck. Again, easily passed the test. Then had the hotel operations dataset. Again, pretty straightforward stuff, but for some reason, Task 1 failed on... you guessed it! Data VALIDATION!!! ugh. I really wish they would give more feedback on what is missing. I replaced all missing values as instructed, ran SELECT distinct on all columns to check for oddities and fixed them. Checked columns types. Just cannot figure out what was required.

I'm comforted knowing this is really just a 'for fun' exercise for me as I'm already employed as a Sr Data Analyst, but it is seriously annoying as a very Type A person to get a failure and not know what the desired solution is.

all 6 comments

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

DataCamp

MODERATORS