University of North Texas Current Load Factor and The Power Bi Dashboard Worksheet

Description

Please help me write some analysis about the charts I’m gonna provide in the word file (4 in total) about the current load factor AND the PowerBI dashboard about how much Southwest Airline will lose when they underutilized Max 8 airplanes (this dashboard will be in the ppt file). The total amount of words will be around 600-700 words in total. Please message me if you need anything!1
Spring Break 2022
Load Factor Analytics/Recommendations
April 2023
Overview
Explore and analyze data to help Southwest Airlines increase its load factors, by finding
the most and least popular destinations and origins, identify routes with the highest and
lowest load factor and cross findings with the time of the flight, to identify bottlenecks
and times that load factors are very low. Identify outliers to improve the load factor.
Goals
1. Identify areas of improvement for load factor
2. Suggest recommendations to increase profitability
Specifications
Using the provided Spring Break 2022 excel file, create reports to analyze data between: aircraft
series, departure date time groups, load factors, and generalized flight data. Relevant company
information is obtained through Southwest 1stQTR statement
1stQtr 2022 Load Factor and Operating Revenue Comparison
2
Airline performance is often
measured by flight load factor
with a KPI of operating
revenue. Load Factor does
show efficiency, but it does
not show profitability and
earned revenue. As we drill
down through the data, we
want to find solutions to
increase revenues and
decrease spillage.
Airplane Series affects number of flights and load factor
700, 800, Max 8 series flights with below 4% Load Factors are costing profits. There should be a better way to reschedule
flights to decrease profitability risk and maximize Max 8 aircraft use whenever possible.
3
700, 800, Max 8 Series flights with a Load Factor of 100% should be rescheduled to make best use of the Max 8 fuel
efficiency and load capacity when possible.
Microsoft Power BI
Microsoft Power BI
Relaunch the add-in
After you install the add-in, you can launch it by choosing the add-in button on the Insert tab
On the Insert tab
Insert
My Add-ins
Need more help?
Return to your internet browser or copy this link into your browser:
https://pages.store.office.com/addinsinstallpage.aspx?rs=en-US&assetid=WA200003233&isWac=True&ui=en-US&ad=US

Purchase answer to see full
attachment

We offer the bestcustom writing paper services. We have done this question before, we can also do it for you.

Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.