Chat with us, powered by LiveChat Assignment Deliverables - submit 2 files: Written Case (Word only) and Excel document (Excel only) Project Goal: Demonstrate your business analytics skills. Your first s | Wridemy

Assignment Deliverables – submit 2 files: Written Case (Word only) and Excel document (Excel only) Project Goal: Demonstrate your business analytics skills. Your first s

Assignment Deliverables – submit 2 files: Written Case (Word only) and Excel document (Excel only)

Project Goal: Demonstrate your business analytics skills.

Your first step for this project is to identify a data set appropriate for application of analytics from Kaggle that is amenable to Excel manipulation.  The Data Set Assignment link provides more information (see other assignment link).

Here is the source for the data: https://www.kaggle.com/datasets?fileType=csv

The Project:

Apply as many analytics models and calculations (Chapters 1 – 16) as you can about your selected data, within the constraints provided. However, prioritize your insights and focus on what  senior managers care about. This project is not a calculation dump — it is a thoughtful report that uses calculations to draw insights (descriptive, predictive, prescriptive) and make conclusions that is of use to management.

The report is to senior management and should detail the insights and conclusions you have drawn from your analysis. The report needs to be an analysis (judgement of good or bad) based on the model calculation outcomes. It is necessary, but not sufficient to state and or exhibit calculation results.

The Excel document needs to exhibit the calculations in a traceable, auditable and readable form. However, keep in mind the grading for the final project is almost exclusively (90%) based on the report and its quality (see rubric) and not the Excel document.  That is, make the assumption the reader will not see the Excel document.

Summary: Pick a data set. Submit data set to Sakai. Then work the data, extensively applying analytics calculations (descriptive, predictive and prescriptive) and models using Excel, and write an interesting data driven 7 to 10 page report.  The report should be professionally formatted (tables and graphs a must, 1-inch margins), paginated, title page, section headings, coherent paragraphs, show data and come to a conclusion. The page count does not include the cover page, reference page, tables and graphs.

Within the Excel submission provide another copy of the raw data (untouched) to the first worksheet (tab).

Submit the written report and the corresponding Excel document with the calculations See the rubric for how grades are assessed.

Format: Excel and Word

Reference link : https://www.kaggle.com/datasets/mysarahmadbhat/airline-passenger-satisfaction

Final Project OPRE 605 Grading Rubric Summer 2022

Inadequate – 1(0 – 50%)

Average – 2 (75%)

Good – 3 (85%)

Excellent – 4 (95%)

Introduction

(15% or 45 points)

Does not provide adequate background and or purpose for the report.

Introductory information is adequate but clarity of objective needs development

Introductory information is clear and professionally developed

Introduction is excellent: it is clear, engaging, and thorough. As a reader, I know exactly what the report will provide

Data Analysis, Calculations, and Results Addressing Executive Objectives

(30% or 90 points)

Data analysis not connected to purpose/objectives; presentation and interpretation of results are inaccurate.

Insufficient application of concepts and calculations to address objectives identified by executive

Zero score (0) if Excel missing

Data analysis needs to be stronger but is adequate. Results of calculations stated, but not fully analyzed or interpreted.

Favors statement of results rather than interpretation and analysis

Calculations are somewhat sufficient to meet objectives – i.e. number of applied concepts and calculations

Data analysis is appropriate and relevant; presentation and analysis of data is good.

Favors interpretation and analysis rather than statement of results.

Sufficient application of concepts and calculations to address objectives

Data analysis is appropriate and relevant; presentation and analysis of data are professional, thorough, engaging, and sophisticated.

Excellent job. More than sufficient interpretation and analysis of results. Sufficient to address objectives

Conclusions and Recommendations Addressing Executive Objectives (25% or 25 points)

Inadequate summary of results of analysis and no action recommendations offered. Few insights Zero (0) score if not provided.

Non-specific summary of results provided, and a start but imprecise insights and recommendations.

Specific summary of results provided. Good insights, connections to next steps and recommendations. Realistic

Summary of results and recommendations are excellent. Demonstrates solid insights, connections to next steps and recommendations. Realistic.

Report Format and Organization **

(5% or 15 points)

Sections are poorly organized.

Organizationally the report feels messy

Formatting errors exist.

Most necessary sections included but one or two are poorly organized and organizationally needs improvement but could be better.

Formatting errors exist.

All necessary sections included but organizationally the report is professional and constructed with care.

Minimal formatting errors exist.

All necessary sections included, and effectively organized. No formatting errors exist.

Visual Supplements Integrated

(5% or 15 points)

No visual supplements such as tables or graphs included.

Failure to include may lead to a zero (0)

Supplements included (graphs, tables, exhibits) but construction needs improvement (labels, design, etc.)

Nearly enough supplements included. Formats a proper but not complete

Right number of supplements included. Provides valuable information that is clear, professionally presented, and insightful. Constructed properly

Grammar

Mechanics

Sentences and Style

(10% or 30 points)

There are numerous grammatical errors exist and impede meaning.

Report has numerous punctuation, spelling, or capitalization errors.

Sentences contains many errors and impede meaning. Style is not concise or professional.

Grammatical errors exist but generally don’t impede meaning.

Report has some punctuation, spelling, or capitalization errors.

Sentences contain some errors but do not impede meaning.

Style is generally concise and professional, but some additional editing is warranted.

Few grammatical errors exist and do not impede meaning.

Report has a few punctuation, spelling, or capitalization errors.

Sentences contain few errors that do not impede meaning. Style is concise and professional.

Both sentences and style are good. Editing and proofreading is good.

No grammatical errors exist.

Report has no punctuation, spelling, or capitalization errors.

Sentences contain no errors and are diverse and sophisticated.

Style is concise and professional.

Care taken in the editing and proofreading of the report.

Excel

(10% or 30 points)

Excel document not complete

Excel infrequently used as quantitative tool

Difficult to interpret

Zero (0) if Excel not submitted

Somewhat complete

Somewhat modifiable, traceable, auditable, and readable

Somewhat uses Excel as a powerful quantitative tool

Interpretation accessible

Mostly complete

Mostly modifiable, traceable, auditable, and readable

Mostly uses Excel’s functionality as a powerful quantitative tool

Mostly able to follow and interpret

Excellent

Modifiable, traceable, auditable, and readable

Uses Excel functionality to its full capability

Easy to follow and interpret

(100%)

** Construct the format of the report based on the report’s needs not based on the rubric

Adopted from document originally developed for WRIT 300 – Advanced Expository Writing

,

Sheet 1

Table 1
Field Description
ID Unique passenger identifier
Gender Gender of the passenger (Female/Male)
Age Age of the passenger
Customer Type Type of airline customer (First-time/Returning)
Type of Travel Purpose of the flight (Business/Personal)
Class Travel class in the airplane for the passenger seat
Flight Distance Flight distance in miles
Departure Delay Flight departure delay in minutes
Arrival Delay Flight arrival delay in minutes
Departure and Arrival Time Convenience Satisfaction level with the convenience of the flight departure and arrival times from 1 (lowest) to 5 (highest) – 0 means "not applicable"
Ease of Online Booking Satisfaction level with the online booking experience from 1 (lowest) to 5 (highest) – 0 means "not applicable"
Check-in Service Satisfaction level with the check-in service from 1 (lowest) to 5 (highest) – 0 means "not applicable"
Online Boarding Satisfaction level with the online boarding experience from 1 (lowest) to 5 (highest) – 0 means "not applicable"
Gate Location Satisfaction level with the gate location in the airport from 1 (lowest) to 5 (highest) – 0 means "not applicable"
On-board Service Satisfaction level with the on-boarding service in the airport from 1 (lowest) to 5 (highest) – 0 means "not applicable"
Seat Comfort Satisfaction level with the comfort of the airplane seat from 1 (lowest) to 5 (highest) – 0 means "not applicable"
Leg Room Service Satisfaction level with the leg room of the airplane seat from 1 (lowest) to 5 (highest) – 0 means "not applicable"
Cleanliness Satisfaction level with the cleanliness of the airplane from 1 (lowest) to 5 (highest) – 0 means "not applicable"
Food and Drink Satisfaction level with the food and drinks on the airplane from 1 (lowest) to 5 (highest) – 0 means "not applicable"
In-flight Service Satisfaction level with the in-flight service from 1 (lowest) to 5 (highest) – 0 means "not applicable"
In-flight Wifi Service Satisfaction level with the in-flight Wifi service from 1 (lowest) to 5 (highest) – 0 means "not applicable"
In-flight Entertainment Satisfaction level with the in-flight entertainment from 1 (lowest) to 5 (highest) – 0 means "not applicable"
Baggage Handling Satisfaction level with the baggage handling from the airline from 1 (lowest) to 5 (highest) – 0 means "not applicable"
Satisfaction Overall satisfaction level with the airline (Satisfied/Neutral or unsatisfied)

&"Helvetica,Regular"&12&K000000&P

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

About Wridemy

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order

Related Tags

Academic APA Writing College Course Discussion Management English Finance General Graduate History Information Justify Literature MLA