Given three tables, user_dimension (user_id and account_id), account_dimension (account_id and paying_customer), and download_facts (date, user_id, and downloads), find the average number of downloads for free vs paying customers broken out by day.
Data Analyst Junior Interview Questions
47,626 data analyst junior interview questions shared by candidates
If you have 10 bags of marbles with 10 marbles each and one bag has marbles that weigh differently than the others, how would you figure it out from one weighing
There are 25 horses, and you want to rank the fastest 3 horses out of those 25. In each race, only 5 horses can run at the same time because there are only 5 tracks. What is the minimum number of races required to find the 3 fastest horses without using a stopwatch?
Many personality questions and situation based question (i.e. What would you do if you are in XYZ situation, how would you respond?) Tell me a time when you were in a difficult situation at work, how did you rectify the issue?
What are 5 uncommon uses of a brick, not including building, layering, or a paper-weight?
A car starts driving at 60 mph, one hour later a car leaves the same position going 80 mph. How much time will pass until the second car catches the first?
How do you work under pressure?
Everything related to basic accounts. Questions on P&L and Balance Sheet.
1. What is UNION CORR in SQL?
Given a plot of land and $250,000, what can you do to maximize your revenue and what kinds of data would you look at to do so?
Viewing 11 - 20 interview questions
See Interview Questions for Similar Jobs
Stage Di Big DataData Analyst Di Primo LivelloInterno Di StatisticaAnalista Di Dati Di Primo LivelloSviluppatore Sql Di Primo LivelloStagista Di Elaborazione DatiStagista Di Big DataSviluppatore Sql JuniorAnalista Entry Di Primo LivelloStagista Di Analisi Di DatiAnalista Di Dati PythonStatistico Di Primo LivelloAnalista Di Dati Di Analista Quantitativo JuniorAnalista Di Primo LivelloStage Per Analista Di DatiData Analyst AssociatoStagista Dell'analista FinanziarioStagista Di Analisi Quantitativa