1. Learn
    2. /
  2. Courses
    3. /
  3. Time Series Analysis in PostgreSQL
Connected

Exercise

Analyze data distribution

Many product managers are adept at exploring the data around the product features for which they are responsible. In this scenario, you are a data savvy product manager handling the newsfeed for a social media application. You suspect that your newsfeed data collection infrastructure might have an issue with anomalous data. The average number of views per article per sample period is skewed way upwards from the typical number of views.

You start by examining the reading behavior of the top five articles in a one week reporting period to get a sense of what the reading behavior looks like for five popular but otherwise typical news articles.

The dc_news_dim and dc_news_fact tables are available to you.

Instructions 1/2

undefined XP
    1
    2
  • Calculate the maximum, average, and continuous median.