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.
Microsoft Power BI, Jupyter notebook
Python, DAX
Pandas, Numpy, matplotlib, seaborn
-
- Data cleaning
- Data Modification
- Define KPIs
- Calculated measures according to KPIs ( Using DAX )
- Choose the right visuals
- Dashboard Creation
-
- Data load
- Data Cleaning and modifications
- Removing outliers
- Data analysis and findings
-
- Problem statement
- Assumptions
- research questions
- Data analysis and findings
- Conclusion
- Suggestions
![Screenshot 2023-08-20 at 3 42 24 PM](https://private-user-images.githubusercontent.com/130036773/261845337-7efb4c8d-3079-41f7-a1c5-2c6f8146f14e.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjM3MzEyMDksIm5iZiI6MTcyMzczMDkwOSwicGF0aCI6Ii8xMzAwMzY3NzMvMjYxODQ1MzM3LTdlZmI0YzhkLTMwNzktNDFmNy1hMWM1LTJjNmY4MTQ2ZjE0ZS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODE1JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgxNVQxNDA4MjlaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT04N2FmOWE3MTFiYmE0NmU3YjczNDJjMzQ5ZDE0ODg2NTM0OGE1OGQ3MDU3ZDA4ODkzMmMwNGRhYWQwOTQ0MDI3JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.JMKzFxTJL38S0z21ixO-SpO73nD97RYF4KrvnJm5FqY)
![Screenshot 2023-08-20 at 3 41 51 PM](https://private-user-images.githubusercontent.com/130036773/261845353-20364691-50eb-4ab3-8aaa-13c57ab2de83.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjM3MzEyMDksIm5iZiI6MTcyMzczMDkwOSwicGF0aCI6Ii8xMzAwMzY3NzMvMjYxODQ1MzUzLTIwMzY0NjkxLTUwZWItNGFiMy04YWFhLTEzYzU3YWIyZGU4My5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODE1JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgxNVQxNDA4MjlaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0yNmE0MmM4YmE4NjZjYjdkMGQzOWNmNjQxNDU1YTNlMWYwNzlmZGFlYzM2MWYxZjdjYjdjNGFjYjU2NDE2MmMwJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.tIYYrU79msYeSym3M3-s3cUWpIMSlftN6EUgAFjIrPk)
![Screenshot 2023-08-20 at 3 42 38 PM](https://private-user-images.githubusercontent.com/130036773/261845363-315357d8-b11e-4ad6-9c08-66d0cad0dbff.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjM3MzEyMDksIm5iZiI6MTcyMzczMDkwOSwicGF0aCI6Ii8xMzAwMzY3NzMvMjYxODQ1MzYzLTMxNTM1N2Q4LWIxMWUtNGFkNi05YzA4LTY2ZDBjYWQwZGJmZi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODE1JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgxNVQxNDA4MjlaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0xMjBkMjg4YzQ2YzJkMTljOTM0NDRkYTBjNDY2YWFmMGIwMTJiZjg2MGQ4ZWZlNDlkM2VkM2U4YWY2ODQ3YmI4JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.lPTiWtodN9QkVG63PtOi0g7hqqvww9Twoge-HefkhUo)
![Screenshot 2023-08-20 at 3 42 56 PM](https://private-user-images.githubusercontent.com/130036773/261845370-a2528c5c-e077-4b44-8fd1-83fe5251222c.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjM3MzEyMDksIm5iZiI6MTcyMzczMDkwOSwicGF0aCI6Ii8xMzAwMzY3NzMvMjYxODQ1MzcwLWEyNTI4YzVjLWUwNzctNGI0NC04ZmQxLTgzZmU1MjUxMjIyYy5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODE1JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgxNVQxNDA4MjlaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1mZjE5MGQ0MDM5MDBmYmI0Yzk4NzVjODFiYzk2ZWJlYzg2ZGUwZGJkZTA5YzdmNzBmODg2NGFlN2Q5YzFhMzIxJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.av7r0uXMFTCIaGiE7JXt8GRRRyyX1oE3gf_Phglrpgo)