Data Analyst | October 2020
F
•flash3389••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
There's so much more to Interview Query
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.
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
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