Data Analytics Interview
30 of 84 Completed
Introduction to Business Health Metrics
What is Business Health?
Determine Business Priorities
Identifying Input and Output Metrics
Ranking and Prioritization
Demand Metrics
D2C Socks e-Commerce
Community Health Metrics
Community Health Metrics
You work at Stack Overflow on the community team that monitors the health of the platform.
Community members can create a post to ask a question, and other users can reply with answers or comments to that question. The community can express their support for the post by upvoting or downvoting.
Example:
Input:
post_analytics table
| Column | Type | Description |
|---|---|---|
id |
INTEGER | Primary key of posts table |
user_id |
INTEGER | ID of the user who created the post |
created_at |
DATETIME | Timestamp of the post |
title |
VARCHAR | Title of the post |
body |
VARCHAR | Text content of the post |
comment_count |
INTEGER | Total number of the comments on a post |
view_count |
INTEGER | Total number of the views on a post |
answer_count |
INTEGER | Total number of answers on a post |
upvotes |
INTEGER | Total number of upvotes on the post |
Given a table of Stack Overflow posts data, suggest three metrics to monitor the health of the community.
Write the queries for these metrics in SQL.
35%
CompletedYou have 54 sections remaining on this learning path.
Advance your learning journey! Go Premium and unlock 40+ hours of specialized content.