Chapter 3. Managing Flight Data and Creating Dashboard with Grafana
Prev		Next

Chapter 3. Managing Flight Data and Creating Dashboard with Grafana

Table of Contents

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 24-hour 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)

Prev		Next
Final Dashboard	Home	Tools