The objective of this project is to explore applying data analytics tools to address a business...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The objective of this project is to explore applying data analytics tools to address a business question/problem, and communicate insights derived from your interpretation of your analytics results. Please review the 'Introduction to the Analytics Mindset' page in the Week 10 Module for an overview of data analytics, its impact, and the 4 steps/phases of the analytics mindset. This project covers steps 3 (apply appropriate data analytics techniques) and step 4 (interpret and share the results with stakeholders). There are two parts to the project. The following is the case information and project requirements for Part 1: Background Information: A global big box retailer, Big Deals (BD), has asked your project team to assist in optimizing their product line and revenue stream. BD was one of the first major players in its industry and has grown into a market leader, typically with at least 50% of the market share. BD offers products in the following categories: Audio: car stereos and receivers Cameras: point and shoot, single-lens reflex (SLR) and video Computers: desktops, monitors, notebooks and tablets TV: LCD, LED, plasma and projection Video players: Blu-ray and DVD BD operates in most countries around the world including the following countries: Argentina, Australia, Brazil, Canada, Chile, China, Colombia, Egypt, France, Germany, India, Italy, Japan, Mexico, the Netherlands, Pakistan, Philippines, Russia, South Korea, Spain, Switzerland, United Kingdom, United States and Venezuela. BD is headquartered in the United States and management gathers competitive sales information by product type at the domestic level in the US and then collectively for all countries. The US is BD's largest market by about six fold. Below is an overview of global and US sales for the last three years. Global US 2017 sales $1,660,149,506 336,684,098 2018 sales $ 1,657,576,955 336,273,102 (Decrease)/ increase (0.15)% (0.12)% 2019 sales $ 1,537,691,760 363,796,103 (Decrease)/ increase (7.23)% 8.18% With the entry of numerous on-line retailers, BD is losing market share and its margins are shrinking. BD would like you to analyze their situation and recommend a strategy to get them back on track. Over the next few weeks, your project team works closely to interview key company personnel, analyze operations and gather data (both corporate and competitive) for further analysis. At the conclusion of the Analytics mindset case studies - Big Deals © 2018 Emst & Young Foundation (US). All Rights Reserved. SCORE No. MM4216 1 assessment, you came up with a series of questions to ask to gain insights from company data (this represents Step 1 of the analytics mindset). The questions are listed below: 1. How do the sales of each product compare with forecasts? 2. How do the sales of each product compare with prior year sales? 3. How do the sales of each product compare with the competition? 4. How do the sales of each product compare with other product sales? 5. Are there any poorly performing products in high-performing countries? 6. If there is a poorly performing product in a high-performing country, how is this product performing compared with the sales in other countries and the competition? Required: Use the BigDeals Sales Data.xlsx file provided in your assignment link. Use Microsoft Excel analytics tools (i.e. pivot tables, pivot charts, etc.) to gain insights and prepare responses for each of the six questions identified. Show the analysis/analyses for each question in separate worksheets. It is up to you to decide which data points to use to address each question. You do not have to use every data point on your project. The following is a simple example of a pivot table and chart, and related response to Question 1 based on the 2019 sales data alone. S C Ove KD 112 www. op Mantan Pom TF Revers SU T 20 21 T 23 and Sa ISTENIA 1300182287 (1860 1 151458 U 31/17 TIPOL T 1 S 121815 1423 3259 149952 121314 27 100% 1 1 17012 GU 3407792 150 01 120 317 12941517 117 131501448 1306046727 175004 1 S 112515 31209 224 2014 SA 342 14/5 2450455186 2554 T 48 Z 31542 110227 34115066 213653254 PivoTable Fields Analytical mindset case studies - Big Deals Ⓒ 2016 Emst & Young Foundation (US). All Rights Reserved. SCORE No. MM4216 ADRE Ma Sample response: Based on a comparison of sales to sales forecasts for the year 2019 (see Sales to Forecast worksheet), only tablets are meeting or exceeding sales forecasts. All other products fall short of their forecasts. However, the most concerning deviation appears in DVD players, which are significantly missing sales forecasts. 2 Prepare your responses to each question identified above in a Microsoft Word document, using complete sentences and appropriate references to the analysis (analyses) that support your answers. Provide a brief summary of the insights you've gained from your analyses and recommend a response strategy for BD. Submit your Word document and accompanying Excel file containing your analyses on Canvas. Your project will be graded based on the appropriateness of your analyses in addressing each question, and on drawing the appropriate conclusions based on the analytics results. The objective of this project is to explore applying data analytics tools to address a business question/problem, and communicate insights derived from your interpretation of your analytics results. Please review the 'Introduction to the Analytics Mindset' page in the Week 10 Module for an overview of data analytics, its impact, and the 4 steps/phases of the analytics mindset. This project covers steps 3 (apply appropriate data analytics techniques) and step 4 (interpret and share the results with stakeholders). There are two parts to the project. The following is the case information and project requirements for Part 1: Background Information: A global big box retailer, Big Deals (BD), has asked your project team to assist in optimizing their product line and revenue stream. BD was one of the first major players in its industry and has grown into a market leader, typically with at least 50% of the market share. BD offers products in the following categories: Audio: car stereos and receivers Cameras: point and shoot, single-lens reflex (SLR) and video Computers: desktops, monitors, notebooks and tablets TV: LCD, LED, plasma and projection Video players: Blu-ray and DVD BD operates in most countries around the world including the following countries: Argentina, Australia, Brazil, Canada, Chile, China, Colombia, Egypt, France, Germany, India, Italy, Japan, Mexico, the Netherlands, Pakistan, Philippines, Russia, South Korea, Spain, Switzerland, United Kingdom, United States and Venezuela. BD is headquartered in the United States and management gathers competitive sales information by product type at the domestic level in the US and then collectively for all countries. The US is BD's largest market by about six fold. Below is an overview of global and US sales for the last three years. Global US 2017 sales $1,660,149,506 336,684,098 2018 sales $ 1,657,576,955 336,273,102 (Decrease)/ increase (0.15)% (0.12)% 2019 sales $ 1,537,691,760 363,796,103 (Decrease)/ increase (7.23)% 8.18% With the entry of numerous on-line retailers, BD is losing market share and its margins are shrinking. BD would like you to analyze their situation and recommend a strategy to get them back on track. Over the next few weeks, your project team works closely to interview key company personnel, analyze operations and gather data (both corporate and competitive) for further analysis. At the conclusion of the Analytics mindset case studies - Big Deals © 2018 Emst & Young Foundation (US). All Rights Reserved. SCORE No. MM4216 1 assessment, you came up with a series of questions to ask to gain insights from company data (this represents Step 1 of the analytics mindset). The questions are listed below: 1. How do the sales of each product compare with forecasts? 2. How do the sales of each product compare with prior year sales? 3. How do the sales of each product compare with the competition? 4. How do the sales of each product compare with other product sales? 5. Are there any poorly performing products in high-performing countries? 6. If there is a poorly performing product in a high-performing country, how is this product performing compared with the sales in other countries and the competition? Required: Use the BigDeals Sales Data.xlsx file provided in your assignment link. Use Microsoft Excel analytics tools (i.e. pivot tables, pivot charts, etc.) to gain insights and prepare responses for each of the six questions identified. Show the analysis/analyses for each question in separate worksheets. It is up to you to decide which data points to use to address each question. You do not have to use every data point on your project. The following is a simple example of a pivot table and chart, and related response to Question 1 based on the 2019 sales data alone. S C Ove KD 112 www. op Mantan Pom TF Revers SU T 20 21 T 23 and Sa ISTENIA 1300182287 (1860 1 151458 U 31/17 TIPOL T 1 S 121815 1423 3259 149952 121314 27 100% 1 1 17012 GU 3407792 150 01 120 317 12941517 117 131501448 1306046727 175004 1 S 112515 31209 224 2014 SA 342 14/5 2450455186 2554 T 48 Z 31542 110227 34115066 213653254 PivoTable Fields Analytical mindset case studies - Big Deals Ⓒ 2016 Emst & Young Foundation (US). All Rights Reserved. SCORE No. MM4216 ADRE Ma Sample response: Based on a comparison of sales to sales forecasts for the year 2019 (see Sales to Forecast worksheet), only tablets are meeting or exceeding sales forecasts. All other products fall short of their forecasts. However, the most concerning deviation appears in DVD players, which are significantly missing sales forecasts. 2 Prepare your responses to each question identified above in a Microsoft Word document, using complete sentences and appropriate references to the analysis (analyses) that support your answers. Provide a brief summary of the insights you've gained from your analyses and recommend a response strategy for BD. Submit your Word document and accompanying Excel file containing your analyses on Canvas. Your project will be graded based on the appropriateness of your analyses in addressing each question, and on drawing the appropriate conclusions based on the analytics results.
Expert Answer:
Related Book For
Numerical Methods for Engineers
ISBN: 9780071244299
5th Edition
Authors: Steven C. Chapra, Raymond P. Canale
Posted Date:
Students also viewed these accounting questions
-
The norm of a linear transformation TA: Rn Rn can be defined by where the maximum is taken over all nonzero x in Rn. (The subscript indicates that the norm of the linear transformation on the left is...
-
Suppose that f: Rn R and g: Rn Rn are differentiable on Rn and that there exist r > 0 and a Rn such that Dg(x) is the identity matrix, I, for all x Br(a). Prove that there is a function h: Br(a) {a}...
-
Let 5: Rn Rn and T: Rn Rn be linear transformations with matrices A and B respectively. [Theorem 3.] (a) Show that B2 = B if and only if T2 = 7 (where T2 means T o T). (b) Show that B2 = 1 if and...
-
Concentric shells r = 20 cm and r = 30 cm are held at V = 0 and V = 50, respectively. If the space between them is filled with dielectric material ( = 3.10, a = 1012 S/m), find: (a) V, E, and D, (b)...
-
Let T and N be the tangent and normal lines to the ellipse x2/9 + y2/4 = 1 at any point P on the ellipse in the first quadrant. Let xT and yT be the x- and y-intercepts of T and xN and yN be the...
-
a. How much metabolic energy is required for a \(68 \mathrm{~kg}\) runner to run at a speed of \(15 \mathrm{~km} / \mathrm{h}\) for \(20 \mathrm{~min}\) ? b. How much metabolic energy is required for...
-
Unbalance is a fundamental cause of vibration in machinery. What frequency of interest identifies the unbalanced condition of a rotor?
-
Des Moines Power and Light has been collecting data on demand for electric power in its western subregion for only the past 2 years. Those data are shown in the table at the top of the shown below....
-
Consider a derivative (1) of salvianolic acid B, an antioxidant and free radical scavenging compound from the root of Salvia miltiorrhiza Bunge, shown below. Answer parts i.- vii. on that molecule or...
-
List the advantages and disadvantages of the three different types of business organizations.
-
Melissa purchased 300 shares of ABC Corp stock for 80,000 on June 15, 2012, On August 12, 2014, she sells her 300 shares for 45,000. On September 1 2014 she purchased 100 shares of ABC Corp for 15...
-
Nonprobability sampling assumes that some elements of the population have no chance of selection or the probability of selection can't be accurately determined. Some types of nonprobability sampling...
-
Use the formula in Example 1 to determine the sample size in Problems 5-14. The estimated prevalence is \(35 \%\), and the desired confidence level is \(98 \%\) with a margin of error of \(1 \%\).
-
What does it mean to solve a linear equation in two variables?
-
What is the difference between a non-variable interest and a variable interest?
-
In Problems 23-26, suppose that people's heights (in centimeters) are normally distributed, with a mean of 170 and a standard deviation of 5. We find the heights of 50 people. What is the variance in...
-
Assume the discount rate is 5 % What is the present value of an annual cash flow of 1 , 0 0 0 ? The first cash flow arrives in year 6 , and the final cash flow arrives in year 2 0 .
-
Describe the general ways that the revised Form 990, applicable for tax year 2008 and beyond, is different from previous versions.
-
Determine the highest real root of (x) = 2x 3 11.7x 2 + 17.7x 5 (a) Graphically (b) Fixed-point iteration method (three iterations, x 0 = 3). Note: Make certain that you develop a solution that...
-
An oscillating current in a electric circuit is described by i = 9e 1 cos(2t), where t is in seconds. Determine all values of t such that i = 3.
-
Consider the following function: (x) = x4 2x3 8x2 5x Use analytical and graphical methods to show the function has a maximum for some value of x in the range 2 x 1.
-
Henry Ford, founder of Ford Motor Company, is quoted as saying that customers could choose a car in any color as long as it was black. Things have come a long way since that timewhen customization...
-
Not long ago, New England Confectionery Company, or Necco for short, marked the production of its one trillionth candy wafer. The humble roots of Necco, the country's oldest continuously operating...
-
What is utility?
Study smarter with the SolutionInn App