I'm open to work starting May 2023, click here to get to my LinkedIn Profile let's connect
SHIVANI PAUNIKAR

Welcome to my Portfolio! I am an aspiring professional interested in the supply chain and data domains. My goal is to bridge the gap between these domains and leverage data and analytics to drive supply chain optimization. With a solid foundation in supply chain and logistics and a strong understanding of data and technology, I am committed to developing innovative solutions that will help businesses achieve their goals. Join me on this journey as we explore the exciting world of supply chain and data together.
INTRODUCTION:
A bird strike is defined as a collision between a bird and an aircraft which is in flight or landing roll. The term is often expanded to cover other wildlife strikes - with bats or ground animals.
Bird strikes are common, and they can be a significant threat to aircraft safety. For smaller aircrafts, significant damage may be caused to the aircraft structure. Jet-engined aircrafts are extremely vulnerable to the loss of thrust, which can follow the ingestion of birds into engine air intakes. This has resulted in a number of fatal accidents.
The data contains records of US flights between 2019-01-01 and 2021-12-31 where the plane has been struck by a bird while in flight.
PROBELM STATEMENT:
Prepare a Dashboard that can help aviation authorities analyze the impact of bird strikes across different measures of intensity such as loss of human life, cost etc., and across different dimensions (e.g., location, time, etc.).
FINANCIAL IMPACT BY SECTORS :
RESEARCH QUESTIONS:
-
What is the yearly financial impact on bird strikes?
-
Which states are affected the most?
-
How much is each airline affected financially?

LOCATION ANALYSIS :
-
What is the count of bird strikes in each state over time?
-
Is there any trend in bird strikes over the years?
-
Which species of birds are affected in the bird strikes?

CONDITIONS LOOKOUT:
-
Which phases of flight are affected the most?
-
What time of day do bird strikes occur?
-
What are the meteorological conditions?
