ITM209 MSU Worldwide Data Analysis Using Tableau

Anonymous

Question Description

This homewrk base on the software called Tableau and also need write a 2 page memo

Alll the instruction for this assignment are in the word file called "Assignment 2 spring 2019" and the excel file realated to the Tableau

Please read the instruction carefully and make sure you can handle this order before you take it!

Thank you.

Unformatted Attachment Preview

Assignment II - Tableau ITM 209 Spring 2019 Assignment #2: Business Analytics: Tableau Due: Due 8 AM on March 20/21, 2019 Points: 95 points (15 point penalty if less than 8 hours late, 35 point penalty if less than 24 hours late, 55 point penalty if more than 24 hours late.) Purpose: To evaluate your ability to: 1) Understand Tableau functionality in solving business questions and 2) Explain your results to upper management in an executive memo. Submit: 1. A “Tableau Packaged Workbook” (.twbx) that you used to perform the analysis which includes all five Tableau worksheets and the Tableau Dashboard. Submit your Tableau saved results file to your TA’s Dropbox on D2L. 2. An “executive memo” (in the form of a three-page word document; Two-page memo, One page dashboard) describing the context of your analysis with Tableau solutions, your interpretation and evaluation of the solution results, and your corresponding conclusions and recommendations based on your evaluation. Page three of your memo will be your Tableau Dashboard. Submit the document to your TA’s Dropbox on D2L. Use the required template shown on page 7 of this document. “Memo” should use Times New Roman Font, 12 pt., 1-inch margins, and double spacing. Points will be deducted for poor writing, so write well! 1 Assignment II - Tableau Scenario: The Worldwide Commerce Consulting Scenario: You work for a large consulting firm, and your manager has asked you to analyze the performance of your new client, Worldwide Commerce, from 2011 to 2014. Worldwide Commerce sells three categories of products: technology, furniture and office supplies. Within these three categories, there are many different types of products, ranging from smart phones to microwaves. These products are sold around the world to different countries and through different markets. Each transaction is recorded in the worldwide_commerce.xlsx file. The Excel file contains an extensive amount of information regarding the transaction information for Worldwide Commerce, including Order ID, Customer and Product Name. The following is an outline of how the data is organized in the Worldwide Commerce data set. This data outline is the same outline you used for Tableau In-class Practice II. You will use the analysis you performed for Tableau In-Class Practice II as the starting point for your analysis for Assignment #2. Outline of Worldwide Commerce Data Set Product Categories • • • Technology o Phones o Accessories o Machines Furniture o Bookcases o Tables o Art o Furnishings o Appliances o Chairs Office Supplies o Copiers o Binders o Fasteners o Envelopes o Paper 2 Assignment II - Tableau Market • US • APAC • Africa • Canada • EMEA • EU • LATAM Ship Mode • Same Day • First Class • Second Class • Standard Class Order Priority • Critical • High • Medium • Low Your Role: You are the director of data analytics at the consulting firm you are working at. You realize that there are problems with the current business approach of Worldwide Commerce, and you need to come up with insights and alternative solutions. Management wants a detailed plan for the changes in business to improve revenue and reduce costs, and they want hard numbers and facts to back up any proposal you submit. Remembering your time in ITM 209, you recall that Tableau allowed you to use data analytics to provide high quality analysis of businesses. You decide to use Tableau to investigate the current business operations and to assess the quality impacts of several changes you have in mind. Based upon your findings, you will make a recommendation to management about your specific marketing and operations improvements. 1 Assignment II - Tableau Set-Up Instructions for Tableau (You may wish to refer to the Instructions Section of In-Class Practice Activities II): You have got a sense of how to use Tableau, so let’s prepare for assignment #2 and get oriented for this assignment. 1. Retrieve the Tableau Assignment #2 instructions from D2L and read the instructions and the model scenario thoroughly. 2. Use the worldwide_commerce.xlsx data file from the Assignment #2 folder as a starting point. Please refer to the Getting Started with Tableau section of In-Class Practice Activities II to download this file, save it on your Desktop and P: Drive, launch Tableau, and load this file into Tableau to prepare for Assignment #2. 3. You will be using the knowledge gained and the steps we did in In-Class Practice Activities II to complete Assignment #2. Questions for Assignment #2: The following business questions will guide you through your analysis using the Tableau data analytics software. (You may wish to refer to the Performing Data Analytics Using Tableau section of In-Class Practice Activities II) 1) Profits by Category Which product sub-category is being sold frequently, yet bringing Worldwide Commerce poor profits? Hint: Refer to Bar Chart and Quick Filter functionality noted in In-Class II, question one. 2) Sales by Month What do the sales of Worldwide Commerce look like for each month of the year? Which months have downward spikes in sales? Note: Include an option for the user to see Year-to-Year Growth in this visualization as well. Hint: Refer to Line Graph and Year Over Year Growth functionality noted in InClass II, question two. 2 Assignment II - Tableau Questions for Assignment #2 (continued): 3) Furniture Sales Margins Which sub-category under the Furniture category has the worst sales margins? Under this sub-category, which month has the lowest profits? Hint: Refer to the Heat Map and Filtering functionality noted in In-Class II, question three. Remember, you may need to create a Calculated Field as well. 4) Market Analysis In terms of the number of items sold, where is there currently an emerging market for Worldwide Commerce? Hint: Refer to Bar Chart and Multi-Data functionality noted in In-Class II, question five. 5) Profit by Country Which country in the EU has the lowest profits for Worldwide Commerce? Hint: Refer to the Filled Maps, Map Layers and Filtering functionality noted in InClass II, question four. 6) Profit Distribution Which product sub-category held negative profits for Worldwide Commerce? In which quarter were those profits the most negative? Hint: Refer to the Running Total and Waterfall functionality noted in InClass II, question seven. 7) Worldwide Analysis A summary highlighting your findings would be very useful to your manager. Create a Dashboard containing your visualization from questions 1, 2 and 4 and a Quick Filter applied to all worksheets. Be sure to include this Dashboard figure/graph in your executive memo. 3 Assignment II - Tableau Hint: Refer to the Dashboard and Filtering functionality referred to in In-Class II, question eight to allow the user to filter by all categories of product sold by Worldwide Commerce. Important: Tableau Assignment #2 Results (after each Tableau session) should be saved to the Desktop and to your P: drive after completion! Describing Tableau Results in an Executive Memo The results from your analysis will be summarized in an executive memo. Be sure to include the results from each question within your memo. You should lead the executive through a “story” of how you approached the analysis using Tableau to explain your findings. You are leading your executive through the same path of discovery that you used in answering all of the business questions. Be sure to include the dashboard into the executive memo and refer to the dashboard in your memo. Encourage your executive to view the Tableau worksheet results and graphs and encourage your executive to actually utilize the Tableau dashboard and dashboard filter within your memo. Here are a few key points to guide you with your memo: 1) After you have completed the business analytics and answered the analysis questions, what insights can you share regarding the use of Tableau for data analytics? 2) You will need to write an executive memo to the management explaining your analysis using Tableau. Be sure to include the Tableau dashboard graphs/figures noted above in your executive memo. 3) These questions may help you to write a better memo a. Who will be reading your memo? Do they really know the process, or do you need to help explain it (at a higher level)? b. What should you say about the analysis in Assignment #2 so that your description provides more information than can be obtained by simply reading the numbers in the database? c. What are your recommendations and what is your argument on why your recommendation will create the most value? 4 Assignment II - Tableau 4) The following outline may be useful for your executive memo: a. Background Information b. Results Using Tableau (be sure to include results from all questions in Assignment #2). Include the requested Tableau dashboard graphs & figures. Describe the dashboard figure in your memo and encourage the executive to “experiment” with the dashboard using the Tableau file itself. c. Be sure to reference the Assignment #2 Solutions to all questions in your analysis and encourage your executive to view the Tableau results in the six worksheets. d. Explain all results from the questions in your memo and perform additional analysis using Tableau that you think would be useful. e. Summary of Findings and Recommendations. 5) Use the following Memo Template: MEMO TEMPLATE (This is a required template for your memo) Date: March 20/21, 2019 TO: Worldwide Commerce Management Subject: Results and Recommendations of Worldwide Commerce Data Analytics ADD YOUR CONTENT HERE Your Name Data Analytics Director 5 Assignment II - Tableau Submitting Your Assignment: 1) Once your Tableau Workbook has been completed, save the file as a Tableau Packaged Workbook. Go to File > Save As. Change the default File Type to “Tableau Packaged Workbook (*.twbx)” by using the dropdown menu. 2) Submit: A “Tableau Packaged Workbook” (.twbx) that you used to perform the analysis which includes all six Tableau worksheets and the Tableau Dashboard. Submit the file to your TA’s dropbox on D2L. 3) Submit: An “executive memo” (in the form of a three-page word document) describing the context of your analysis with Tableau solutions, your interpretation and evaluation of the solution results, and your corresponding conclusions and recommendations based on your evaluation. Page three of your memo will be your Tableau Dashboard. Submit the document to your TA’s dropbox on D2L. Grading for Assignment #2 will be based on: 1) Correct answers of ALL questions, including the Tableau dashboard 2) Quality of writing and grammar 3) Discussion and rationale for recommendations using the results from Assignment #2 questions 4) Reasoning behind conclusion 5) Academic Integrity Points breakdown 10 points 35 points 30 points 20 points Grading Requirements Correct & complete Tableau file submission Correct solution results to Assignment #2 questions, including the Tableau dashboard Reasoning within Memo  Introduction and Context Setup  Recommendation on what to do with your analysis results (reasoning behind the recommendation)  Conclusion Memo quality  Narratives: Interpreting your results  Quality of writing 6 Row ID 31192 40936 28879 46630 3484 30191 32543 29601 28932 50411 21209 38411 31278 39465 32452 6449 30187 20674 10745 22515 29651 24859 15359 41838 46219 38178 30934 21667 8753 31033 32299 32246 20867 16587 25671 20408 48022 6826 28557 48565 Order ID IN-2012-86369 CA-2012-116638 ID-2012-28402 PL-2012-7820 MX-2014-165309 IN-2011-10286 CA-2011-168494 IN-2012-48240 IN-2014-11231 UP-2011-8610 IN-2014-30110 US-2013-102239 IN-2012-86698 CA-2014-107174 CA-2011-136567 MX-2014-111941 IN-2011-10286 IN-2011-19351 IT-2011-5629016 IN-2012-23782 ID-2013-31720 IN-2014-78900 ES-2013-3939561 AJ-2013-2640 LH-2014-5390 CA-2012-137113 IN-2011-86278 ID-2013-17055 MX-2014-154935 IN-2013-81112 CA-2012-124891 US-2014-110576 ID-2013-58642 ES-2012-4108483 ID-2013-10636 IN-2014-13597 UP-2011-5440 MX-2011-146584 IN-2012-26274 ZA-2011-8980 Order Date Ship Date Ship Mode 4/14/2012 4/18/2012 Standard Class 1/28/2012 1/31/2012 Second Class 4/19/2012 4/22/2012 First Class 8/8/2012 8/10/2012 First Class 9/5/2014 9/8/2014 First Class 12/17/2011 12/20/2011 First Class 12/12/2011 12/14/2011 Second Class 5/25/2012 5/28/2012 Second Class 12/16/2014 12/19/2014 First Class 11/9/2011 11/11/2011 First Class 8/26/2014 8/27/2014 First Class 5/6/2013 5/7/2013 First Class 5/7/2012 5/7/2012 Same Day 11/7/2014 11/14/2014 Standard Class 12/20/2011 12/21/2011 First Class 4/9/2014 4/13/2014 Standard Class 12/17/2011 12/20/2011 First Class 6/17/2011 6/19/2011 First Class 5/30/2011 6/2/2011 First Class 12/26/2012 12/26/2012 Same Day 5/1/2013 5/4/2013 Second Class 12/3/2014 12/7/2014 Standard Class 1/21/2013 1/24/2013 Second Class 1/23/2013 1/27/2013 Standard Class 1/28/2014 1/30/2014 Second Class 12/1/2012 12/5/2012 Second Class 10/6/2011 10/11/2011 Standard Class 8/24/2013 8/26/2013 Second Class 9/11/2014 9/18/2014 Standard Class 8/1/2013 8/4/2013 Second Class 7/31/2012 7/31/2012 Same Day 11/29/2014 12/3/2014 Standard Class 2/21/2013 2/22/2013 First Class 6/18/2012 6/20/2012 Second Class 1/7/2013 1/13/2013 Standard Class 11/3/2014 11/7/2014 Standard Class 6/3/2011 6/5/2011 First Class 1/21/2011 1/27/2011 Standard Class 2/27/2012 3/4/2012 Standard Class 9/8/2011 9/10/2011 Second Class Customer ID MB-18085 JH-15985 AJ-10780 AB-600 VD-21670 PB-19210 NP-18700 GP-14740 CS-11845 DW-3480 LA-16780 LW-16990 NC-18625 AB-10060 PS-19045 DM-12955 PB-19210 BW-11110 TC-21295 NC-18340 JS-16030 JF-15190 JG-15160 JL-5835 JC-6105 TW-21025 NH-18610 HJ-14875 RB-19795 TS-21205 RH-19495 RB-19795 PK-19075 SJ-20500 CD-12280 AC-10450 CC-2550 HL-15040 BT-11530 DB-3360 12080 43590 5306 20428 33864 6415 189 26986 42837 39080 37936 7666 32310 32859 3875 38165 48487 6479 36923 16022 46524 26337 10377 7046 12827 22056 49790 39294 41154 12230 34781 40518 31211 5991 13705 10183 49268 13532 39765 28516 25245 ES-2014-4107155 SF-2013-8920 MX-2014-117051 IN-2014-53427 CA-2014-123967 US-2014-168046 MX-2013-148453 ID-2011-66475 AU-2011-0 CA-2013-162236 CA-2011-108609 MX-2013-105585 US-2012-126214 US-2014-102890 MX-2011-134705 US-2013-126452 RS-2011-7040 MX-2013-140382 CA-2011-126683 ES-2014-2648154 MO-2011-6660 IN-2011-47596 ES-2012-3032254 MX-2014-118332 ES-2014-5714196 ID-2013-76534 CG-2013-4000 US-2014-105998 CA-2012-164301 IT-2011-3911927 CA-2011-124688 CA-2014-103212 IN-2014-80559 MX-2014-137211 ES-2012-5149849 US-2013-156713 SA-2012-730 ES-2014-1753356 US-2013-164196 ID-2014-48849 IN-2013-60700 12/29/2014 4/29/2013 10/12/2014 5/9/2014 11/2/2014 10/25/2014 12/20/2013 8/29/2011 9/2/2011 11/5/2013 10/31/2011 7/25/2013 12/21/2012 7/1/2014 5/4/2011 8/22/2013 8/30/2011 2/26/2013 9/29/2011 8/11/2014 12/24/2011 10/19/2011 8/30/2012 3/24/2014 6/14/2014 5/31/2013 2/18/2013 11/4/2014 3/26/2012 12/26/2011 8/27/2011 10/14/2014 12/4/2014 11/21/2014 11/10/2012 12/20/2013 6/25/2012 5/29/2014 11/12/2013 11/28/2014 11/28/2013 12/31/2014 4/30/2013 10/15/2014 5/15/2014 11/4/2014 10/25/2014 12/22/2013 9/5/2011 9/2/2011 11/7/2013 11/2/2011 7/28/2013 12/24/2012 7/1/2014 5/8/2011 8/29/2013 8/30/2011 3/1/2013 10/1/2011 8/14/2014 12/28/2011 10/24/2011 9/2/2012 3/28/2014 6/17/2014 6/5/2013 2/23/2013 11/6/2014 3/30/2012 12/31/2011 8/29/2011 10/15/2014 12/8/2014 11/22/2014 11/13/2012 12/22/2013 7/1/2012 6/1/2014 11/18/2013 12/5/2014 11/30/2013 Second Class First Class First Class Standard Class Second Class Same Day First Class Standard Class Same Day Second Class Second Class First Class Second Class Same Day Standard Class Standard Class Same Day First Class Second Class First Class Second Class Standard Class Second Class Standard Class Second Class Standard Class Second Class First Class Standard Class Standard Class First Class First Class Standard Class First Class First Class First Class Standard Class Second Class Standard Class Standard Class Second Class CD-11920 JB-5400 TB-21250 LT-16765 SF-20200 GR-14560 CR-12730 BM-11575 AG-675 ER-13855 AJ-10780 HE-14800 JS-15880 SG-20470 XP-21865 SC-20230 JK-5730 SM-20005 PP-18955 ME-17320 JF-5415 PO-19195 SH-20635 NF-18385 AF-10870 VG-21805 MB-7305 CR-12580 EB-13840 KN-16390 CC-12610 MH-18025 PS-18970 LC-16885 TC-20980 CR-12730 MS-7830 DL-13315 AS-10285 ST-20530 MC-17845 36756 25862 25602 38354 20542 27525 9121 22551 4203 24711 36928 49747 10780 4020 25407 14954 20937 5005 2682 424 1702 24278 5668 2550 12134 27564 46934 35007 23577 24255 25857 21553 39745 20605 29248 8818 15648 38173 2333 9960 23408 CA-2014-116680 IN-2014-47806 ID-2012-38363 CA-2013-165330 ID-2012-31118 ID-2012-39875 MX-2014-120159 IN-2014-78396 US-2014-122420 IN-2012-29522 CA-2011-127614 IZ-2012-4950 ES-2014-5617990 MX-2014-114874 ID-2013-13086 IT-2011-1939979 IN-2012-28528 MX-2014-112459 MX-2014-164889 MX-2014-106901 US-2011-121664 IN-2014-48625 US-2014-154781 MX-2013-132206 ES-2013-5482499 IN-2011-73531 IR-2012-1390 CA-2014-113670 ID-2014-33358 ID-2012-27450 ID-2012-56402 IN-2014-20499 CA-2014-125451 ID-2013-13422 ID-2012-55359 MX-2012-142174 ES-2011-5444769 US-2013-121013 MX-2012-124611 MX-2011-109169 ID-2013-10006 9/5/2014 5/17/2014 9/14/2012 12/12/2013 12/26/2012 4/25/2012 6/26/2014 3/24/2014 12/4/2014 10/25/2012 2/12/2011 8/28/2012 9/11/2014 3/11/2014 2/9/2013 5/12/2011 10/1/2012 3/28/2014 9/8/2014 10/17/2014 9/15/2011 4/1/2014 10/9/2014 12/10/2013 2/5/2013 6/25/2011 9/4/2012 10/16/2014 6/23/2014 11/16/2012 6/10/2012 3/26/2014 10/24/2014 12/20/2013 3/28/2012 12/26/2012 6/6/2011 9/6/2013 9/3/2012 7/28/2011 6/21/2013 9/7/2014 5/22/2014 9/16/2012 12/12/2013 12/28/2012 4/27/2012 6/28/2014 3/30/2014 12/7/2014 10/25/2012 2/16/2011 8/30/2012 9/12/2014 3/14/2014 2/15/2013 5/14/2011 10/7/2012 3/30/2014 9/12/2014 10/20/2014 9/17/2011 4/5/2014 10/10/2014 12/12/2013 2/10/2013 7/2/2011 9/8/2012 10/18/2014 6/27/2014 11/17/2012 6/17/2012 3/29/2014 10/25/2014 12/23/2013 4/2/2012 12/28/2012 6/10/2011 9/11/2013 9/6/2012 7/30/2011 6/28/2013 Second Class Second Class First Class Same Day Second Class Second Class First Class Standard Class Second Class Same Day Standard Class First Class First Class First Class Standard Class First Class Standard Class First Class Second Class First Class First Class Standard Class First Class Second Class Second Class Standard Class Standard Class First Class Standard Class First Class Standard Class Second Class First Class First Class Standard Class First Class Standard Class Standard Class Second Class Second Class Standard Class PK-19075 DO-13435 JC-16105 WB-21850 TH-21550 TP-21130 RK-19300 MG-18145 SC-20575 CC-12475 NF-18385 DL-3330 LW-16825 SG-20470 SV-20815 MP-18175 CA-12775 DC-13285 JE-15745 LS-17200 SC-20725 JF-15415 RB-19330 KN-16450 BE-11410 JS-16030 CP-2085 RS-19765 SB-20290 AH-10075 KD-16270 GW-14605 AH-10075 AG-10765 BD-11635 CC-12430 EH-14005 MM-17920 FM-14290 ST-20530 JE-15745 30572 45896 11789 24115 25451 23954 28676 27123 33160 33108 27591 33774 31760 3294 24662 7807 38946 2337 4671 18766 15167 7665 35566 24184 17806 29869 44850 32107 4582 49515 20958 30360 11435 25980 16066 31674 38785 5986 11881 33586 32813 IN-2013-83688 MO-2014-4970 ES-2011-2592061 ID-2011-59293 ID-2011-69142 IN-2013-34198 IN-2011-31769 IN-2013-69128 US-2013-100839 CA-2011-132612 IN-2011-70570 CA-2014-102750 CA-2013-109869 US-2014-110597 ID-2013-18714 MX-2012-135174 CA-2012-101889 MX-2013-138653 MX-2014-123575 IT-2014-2542510 ES-2013-2966180 MX-2012-103954 US-2014-124821 ID-2012-67707 IT-2013-2634279 ID-2013-15963 EG-2014-5430 CA-2011-151995 MX-2014-156615 SA-2012-4510 IN-2011-49234 IN-2012-82918 IT-2014-5786031 IN-2014-46616 IT-2012-5303768 US-2014-134481 US-2012-134558 MX-2013-167696 ES-2013-5002794 CA-2014-115154 CA-2014-148446 6/30/2013 9/17/2014 9/16/2011 11/4/2011 7/1/2011 12/26/2013 12/22/2011 10/23/2013 10/14/2013 6/9/2011 8/ ...
Purchase answer to see full attachment

Tutor Answer

Spartacus
School: New York University

See attached:)

Worldwide Economics Data Analytics using Tableau
Student’s Name
Institution of Affiliation
Date

DATE:
FROM: Your Name
TO:

Worldwide Commerce Management

Subject:

Results and Recommendations of Worldwide Commerce Data Analytics

Introduction
The tableau is a great visual analytics software that is used to give a visual representation of world
economies data using different types of tools hence giving an effective understanding and in-depth
insight of the underlying data and the corresponding trends (Variation). Analytical tools such as
bar graphs, line graphs, and heat maps are used to elucidate variations existing between different
variables corresponding to the world economies data.
1) The products subcategories analysis with respect to prices;

The chart indicates the significant effect of prices on the sales of the product subcategories.
Copiers and the phones are the variables with t...

flag Report DMCA
Review

Anonymous
Goes above and beyond expectations !

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors