Job interview tip #1

DON'T DO THE TEST.

Most job interviewers will want you to complete some kind of a skill test. If we talk about data analytics you will probably get SQL involved questions.

Case #1. "On the spot paper-written test":

So you're sitting there, enduring your next job interview, and then *BAM* the manager hands you a piece of paper with SQL (or whatever) test questions. Here's what you gotta do. Take a long suspicious look at the paper, then slowly shift your gaze into the manager's eyes and say: "I won't do it, this is childish". First of all, you will stand out and he/she will remember you. Secondly, you communicate a message that says: "my skills are so awesome and your silly test is below me". This is what your employer wants from you. To be plenty of skill. The only reason they give you these stupid tests is to filter out bullshitters that are only capable of shouting they know something.

The thing is, their tests are, 100% of the time, truly badly made. And they expected to be done on a piece of paper, which is non-sense. In order to counter that, have a nice self-made SQL code to showcase. Fill it with comments that explain every step and also have a word-document describing the business requirement and how you achieved the result. Bring your laptop/tablet and use it for demonstration. You will make a formidable professional impression.   

Case #2. "They send you a test via email":

So you've successfully suffered through the first stage and went home to discover a test they want you to complete. You'll find the test to be equally as dumb as the on-the-spot one, only this time it's long and even more confusing. The strategy here is pretty much the same. Don't actually do the test like everybody else. Send them your awesome portfolio projects and let them marvel. Concerning their test, just not to be rude, give your commentary. If a question has a clear-cut answer - give it to them, explaining in full detail the reasoning. Keep in mind, they don't need the answers, they need to see your skills. If the question is overly complicated and unclear - just outright say it, something along the lines "this task has multiple ways of completions, depending on details of the according expected result, yada yada". 

To summarize, stand out and be prepared. When at war it is always best to play by your own rules.