Analyze NYC taxi cab data

    Before you begin, make sure you have:

    Run all tutorials free

    Your Timescale Cloud trial is completely free for you to use for the first thirty days. This gives you enough time to complete all our tutorials and run a few test projects of your own.

    This tutorial covers:

    1. : Analyze a dataset containing NYC taxi trip data using TimescaleDB and PostgreSQL.
    2. Advanced queries: Use TimescaleDB with the PostGIS extension to query geospatial data.

    This tutorial uses the NYC taxi data to show you how to construct queries for time-series data. The analysis you do in this tutorial is similar to the kind of analysis data science organizations use to do things like plan upgrades, set budgets, and allocate resources.

    You then learn how to conduct analysis and monitoring on your dataset. It walks you through using PostgreSQL queries to obtain information, including how to use JOINs to combine your time-series data with relational or business data.

    Finally, it covers some special TimescaleDB SQL functions that can help you analyze your time-series data, and how to use other extensions, like PostGIS, for faster queries.