1. Apprendre
    2. /
  2. Cours
    3. /
  3. Time Series Analysis in PostgreSQL
  • 1

    Introduction to Date and Time Data in PostgreSQL

    Gratuit

    In this chapter, you’ll be introduced to date and time data types. You’ll learn how to convert text and numeric data to date and time format—and how to convert the other way around too!

  • 2

    Working with Time Series

    It’s time to get granular. In this chapter, you’ll learn how to set the granularity of your time series reports. You’ll then get to grips with adding, subtracting, and aggregating as you discover how to analyze time series data.

  • 3

    Using Window Functions to Analyze Time Series Data

    In this chapter, you’ll work with window functions. You'll begin learning about partitions and partitioning and how they work with window functions. You'll be able to find the top items when ranking your data.

  • 4

    Calculating Running Totals and Moving Averages

    In the final chapter, you’ll level up your skills by calculating the running total, running average, and even moving average to enhance your time series analysis.

Initializing

Exercice

INSERT time INTO table

As a data analyst you may be called upon by a developer to test a table that they have created for a particular task. In this scenario, you are a member of a team in charge of tracking the usage of an app tied to a fitness device. You are testing a new table called usage_fact having the columns user_id, usage_date, usage_duration, in that order. It will store the total amount of time that the device was used per day.

You want to insert test rows into the table to ensure that it works as intended.

Instructions

100 XP
  • Add a row to the table such that for user 1 it assigns the usage date to be Dec 31, 2020, with a duration of 65 seconds.