Data Analyst | October 2020

F
flash3389April 5, 2021, 01:12 AM
Upvote
1
Downvote

Company: MakerSights

Position: Data Analyst

Location: nan

Level: nan

Outcome: NA

How was the interview process? What was it like?

You recognize that the average product score for Zapitos is, in fact, lower than what you see from other MakerSights client-brands. You are planning to share the results with the customer success team, but first, you want to develop better confidence that the answer you are providing is sound.
 
In words (no calculations are required), please answer the following questions:
 
What other latent variables may influence this data? How might you message these influences to customer success teams when you share this data?
What additional analyses (1-2) would you perform to provide confidence that the result that we see above would hold going forward?

What technical questions were asked?

nan

What was one of your solutions?

Select b.brand_name, count(r.id) as respondent_count, AVG(r.product_rating), STDEV(r.product_rating) as product_rating_standard_deviation
FROM responses r
Inner Join surveys s ON r.survey_id=s.id
Inner Join brands b ON b.id=s.brand_id
Having AVG(r.product_rating) > (Select AVG(r.product_rating)
                    From responses r
                    Inner Join surveys s ON r.survey_id=s.id
Inner Join brands b ON b.id=s.brand_id
Where b.brand_name = “Zapitos”)

Data Analyst
I
Ichimoku
Top comment
Lorem ipsum dolor sit amet, consectetur adipiscing elit
sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.

Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.

Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
F
Fibonacci
Sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et

quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est
I
Ichimoku
Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium 😀
F
Fibonacci
Sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et

quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est

Related posts

Stripe Mid-Level Business Intelligence Engineer | November 2022
Amazon Entry Level Business Analyst | April 2022
Amazon Manager Business Intelligence Manager | June 2021
UBS Senior Quantitative Analyst | April 2021
There's so much more to Interview Query! Sign up to access hundreds of interview questions, expert coaching and a flourishing data science community.