It's another challenging week in the Side Hustle boot camp and as always we faced quite a number of obstacle. We however were able to accomplish our set goal for the week. This article is a brief guide on how we came about our data, how we collected it, cleaned it, visualized and analyzed it using both PowerBi and Excel.

Step 1 Download data : mavenanalytics.io/data-playground

Step 2

Importing the downloaded csv file "Airline passenger satisfaction" into Microsoft powerBi

Step 3 : Used decomposition tree to show the total number of dissatisfied and satisfied passenger

Step 4 : created a bin for age and visualized using stacked column chart by showing the "age range by satisfaction "

Note : To create a bin right click on the age and select group then you set the bin type to "Number of bins " and bin count "9"

Step 5 : created a doughnut chart which shows the satisfaction by class

Note : It was observed that the Business class are more satisfied

Step 6 : created a column chart which shows the satisfaction by type of travel and gender

Note : it was observed that the females are more satisfied than the males

Step 7 : created a column chart which shows the average rate of each airline services

Note : it was observed that the wifi services has the lowest average

Excel Analysis