What is the most likely geographic region to target customer

Assignment Help Computer Engineering

Reference no: EM131969016

Data Analytics Assignment

Goal: To undertake a data analytics approach to solve a set of business problems that require the use of appropriately selected data processing and mining approaches.

Product: Case Study Report

Format: ReportQuestion

Length: 1500 word report.

Note: This is an individual assessment. The assessment will report the set of business problems, data required, and data mining tools selected to solve the selected problems. You are required to create the dataset required to solve the business problem.

You are required to write a report for a business case study. The case study requires you to investigate solutions for key business problems. You have to assume that you are performing a data scientist role in a commercial technology innovation organisation. You are required to use classification techniques to provide decision support and recommendations to the executives in the organisation.

This is an individual assessment and needs to be submitted electronically through SafeAssign.

Case Study

You are working as a Data Scientist in an ecommerce company. The company is a market leader with range of product segments. The main product segments are latest gadgets, books, toys, household items and clothes.

However, the company's performance especially its profitability is decreasing due to increased competition and changing customer expectations. The company has well qualified board of directors who believe in the power of data analytics in solving business problems and thus make important business decisions. Due to your data analytics skills and data science capability, the company executives have given you a special task in analysing the company's sales data for each product segment and each geographic region. The executives have requested you the following:

1. Develop the dataset for at least one product segment with at least 1000 records and with attributes such as

• product name,
• product price,
• shipping type (free or customer paid)
• monthly sales ($)
• geographic region
• No. Of customers who bought the product,
• Customer type (New or existing)

You are also allowed to add any more attributes to describe product segment

Note:You must develop your own unique and original dataset - copying a dataset from another student or from the internet will result in reduced or zero marks

2. Research any specific data mining or classification technique and propose a suitable technique or model to determine any association or relationships among the attributes.

3. Develop a predictive model to predict monthly sales for a given geographic region. You can use any of the methods such as Naive Bayes, decision trees or linear regression. You are also welcome to do a comparative analysis of all the methods you come across in your research and use the comparative analysis to justify your approach and research findings.

4. Based on your analysis, present recommendations to the board for the following business problems:

• What is the most likely geographic region to target new customers to increase sales and profit?
• Which products should be prioritised for increase in sales?
• What will be impact on product sales if free shipping is provided to all products?
• Any new innovative ideas to improve company's profitability supported by your data analytics.

Proposed Report Structure

The report should be structured using the following headings (2000 words)

1. Executive Summary
2. Table of Contents
3. List of Abbreviations and assumptions made
4. Introduction - What is the problem?
5. Research Methodology
6. Analytical Findings
7. Recommendations to the company
8. An implementation plan based on the recommendations you have provided
9. Conclusions
10. List of References
11. Appendix (E.g. Python code).

Reference no: EM131969016

Questions Cloud

Determine the relevant costs for this order : The assembly division of Davenport, Inc. is bidding on an order of 50,000 smart phones. Determine the relevant costs for this order for the assembly division

Determine the contribution margin in dollars : During the month, fixed costs were $16,800 and variable costs were 75% of sales. Determine the contribution margin in dollars, per unit and as a ratio

Prepare an income statement : Prepare an income statement, a statement of retained earnings and a balance sheet for this subsidiary in stickles

What is the market interest rate on janas debt : What is the market interest rate on Jana's debt, and what is the component cost of this debt for WACC purposes?

What is the most likely geographic region to target customer : What is the most likely geographic region to target new customers to increase sales and profit? Which products should be prioritised for increase in sales?

Compute the annual depreciation on the new equipment : Assuming that depreciation is to be computed on the straight-line basis, compute the annual depreciation on the new equipment

Prepare statement of financial affair for oregon corporation : The company expects to collect $12,000 from the accounts receivable if liquidation becomes necessary. Prepare a statement of financial affairs for Oregon

What is the impact on the market-to-book ratio : Analysts reassess The Earnings Factory's future performance as follows: growth in book value increases to 12% per year, but the ROE of the incremental book.

What is the yield of the ford stock : The Ford Motor Company stock is currently selling for $13.41 and will be paying dividends of $.60 per share. The dividend 4 years ago was $.20.

User Account

All Pages