Flight Details Report

Most detailed datasets are the ones that have a lot of date, time & scheduling details, also a lot of data. I'm happy that I got the chance to work on one of these datasets which is the Airlines or Flights Details dataset. It includes information about the flights details, such as flights number, departure & arrival times, delays and their reasons, etc.

What have been applied:

▶ ETL Process

▶ Creating Date & Time tables

▶ Dimensional Modeling

▶ Creating Hierarchies & Dax measures table for calculating measures

▶ Different visualizations & techniques like drilling down, tooltip, bookmarks

▶ Organized visualizations, colors, easy to read & understand

Tools used: Power BI & Excel