Data Analytics I: Milestone Two Guidelines and Rubric
Question
Data Analytics I: Milestone Two Guidelines and Rubric
Overview: Milestone Two is centered on the goals of the data analysis plan.
For this milestone, you will refer to the scenario described in the Final Project Document. You will also refer to the three data sets that are available for your analysis. They can be found in the Airport Data file and are described in the Final Project Document.
Prompt: In analyzing the situation facing Austin Air, identify the company’s business objectives and discuss ways you can measure, on an ongoing basis, how Austin Air is doing in terms of reaching its goals.
In your response, address the following critical elements:
a. What are the goals of your data plan? How do they align with the company’s overall business objectives?
b. How will you measure progress toward these goals? Guidelines for Submission: The paper must be one to two pages in length and must use double spacing, 12-point Times New Roman font, one-inch margins, and APA-style citations.
BACKGROUND INFORMATION:
Worldwide, the airline industry is growing very quickly. Nigeria has the largest market of air travel in Africa, and this has attracted major players from all over the world. European airlines have dominated the Nigerian market for a long time for the following reasons:
– They have several strategies that exceed customers’ expectations.
– They have the financial resources, expertise, and reputation in the airline industry.
– They have the institutional processes to get constant feedback and comments daily from customers. These European airlines have won numerous local and international awards, and they are the world’s fastest growing airlines.
Scenario: A successful Nigerian billionaire, Sir Austin Emmanuel, is considering entry into the global aviation industry to expand his company, Austin Air. He is planning to introduce several marketing strategies that will exceed customers’ expectations, reduce cost, offer competitive ticket pricing, and capture a large chunk from the market share of the European carriers. He has hired you as a consultant to assist him in deciding locations, countries, airports, and flight routes.
Three data sets (on airports, airlines, and routes) are available for your analysis. They can be found in the Airport Data file and are described below.
| Airports. Airport ID | This contains 6,977 airport entries across the globe as of January 2012. Each entry consists of the information below. Unique identifier for this airport. |
| Name | Name of airport. |
| City | Main city served by airport. |
| Country | Country or territory where airport is located. |
| IATA/FAA | Three-letter FAA code for airports located in the United States. Three-letter IATA code, for all other airports. Blank if not assigned. |
| ICAO | Four-letter ICAO code. Blank if not assigned. |
| Latitude | Decimal degrees, usually to six significant digits. Negative is south; positive is north. |
| Longitude | Decimal degrees, usually to six significant digits. Negative is west; positive is east. |
| Altitude | Measured in feet. |
| Time Zone | Hours offset from UTC. Fractional hours are expressed as decimals (e.g., India is 5.5). |
| DST | Daylight saving time. One of E (Europe), A (United States/Canada), S (South America), O (Australia), Z (New Zealand), N (None), or U (Unknown). |
Airlines. This contains 5,888 airlines as of January 2012. Each entry contains the information below.
Airline ID Unique identifier for this airline.
Name Name of airline.
Alias Alias of airline. For example, All Nippon Airways is commonly known as “ANA.”
IATA Two-letter IATA code, if available.
ICAO Three-letter ICAO code, if available.
Callsign Airline callsign.
Country Country or territory where airline is incorporated.
Active “Y” if the airline is or has until recently been operational, “N” if it is defunct. This field is not reliable. In particular, major airlines that stopped flying long ago but have not had their IATA code reassigned (e.g., Ansett/AN) will incorrectly show as “Y.”
Routes. This contains 59,036 route entries of 531 airlines between 3,209 airports as of January 2012. The data set contains the information below.
Airline Two-letter (IATA) or three-letter (ICAO) code of the airline.
Airline ID Unique identifier for airline.
Source Airport Three-letter (IATA) or four-letter (ICAO) code of the source airport.
Source Airport ID Unique identifier for source airport.
Destination Airport Three-letter (IATA) or four-letter (ICAO) code of the destination airport.
Destination Airport ID Unique identifier for destination airport.
Codeshare “Y” if this flight is a codeshare (that is, not operated by airline but another carrier). Empty otherwise.
Stops Number of stops on this flight (“0” for direct).
Equipment Three-letter codes for plane type(s) generally used on this flight, separated by spaces.
The following critical elements must be addressed in your final project submission:
Goal Development
a. What are the goals of your data plan? How do they align with the company’s overall business objectives?
b. How will you measure progress toward these goals?
Milestones
Milestone Two: Goal Development
In task 2-2, you will identify the business objectives of the company in the given scenario. How do you plan to determine whether the goals can be met using the existing data? How can you measure, on an ongoing basis, how the company is doing in terms of reaching its goals?