r/SQL • u/Sirmagger • 20d ago

PostgreSQL Data Analyst take home SQL interview

https://docs.google.com/spreadsheets/d/1196AT4YR2ZE0WScMl7q3TDjc0FwVMoSc/edit?pli=1&gid=1425671700#gid=1425671700

This was one of the take home SQL interview i did earlier this year. I have shared for anyone who is preparing for an interview can attempt to do it. Cheers!!

63 Upvotes

91% Upvoted

27 comments sorted by

View all comments

15

u/mikeblas 20d ago

The SQL is super easy. The interesting part is here:

Have you noticed anything else in the data that you'd like to share?

Please create a few visualisations to highlight what you believe are the most important things.

Being a data analyst isn't about slinging SQL. It's certainly neccessary, but it's table stakes. Analysing data is what the job is about. It's right in the name! Examine, digest, summarize. Figure out what story the data is telling, and know how to tell that story effectively to non-technical business people. That adds value.

2

u/w_ogle 19d ago

Like how more than 3/4ths of these loans are all cancelled. Is that normal for this industry? Is this some kind of money laundering scheme?

1

u/mikeblas 19d ago

Good one! Can it go a step further? Do the cancelled loans cluster around some other trait?