Airline_data_analysis

In this project, I am prominently trying to Analyse the airline data set, First I made a Dashboard in order to have an overview of the data, then I perform Data analysis in Jupyter Notebook according to the problem statement, and then make a final report.

Software Used

Microsoft Power BI, Jupyter notebook

Language

Python, DAX

Libraries

Pandas, Numpy, matplotlib, seaborn

Steps, I follow

• Dashboard Making

  • Data cleaning
  • Data Modification
  • Define KPIs
  • Calculated measures according to KPIs ( Using DAX )
  • Choose the right visuals
  • Dashboard Creation

• Data Analysis using Python

  • Data load
  • Data Cleaning and modifications
  • Removing outliers
  • Data analysis and findings

• Final Report ( Report Contains )

  • Problem statement
  • Assumptions
  • research questions
  • Data analysis and findings
  • Conclusion
  • Suggestions

Some Screenshots of Analysis