[ENG] Data Analyst Mock Interview (SQL, Google Sheets) | Resume, Portfolio and LinkedIn Reviews

Timecodes for video:
00:00:00 Getting to know the cops.
00:01:41 Resume review.
00:06:44 Review of portfolio projects.
00:27:01 The need for references in portfolio projects.
00:30:35 Review of LinkedIn account.
00:41:42 Start of the test interview.
00:42:55 The difference between a project for an internal and external audience.
00:45:38 A grasshopper jumps forward 80 centimeters or backward 50 centimeters along a straight line. Can it move exactly 1 meter 70 cm from the starting point in less than 7 jumps?
00:48:47 Problems with BigQuery accesses and file sharing.
00:57:27 SQL task: Authors with the highest rating.
01:04:24 SQL task: Three publishing houses that have published the most authors.
01:11:41 SQL task: The author with the highest average number of pages.
01:14:06 SQL task: How many books have Harry Potter in their title?
01:19:25 Top 10 authors by number of reviews.
01:30:07 Repeating the previous tasks, but in Google Sheets.
01:45:23 Meeting closing.
________________________________________________________________

________________________________________________________________

My name is Roman Povzyk, and for a year now I've been helping data analytics beginners increase their chances of getting an offer.

________________________________________________________________

I'll send you the links before we meet. The articles are written in Ukrainian. But you can translate them into English in your browser. I hope they will help you answer some of your questions before the session starts.

[jophlandondzie]

The customized button appears only if you are in creator mode, so activate your creator mode even without a premium account, and you will see the button.

[ЮрійІваненко-кб]

А можна замість Гугл Таблиць використовувати Excel?