cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ricardo2018 Frequent Visitor
Frequent Visitor

How do I find seasonality (not based on time, weather, or other typical factors)

Hello,

 

I'm an Aviation Analyst for a major airport system in the United States. I've taken two classes on DAX (from Marco Russo) but still consider myself a neophyte to DAX and PowerBi.

 

I need help. I have time series data for commercial airline schedules. I have operations (departing or arriving flights) and seat capacity (think of it as an inventory of widgets for sale). My data is time series data that includes elements such as airline name, aircraft type, origin, destination and more.

 

Problem statement:

The two basic characteristics of my data is time series and quantity.

I wish to analyze airline data and find seasonality.

 

Challenge:

Seasonality is not necessarily based on seasons of the year (winter, spring, summer, fall), or weather. I can be based on economic activity for the city, country, region of the world, and other factors. It can also be created when airlines artificially constrain supply to move pricing.

 

Is there a way I can look at time series and quantity to identify seasonality?

 

Broad example:

I have a U.S carrier that flys to Australasia, and an Australasian carrier that flies to my city in the U.S. Since the service is limited, I can graph time series data and see that the U.S. carrier's seasonality is Nov - Mar and the Australasian carrier's seasonality is Dec - Jan. Even though the carriers fly very similar markets each seasonality is different. In this example service is limited so I can simply look and estimate it.

 

 

I can provide sample data if needed.

 

Your help is greatly appreciated. I would like to thank you in advance for your help.

 

Sincerely Richard2018

3 REPLIES 3
Community Support Team
Community Support Team

Re: How do I find seasonality (not based on time, weather, or other typical factors)

Hi @Ricardo2018

 

You may try to create measure with RANKX Function (DAX) as requested.

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ricardo2018 Frequent Visitor
Frequent Visitor

Re: How do I find seasonality (not based on time, weather, or other typical factors)

Thank you! I'll hack at it and see how it goes.

Highlighted
B_Real Regular Visitor
Regular Visitor

Re: How do I find seasonality (not based on time, weather, or other typical factors)

How exactly does RANKX solve this problem?