Filtering, Sorting, Aggregating, and Binning Using SQL
Explore how to use SQL for filtering, sorting, aggregating, and binning data to transform large data sets. Understand how these methods prepare data by removing irrelevant entries, summarizing trends, and categorizing values to enhance analysis and loading to data marts.
We'll cover the following...
Filtering, sorting, aggregating, and binning are other commonly used operations to transform data before loading it to its final destination for analysis. Let’s discuss how we can use these operations through a use case.
Use case: Analyzing flight delay data
As employees of an airline, we’re tasked with transferring relevant flight data from the company’s cloud data warehouse to a new data mart.
Because of recent flight delays, the company has reserved a data mart for this task. The data mart will assist the analysts in trying to identify the root cause of the recent flight delays. Our task is to transform the huge data set collected by the airline company in the cloud data warehouse and keep only relevant data for the analysts. ...