{"id":854,"date":"2025-12-15T05:11:50","date_gmt":"2025-12-15T05:11:50","guid":{"rendered":"https:\/\/olgamironczuk.pl\/?p=854"},"modified":"2026-01-23T10:18:06","modified_gmt":"2026-01-23T10:18:06","slug":"analiza-satysfakcji-pasazerow-linii-lotniczych","status":"publish","type":"post","link":"https:\/\/olgamironczuk.pl\/en\/analiza-satysfakcji-pasazerow-linii-lotniczych\/","title":{"rendered":"Airline Passenger Satisfaction Analysis"},"content":{"rendered":"
\n
\n
\"\"<\/figure>\n<\/div><\/div>\n\n\n\n
\n

Project: <\/strong>Airline Passenger Satisfaction Analysis
Tools: <\/strong>Excel (PivotTables, Charts), VBA, Conditional Formatting
Description: <\/strong>An analytical project based on an airline passenger satisfaction survey covering 19,652 responses. The analysis focuses on identifying the factors that influence the overall travel rating and the differences in satisfaction across passenger segments.
Objective:<\/strong> Understanding which aspects of the journey have the greatest impact on passenger satisfaction and identifying areas that require improvement to enhance the overall customer experience.
Data: <\/strong>Training materials (dataset provided as part of the course).
Repository:<\/strong> \"GitHub\" See on GitHub <\/a><\/p>\n<\/div>\n<\/div>\n\n\n\n\n\n\n\n

\n\n\n\n

Introduction<\/h2>\n\n\n\n

Oceny satysfakcji pasa\u017cer\u00f3w pokazuj\u0105 nie tylko subiektywne wra\u017cenia z podr\u00f3\u017cy, ale tak\u017ce jako\u015b\u0107 proces\u00f3w obs\u0142ugi i przebiegu lotu. Ten projekt powsta\u0142 jako \u0107wiczenie analityczne i mia\u0142 na celu uporz\u0105dkowan\u0105 analiz\u0119 ankiet pasa\u017cerskich oraz identyfikacj\u0119 wzorc\u00f3w, kt\u00f3re wp\u0142ywaj\u0105 na og\u00f3ln\u0105 ocen\u0119 lotu.<\/p>\n\n\n\n

The dashboard was designed to present satisfaction not as a single average, but as a set of segment-dependent relationships. The analysis explores how ratings vary by travel class, customer type, purpose of travel, demographics, and delays. The focus was on creating a clear and restrained visual design that supports interpretation and comparison across groups, rather than reducing the results to a single metric.<\/p>\n\n\n\n

The project covered the full data preparation process and the development of an interactive analytical tool in Excel.<\/p>\n\n\n\n

Data<\/h2>\n\n\n\n
    \n
  • Scope of analysis: <\/strong>It includes 19,652 survey responses.<\/li>\n\n\n\n
  • Data source:<\/strong> The data comes from the training dataset \u201cSky Is The Limit\u201d, provided as part of the course. The materials did not include a publicly available primary data source.<\/li>\n\n\n\n
  • The data was provided in a tabular format and included, among others:<\/strong>\n
      \n
    • Passenger demographic information<\/li>\n\n\n\n
    • Customer type<\/li>\n\n\n\n
    • Type and purpose of travel<\/li>\n\n\n\n
    • Travel class<\/li>\n\n\n\n
    • Flight distance<\/li>\n\n\n\n
    • Delays<\/li>\n\n\n\n
    • oceny poszczeg\u00f3lnych element\u00f3w podr\u00f3\u017cy, takich jak komfort, obs\u0142uga, boarding czy WiFi.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n

      Process<\/h2>\n\n\n\n

      1) Data preparation <\/strong>and modeling in Excel<\/strong><\/p>\n\n\n\n

        \n
      • The analysis was conducted in Excel using worksheets that document each stage of the process.<\/li>\n\n\n\n
      • The key steps included cleaning and standardizing the survey data, creating derived variables, restructuring rating fields into a format suitable for factor analysis, and building supporting tables for Top 3 and Bottom 3 comparisons. Maintaining a consistent aggregation logic was essential so that all visualizations were based on the same metric definitions.<\/li>\n\n\n\n
      • The visualizations were based on pivot tables designed to enable dynamic filtering and comparison across segments.<\/li>\n<\/ul>\n\n\n\n

        2) Visualization and interaction in the dashboard<\/strong><\/p>\n\n\n\n

          \n
        • The dashboard was designed as an exploratory tool that supports interpretation and comparison, rather than as a static report.<\/li>\n\n\n\n
        • The structure includes an overview page showing overall satisfaction and demographics, as well as a factor analysis page presenting ratings of travel components and comparisons between segments and the overall score.<\/li>\n\n\n\n
        • I used KPI tiles, column and line charts, a donut chart, and a radar chart that shows the profile of a selected segment against the overall average.<\/li>\n\n\n\n
        • The results can be filtered using slicers. In addition, I implemented a VBA-based button to reset all filters.<\/li>\n\n\n\n
        • The layout and color scheme were selected with a focus on readability, comparability, and visual consistency.<\/li>\n<\/ul>\n\n\n\n

          Results<\/h2>\n\n\n\n
            \n
          • Analiza pokaza\u0142a niski og\u00f3lny poziom satysfakcji pasa\u017cer\u00f3w oraz silne r\u00f3\u017cnice mi\u0119dzy segmentami. Widoczny by\u0142 du\u017cy wp\u0142yw klasy podr\u00f3\u017cy na poziom zadowolenia, a tak\u017ce istotny spadek satysfakcji wraz ze wzrostem op\u00f3\u017anie\u0144. R\u00f3\u017cnice by\u0142y r\u00f3wnie\u017c wyra\u017ane mi\u0119dzy podr\u00f3\u017cami s\u0142u\u017cbowymi i prywatnymi.<\/li>\n\n\n\n
          • The lowest-rated areas were Wi-Fi, the booking process, and punctuality.<\/li>\n\n\n\n
          • Dashboard umo\u017cliwia szybkie por\u00f3wnanie segment\u00f3w oraz identyfikacj\u0119 element\u00f3w podr\u00f3\u017cy, kt\u00f3re najsilniej obni\u017caj\u0105 ocen\u0119 lotu.<\/li>\n<\/ul>\n\n\n\n

            Reflections<\/h2>\n\n\n\n
              \n
            • The biggest challenge was not the visualization itself, but maintaining a consistent analytical logic across multiple segmentation dimensions. It was crucial to define metrics consistently, ensure comparability of results across charts, and strike a balance between detail and readability.<\/li>\n\n\n\n
            • Projekt ma charakter demonstracyjny, ale pokazuje spos\u00f3b my\u015blenia analitycznego oraz podej\u015bcie do projektowania dashboardu jako narz\u0119dzia wspieraj\u0105cego interpretacj\u0119 i decyzje.<\/li>\n<\/ul>\n\n\n\n
              <\/div>\n\n\n\n
              \"\"<\/figure>\n\n\n\n
              \"\"<\/figure>\n\n\n\n
              \"\"<\/figure>","protected":false},"excerpt":{"rendered":"

              Projekt: Analiza satysfakcji pasa\u017cer\u00f3w linii lotniczychNarz\u0119dzia: Excel (tabele przestawne, wykresy), VBA, formatowanie warunkoweOpis: Projekt analityczny oparty na ankiecie satysfakcji pasa\u017cer\u00f3w, obejmuj\u0105cej 19 652 odpowiedzi. Analiza koncentruje si\u0119 na identyfikacji czynnik\u00f3w wp\u0142ywaj\u0105cych na og\u00f3ln\u0105 ocen\u0119 podr\u00f3\u017cy oraz r\u00f3\u017cnicach w satysfakcji mi\u0119dzy segmentami pasa\u017cer\u00f3w.Cel: Zrozumienie, kt\u00f3re elementy podr\u00f3\u017cy maj\u0105 najwi\u0119kszy wp\u0142yw na zadowolenie pasa\u017cer\u00f3w oraz wskazanie obszar\u00f3w wymagaj\u0105cych poprawy w celu…<\/p>","protected":false},"author":1,"featured_media":856,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,21,22],"tags":[],"class_list":["post-854","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-projekty","category-vba"],"_links":{"self":[{"href":"https:\/\/olgamironczuk.pl\/en\/wp-json\/wp\/v2\/posts\/854","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/olgamironczuk.pl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/olgamironczuk.pl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/olgamironczuk.pl\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/olgamironczuk.pl\/en\/wp-json\/wp\/v2\/comments?post=854"}],"version-history":[{"count":2,"href":"https:\/\/olgamironczuk.pl\/en\/wp-json\/wp\/v2\/posts\/854\/revisions"}],"predecessor-version":[{"id":969,"href":"https:\/\/olgamironczuk.pl\/en\/wp-json\/wp\/v2\/posts\/854\/revisions\/969"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/olgamironczuk.pl\/en\/wp-json\/wp\/v2\/media\/856"}],"wp:attachment":[{"href":"https:\/\/olgamironczuk.pl\/en\/wp-json\/wp\/v2\/media?parent=854"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/olgamironczuk.pl\/en\/wp-json\/wp\/v2\/categories?post=854"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/olgamironczuk.pl\/en\/wp-json\/wp\/v2\/tags?post=854"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}