✈️ Airline Data Analysis Project Using Power BI 📊 Overview This project aims to analyze airline operations and performance metrics using interactive dashboards in Power BI. It enables stakeholders to monitor key data points such as passenger trends, flight distribution, ticket status, and airline-specific insights to support better decision-making. 🎯 Objectives Understand overall airline performance. Track passenger trends over time Analyze ticket booking statuses. Compare flights by airline and destination. Build airline-specific drillthrough pages. Implement Row-Level Security (RLS) for user-specific access.

🧰 Tools & Technologies Power BI Desktop Power Query DAX (Data Analysis Expressions) Excel (for raw data source)

📌 Key Features Interactive Dashboards: Visualize flights by airline, passenger count, and booking status. Slicers & Filters: Easily explore data by date, airline, and destination. Drillthrough Pages: View in-depth analytics for individual airlines Row-Level Security (RLS): Restrict access to specific airline data. Scheduled Refresh: Automate data updates daily at 5 PM.

📈 Visualizations Used Clustered Column Charts (e.g., Flights by Destination) Donut Charts (e.g., Ticket Status) Line Charts (e.g., Passenger Trends) Card KPIs (e.g., Total Flights, Cancelled Flights) Slicers for Airline and Date Range

🔒 Security & Automation RLS Configuration: Allows Airline A to view only its data. Data Refresh Schedule: Set to auto-refresh daily at 5 PM in Power BI Service.