Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
tamin
New Member

Need Help - University task

I am a student and never use power bi before. it seems very hard and difficult for me. Is anybody here who could help me please? here is the task:

 

Using Power BI adequately import and prepare the data. The focus of your assignment is to investigate the passenger segment of the business. Analyze the available data to gain insights into the following areas:

  • To gain some basic insights into the state of business in the passenger segment we would like to provide some basic stats regarding total, average, maximum, and minimum of transported passengers.
  • The company would like to continue its analysis by reporting on number of passengers and number of available seats by flight type. Also, a comparison of such data is needed based on departure/arrival countries.
  • It is believed that the number of transported passengers varies both between the years and within the years. On a monthly (quarterly) basis, what are some spotted patterns in the data?
  • Analyze the relationship between the number of passengers, number of transported mail, and the number of performed departures at the carrier level.
  • Not all offered routes are equally ‘popular’. What are the top 12 routes based on number of enplaned passengers? What other patterns can you spot on these routes?

After requirement workshops and interviews with BlueSky Airlines’ executive team you have distilled the following KPIs:

  • Load Factor %: this gives the number of enplaned passengers versus the number of available seats
  • Enplaned passengers (in millions): this gives the number of transported passengers, in millions
  • Revenue Passenger Miles (in millions): this gives the total number of miles that all passengers were transported, in millions
  • Available Seat Miles (in millions): this gives the total number of miles that all seats (including unoccupied seats) were transported, in millions
  • Market Share: this is based on transported passengers

Prepare an executive dashboard to follow the proposed KPIs. How is the company performing on different routes and countries on these KPIs? Where are some places for improvements?

4 REPLIES 4
donkyhote
New Member

Glad to hear that you found a lot of useful information on (community.fabric.microsoft). Thanks for sharing your experience!

 

Car Games

Martin125
New Member

Hello! We all do something for the first time. When it was necessary for me to write my research paper cheap of course I tried to find the best value for money. Fortunately, I succeeded. Trust me, Essay Writer is the best site for this job. Thanks to this resource, I saved my money and received the highest quality article written by one of the professional writers. I tried to provide specialists with all the necessary information about my document. I had the opportunity to make the necessary corrections to the draft document, so in the end we were able to fulfill all the requirements of my professor and I received a high score for my work.

SteveLarson
New Member

University assignments can be very difficult and time-consuming to complete. But if you use hnd assignment help, everything can be much faster. This usually works.

Anonymous
Not applicable

Hello,

I'm a PhD student at Queensland University of Technology. I worked on a similar project: Advantages of a new model for airport passenger segmentation. For this task I imported my Excel worksheets to Power Bi for data visualization. You may also want to check the Enterprise DNA (Partner showcase) with Power Bi - https://powerbi.microsoft.com/en-us/partner-showcase/enterprise-dna-understanding-your-customers-bet...  a case study that analyzes profitability and customer revenue.

Patrick

 

 

Patrick Amrein

My access page: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-import-excel-workbooks http://customwritingcompany.com

PhD thesis

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.