MGSC 410 Final 2024

Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

MGSC 410

Submission is via Word document only on Canvas. Include any visuals, graphs, or charts to support your answers and analysis. There is no page limit.

Your work must be your own. Do not use ChatGPT. Refer to lecture notes and posted materials on Canvas, including readings. Google may be used to research, but if you go in a different direction than what was presented in class, you will not be given credit.

Part 1 – 15 points

Q1.

What is a commercial data ecosystem? Provide some examples of commercially available data and its use in business applications.  (2 points)

Q2.

What is a business intelligence tool? What functions does it perform? Provide examples of commercially available business intelligence tools. Show examples of the output of business intelligence tools. (4 points)

Q3.

What are the principles of data visualization? Cite sources (2 points)

Q4.

What is the profile of a ‘full-stack data scientist? (2 point)

Q5.

When setting up an analytics team in a start-up environment, list some of the factors you would consider in designing, hiring, and organizing your data science team? (4 points)

Q6.

Describe a Gartner Magic Quadrant report and provide examples of the information types present in these reports. (1 point)

Part 2 – 10 points

Q7.

Using the data provided in the Excel file.

Build a model to predict transaction charges best.

Use only variables that are predictive of transaction charges.

Examine the statistical validity of the model, the variables chosen, and the coefficient of determination. Present detailed information on the validity of the model, including visualizations.

Explain what the company should do to maximize transaction values using the model output.

Use only the data provided.

Part 3 – 10 points

Q8.

Read the case study attached – DO NOT DISTRIBUTE THIS CASE STUDY BEYOND READING FOR THE FINAL.

Develop a detailed analytical plan to build a retention model for STC. Propose more than one type of model approach, and list the pros and cons to each approach.

Part 4 – 10 points

Q9.

Explain the premise of a CLV model and provide examples of potential usage in different industries. (2 points)

Q10.

What is Marketing ROI?

Why is it important?

What are some of the modeling approaches used to develop ROI analysis? Be specific on the data, name of approaches and modeling techniques used.

(3 points).