Hello? Thank you for taking the time to complete the technical interviews thus far to explore?Data?Analysis opportunities with Ca
Hello
Thank you for taking the time to complete the technical interviews thus far to explore Data Analysis opportunities with Capital One. I have enjoyed speaking with you and look forward to advancing you forward to complete our Data Challenge as the next step in this process.
The Data Challenge (attached) will give you an opportunity to showcase your skills and abilities in 3 areas that align with how we challenge our Data Analysts at Capital One. We need great people to join our team developing software data products across these key areas:
- Builder Mindset: Leverages creative and adaptive problem solving to selecting the right tool for the job; seeks automated and efficient solutions to manual or repetitive processes.
- Data Management: Strategically leads efforts to systematically evaluate, and document; monitors our data in a sustained and organizationally recognized way.
- Business Intent: Translates business needs into actionable solutions or data products; effectively communicate results to stakeholders and technical partners.
During the challenge, you will be asked to conduct some representative data manipulation, visualization, and analysis tasks using publicly available data analytic technologies. Below you will find attached all of the documents and data sets required as part of this challenge. Also attached are the instructions to guide you through the Data Challenge and more information about how you should think about choosing your toolkit.
Please note that the Data Challenge is not timed. You will be judged on the quality of the work you submit and not on the time spent to complete the challenge. We ask that you return the project within 10 days and we recommend planning for about 8-10 hours to complete the challenge. There are a number of dimensions of quality that are described in the attached instructions, but in brief, we are looking for efficient, repeatable, and well-documented solutions.
We encourage the reuse of code when appropriate. If you include code directly in your submission that was written by someone else (not including imported modules), please be sure to provide proper attribution; include the URL, text, author, etc. in the code comments.
Dataset Metadata
| Dataset Name | Description |
| Airport_Codes | Information on airports and includes airport code, city, country, and coordinates |
| Flights | Flights data for Q1 2019 and includes date, origin, destination, distance, flight number, and occupancy rate |
| Tickets | Sample tickets data for Q1 2019 and includes itinerary details and fare information. Consider round trips only for your analysis. |
Airport Codes Metadata
| Field Name | Description |
| TYPE | The type of the airport, valid value like: small_airport, medium_airport, heliport, etc. |
| NAME | The name of the airport |
| ELEVATION_FT | Elevation of the airport from the sea level |
| CONTINENT | The continent airport belongs to |
| ISO_COUNTRY | The country of the airport |
| MUNICIPALITY | The city or town of the airport |
| IATA_CODE | An airport code is a three-letter geocode designating many airports and metropolitan areas around the world, defined by the International Air Transport Association (IATA). |
| COORDINATES | Longitude and latitude coordinates of the airport |
Flights Metadata
| Field Name | Description |
| FL_DATE | Flight Date (yyyy-mm-dd) |
| OP_CARRIER | Operating commercial carrier Flight code |
| TAIL_NUM | Tail Number is the aircraft registration number for the aircraft used (similar to VIN number for cars). |
| OP_CARRIER_FL_NUM | Operating commercial carrier Flight number |
| ORIGIN_AIRPORT_ID | Origin Airport, Airport ID. An identification number assigned by US DOT to identify a unique airport. |
| ORIGIN | Origin Airport, International Air Transport Association (IATA) Airport Code |
| ORIGIN_CITY_NAME | Origin Airport, City Name |
| DEST_AIRPORT_ID | Destination Airport, Airport ID. An identification number assigned by US DOT to identify a unique airport. |
| DESTINATION | Destination Airport, Operating commercial carrier Flight code (IATA )Airport Code |
| DEST_CITY_NAME | Destination Airport, City Name |
| DEP_DELAY | Difference in minutes between scheduled and actual departure time. Early departures show negative numbers. |
| ARR_DELAY | Difference in minutes between scheduled and actual arrival time. Early arrivals show negative numbers. |
| CANCELLED | Cancelled Flight Indicator (1=Flight is cancelled). Cancelled flights should be excluded |
| AIR_TIME | Flight Time, in Minutes |
| DISTANCE | Distance between Origin and Destination Airports in Miles |
| OCCUPANCY_RATE | Occupancy rate of the flight |
Tickets Metadata
| Field Name | Description |
| ITIN_ID | Unique identifier for the itinerary |
| YEAR | Year of the Itinerary |
| QUARTER | Quarter Number (1-4) for the Itinerary |
| ORIGIN | Origin Airport Code, International Air Transport Association Airport Code (IATA) which is unique for each airport |
| ORIGIN_COUNTRY | Country of the Origin Airport |
| ORIGIN_STATE_ABR | Origin Airport, State abbrevations. |
| ORIGIN_STATE_NM | Origin Airport, State Full Name |
| ROUNDTRIP | Round Trip Indicator (1= Round Trip and 0 = One Way). Consider only round trips for your analysis. |
| REPORTING_CARRIER | 2 character Reporting Airline Carrier codes |
| PASSENGERS | Number of Passengers on the itinerary |
| ITIN_FARE | Itinerary Fare Per Person. Itinerary fare represents the whole round trip fare if ROUNDTRIP = 1. If ROUNDTRIP = 0, then the itinerary fare represents the one-way ticket fare. |
| DESTINATION | Destination Airport Code, International Air Transport Association Airport Code (IATA) which is unique for each airport |
,
| TYPE | NAME | ELEVATION_FT | CONTINENT | ISO_COUNTRY | MUNICIPALITY | IATA_CODE | COORDINATES |
| heliport | Total Rf Heliport | 11.0 | US | Bensalem | -74.93360137939453, 40.07080078125 | ||
| small_airport | Aero B Ranch Airport | 3435.0 | US | Leoti | -101.473911, 38.704022 | ||
| small_airport | Lowell Field | 450.0 | US | Anchor Point | -151.695999146, 59.94919968 | ||
| small_airport | Epps Airpark | 820.0 | US | Harvest | -86.77030181884766, 34.86479949951172 | ||
| closed | Newport Hospital & Clinic Heliport | 237.0 | US | Newport | -91.254898, 35.6087 | ||
| small_airport | Fulton Airport | 1100.0 | US | Alex | -97.8180194, 34.9428028 | ||
| small_airport | Cordes Airport | 3810.0 | US | Cordes | -112.16500091552734, 34.305599212646484 | ||
| small_airport | Goldstone /Gts/ Airport | 3038.0 | US | Barstow | -116.888000488, 35.350498199499995 | ||
| small_airport | Williams Ag Airport | 87.0 | US | Biggs | -121.763427, 39.427188 | ||
| heliport | Kitchen Creek Helibase Heliport | 3350.0 | US | Pine Valley | -116.4597417, 32.7273736 | ||
| closed | Cass Field | 4830.0 | US | Briggsdale | -104.344002, 40.622202 | ||
| small_airport | Grass Patch Airport | 53.0 | US | Bushnell | -82.21900177001953, 28.64550018310547 | ||
| heliport | Ringhaver Heliport | 25.0 | US | Riverview | -82.34539794921875, 28.846599578857422 | ||
| small_airport | River Oak Airport | 35.0 | US | Okeechobee | -80.96920013427734, 27.230899810791016 | ||
| small_airport | Lt World Airport | 700.0 | US | Lithonia | -84.06829833984375, 33.76750183105469 | ||
| heliport | Caffrey Heliport | 957.0 | US | Hiram | -84.73390197753906, 33.88420104980469 | ||
| heliport | Kaupulehu Heliport | 43.0 | US | Kailua/Kona | -155.980233, 19.832715 | ||
| small_airport | Delta Shores Airport | 2064.0 | US | Clark Fork | -116.21399688720703, 48.145301818847656 | ||
| small_airport | Goltl Airport | 3359.0 | US | McDonald | -101.395994, 39.724028 | ||
| heliport | Bailey Generation Station Heliport | 600.0 | US | Chesterton | -87.122802734375, 41.644500732421875 | ||
| small_airport | Hammer Airport | 840.0 | US | Polo | -89.5604019165039, 41.97840118408203 | ||
| heliport | St Mary Medical Center Heliport | 634.0 | US | Hobart | -87.2605972290039, 41.51139831542969 | ||
| small_airport | Hayenga's Cant Find Farms Airport | 820.0 | US | Kings | -89.1229019165039, 40.02560043334961 | ||
| small_airport | Hayden Farm Airport | 1100.0 | US | Gardner | -94.93049621582031, 38.72779846191406 | ||
| small_airport | Robbins Roost Airport | 1265.0 | US | Stanford | -84.61969757080078, 37.409400939941406 | ||
| heliport | Shell Chemical East Site Heliport | 15.0 | US | Gonzales | -90.980833, 30.191944 | ||
| heliport | Ac & R Components Heliport | 600.0 | US | Chatham | -89.70559692382812, 39.66529846191406 | ||
| small_airport | Lejeune Airport | 12.0 | US | Esterwood | -92.42939758300781, 30.13629913330078 | ||
| small_airport | Slater Field | 45.0 | US | Federalsburg | -75.75379943847656, 38.75709915161133 | ||
| heliport | Dow Chemical Heliport | 588.0 | US | Ludington | -86.41670227050781, 43.94940185546875 | ||
| small_airport | Battle Lake Municipal Airport | 1365.0 | US | Battle Lake | -95.70030212402344, 46.29999923706055 | ||
| small_airport | Cooper Flying Service Airport | 970.0 | US | Alba | -94.412399291992, 37.202800750732 | ||
| closed | Sands Ranch Airport | 2600.0 | US | Havre | -109.705002, 48.537498 | ||
| small_airport | Bucks Airport | 105.0 | US | Bridgeton | -75.1852035522461, 39.473201751708984 | ||
| small_airport | North Raleigh Airport | 348.0 | US | Louisburg | -78.37139892578125, 36.085201263427734 | ||
| heliport | Colgate-Piscataway Heliport | 78.0 | US | New Brunswick | -74.47460174560547, 40.52090072631836 | ||
| seaplane_base | Cliche Cove Seaplane Base | 96.0 | US | Beekmantown | -73.3698057, 44.8118612 | ||
| small_airport | Weiss Airfield | 1000.0 | US | West Bloomfield | -77.49970245361328, 42.90010070800781 | ||
| small_airport | Exit 3 Airport | 785.0 | US | Wauseon | -84.14219665527344, 41.59090042114258 | ||
| heliport | Miami Valley Hospital Heliport | 905.0 | US | Dayton | -84.1874008178711, 39.74530029296875 | ||
| small_airport | Gull Bay Landing Airport | 960.0 | US | Sandsprings | -96.217693, 36.198598 | ||
| heliport | Steel Systems Heliport | 195.0 | US | Salem | -123.12999725341797, 44.932899475097656 | ||
| heliport | R J D Heliport | 402.0 | US | Coatesville | -75.74690246582031, 39.94889831542969 | ||
| small_airport | Ferrell Field | 1301.0 | US | Mercer | -80.211111, 41.2995 | ||
| closed | Thomas Field | 815.0 | US | Loysville | -77.365303, 40.3778 | ||
| small_airport | Mc Kenzie Bridge State Airport | 1620.0 | US | Mc Kenzie Bridge | -122.088996887, 44.183200836199994 | ||
| small_airport | Flying O Airport | 150.0 | US | Sumter | -80.26719665527344, 34.0093994140625 | ||
| small_airport | Homan Field | 1590.0 | US | Gary | -96.498897, 44.809158 | ||
| heliport | Sw Region Faa Heliport | 598.0 | US
Collepals.com Plagiarism Free Papers Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers. Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS Why Hire Collepals.com writers to do your paper? Quality- We are experienced and have access to ample research materials. We write plagiarism Free Content Confidential- We never share or sell your personal information to third parties. Support-Chat with us today! We are always waiting to answer all your questions.  All Rights Reserved Terms and Conditions |