Airline Loyalty Program

My Role     : Lead Marketing Analyst

Context     : Northern Lights Air, a Canadian airline ran a  promotion from Feb 1st - Apr 20th 2018,  offering 1.5x loyalty card points to new  members for flights booked through the remainder of the year. NLA want to analyze loyalty program enrollments, cancellation and flights booked and shareth findings with the NLA leadership team.

Problem Statement: Analyze the NLA promotion data to boost enrollment for their loyalty program.

Outcomes     : Impact on Loyalty Program Memberships (Gross/ Net), Campaign Adoption success across demographics, Impact on Booked Flights During Summer

Recommendation : Personalized Offers, Increase Engagement, Improve Communication, Leverage Technology

Methodogy  : Analyze the data using Power BI

The Data     : Data used from Kaggle datasets.

Skills             : Power BI