I was given a tiny dataset in Excel (less than 250 rows) with only 4 columns, i.e. dateordered, datereturned, orderstatus & orders

Exercise 1: Crunch the data and tell us whether our return rate is trending up or down. Additional insights are welcome, but not required
Exercise 2: Write the SQL code to produce number of completed orders by date

Question

I was given a tiny dataset in Excel (less than 250 rows) with only 4 columns, i.e. dateordered, datereturned, orderstatus & orders


Exercise 1: Crunch the data and tell us whether our return rate is trending up or down. Additional insights are welcome, but not required
Exercise 2: Write the SQL code to produce number of completed orders by date

Sigiloso · Accepted Answer

I completed the exercises in both R (using tidyverse, e.g. dplyr, ggplot2) and SQL. I even tidied up the messy data and provided visualization for the output, in addition to answer the questions.

Sigiloso · Answer

There's quite an extended back and forth in actual interviews for questions like this, so nothing quite like real practice.


The Prepfully Casper  Analyst, Data and Analytics experts have actually worked in this role, so they're able to do an honest-to-God accurate mock, which really puts you through the paces.


prepfully.com/practice-interviews

Casper

Pergunta de entrevista da empresa Casper

Respostas da entrevista

Empresas seguidas

Buscas de vagas