Chapter 3. Managing Flight Data and Creating Dashboard with Grafana

Table of Contents

Contents
Tools
Part 1 - Data and Environment Preparation
Preparing the Database
Data Cleaning
Setting up the Dashboard and Connecting to Data Source
Part 2 - Working with Discrete Points
Visualizing 24hr Flight Pattern of Single Airplane
Time-series Graphs for a Single Airplane
Part 3 - Working with Continuous Trajectories in MobilityDB
Creating MobilityDB Trajectories
Aggregating Flight Statistics
Flights Taking-off in Some Interval of Time (User-Defined)
Complete Flight Data Business Intelligence Dashboard

Contents

The module covers the following topics in 3 parts:

Part 1 - Data and Environment Preparation

  • Preparing the Database

  • Data Cleaning

  • Setting up the Dashboard and Connecting to Data Source

Part 2 - Working with Discrete Points

  • Visualizing time-series data for a single airplane

  • Visualizing discrete geographic points on a map

Part 3 - Working with Continuous Trajectories in MobilityDB

  • Creating trajectories for individual flights

  • Visualizing statistics from temporal aggregations

  • Visualizing statistics from multiple queries returning temporal aggregations

  • Returning value changes from temporal data

  • Visualizing spatial statistics from nested temporal conditions (intrinsic and dynamic)