Kho dữ liệu và OLAP - IS217.M22

Dataset

• [Ukraine Airspace] - OpenSky Flight Data for Geofence Around Ukraine (2/22/2022 - present)

Giải quyết

• Get time, date, month, year: https://stackoverflow.com/questions/42657018/ssis-derive-timestamp-column-into-date-and-time-columns/72160784#72160784
• SSRS:
  ++ how to sum after count: https://stackoverflow.com/questions/34179207/ssrs-count-or-sum-expression
  ++ iff function: https://www.mssqltips.com/sqlservertip/6973/ssrs-iif-switch-choose-functions/