Datenanalysten Interview Questions

46,239 datenanalysten interview questions shared by candidates

you have a table containing order id order date and customer id write a sql query to fetch all the customer id which have visited again ( customer id is same for customer but order id will change every time they will order )
avatar

Senior Data Analyst

Interviewed at noon

3.7
Jun 19, 2024

you have a table containing order id order date and customer id write a sql query to fetch all the customer id which have visited again ( customer id is same for customer but order id will change every time they will order )

The difficulties were in the marketing questions: (may not be exact) "what experiment could you perform on social media to determine consumer intent" or "how could you use the Reddit or Pinterest API for our analysis"
avatar

Marketing Data Analyst

Interviewed at Shopify

3.4
Jun 7, 2014

The difficulties were in the marketing questions: (may not be exact) "what experiment could you perform on social media to determine consumer intent" or "how could you use the Reddit or Pinterest API for our analysis"

Suppose we have a binary classification problem. 99.8% of individuals in our sample = 0, 0.2% = 1. We downsample: we randomly sample say 1% of the individuals which =0, but keep all which =1. We fit our model to this new smaller sample, and now we have a model which produces probabilities that an individual = 1. How do we adjust our output probabilities to use this model on the population as a whole?
avatar

Data Analyst

Interviewed at Upstart

3.8
Dec 20, 2019

Suppose we have a binary classification problem. 99.8% of individuals in our sample = 0, 0.2% = 1. We downsample: we randomly sample say 1% of the individuals which =0, but keep all which =1. We fit our model to this new smaller sample, and now we have a model which produces probabilities that an individual = 1. How do we adjust our output probabilities to use this model on the population as a whole?

Viewing 651 - 660 interview questions

Glassdoor has 46,239 interview questions and reports from Datenanalysten interviews. Prepare for your interview. Get hired. Love your job.