EC Global Superstore Data for Creation of Visualizations Excel Worksheet

User Generated

avznfvyr

Business Finance

Emerson College

Description

Data and creative design help communication managers to make informed decisions in communications planning, budgeting and optimization of media touchpoints. This assignment will provide each student the opportunity to practice interactive data analysis and decision making. The assignment challenges each student to use the data associated with the tableau software to create three visualizations, and an INTERACTE DASHBOARD that inform decisions on how to spend the company’s advertisement budget.The assignment is accompanied by useful Tableau links that show how to complete different tasks, and sample tableau projects. There are 3 parts to this assignment. See the instructions below.

Part 1: creation of visualizations (3 points)

Please use the Global Superstore data attached to the tableau software to create two visualizations and an interactive Dashboard. Based upon your analysis, advice Global Superstore how to allocate its communications budget moving forward. Your visualization should show the following (a) sales by product category; (b) sales by month; and (c) sales by zip code. This means you are required to create 3 different graphs/charts that answer these questions.

Part 2: creation of a Dashboard (2 points)

Create an interactive Dashboard that show the charts/graphs you created in one platform and properly label each. Please pay attention during the Tableau workshop on Thursday, March 26.

Part 3:Analysis and recommendation (5 points)

This is the descriptive and critical component of the visualizations and dashboard you created. Please describe the visualizations created and the implications for the company’s advertising efforts. Please advise Global Superstore on the following:

  1. What products should receive the highest advertising dollars and why?
  2. Which regions/zip codes should the company concentrate its advisement efforts and why?
  3. Which months should receive the highest advertisement efforts and why? Think about frequency and effective frequency theory.

(d) Share the steps you took in the creation of your analysis and recommendation. This background will put your recommendation in proper perspective, and help your company/stakeholders grasp the importance of your recommendation.

(e) What obstacles did you encounter in the creation of the visualizations and dashboards, and how did you resolve the obstacles?

(f) What lessons did you learn from completing this task.

Length: The length for the written component is maximum of 2 pages double spaced, please include your graphs to your analysis.

Draft 1 is 2 points

Please see Link touseful Tableau resources: http://onlinehelp.tableau.com/current/pro/desktop/en-us/dataview_examples.html

Sample projects

Tableau Resources:

Unformatted Attachment Preview

Tv Fev 125% 缩放 显示 添加页面 插入 表格 图表 形状 媒体 批注 Tableau Assignment Rubric Part 1: Visualization Title /3 point 0 1 2 Included a Title that represent your work/ visualizations created 0 1 Created at least three different visualizations and captioned or labelled each accurately. 2 Part 2: Created a Dashboard /2 points 0 1 2 3 4 5 Created an interactive Dashboard that reflect your visualizations Included a title that accurately reflect your dashboard Part 3: Description/Recommendation for the Company /4 points 0 1 2 3 4 5 6 Described the visualizations and dashboard created Clearly stated the purpose of the charts and dashboard Based upon the analysis, clearly stated your recommendations for the company Stated the lessons learned from the analysis Explained how charts/dashboard was created, how the data was analyzed Highlighted the obstacles in the creation of the dashboard and charts Included a title that accurately reflect the plan Technical Merit Paper clearly organized: Proper Identification at the upper left-hand corner /1 points 0 1 Paper clearly organized: The different sections specified and clearly labeled 0 1 Conformed to formatting instructions and length 28244 0 1 2 Conformed to standards of apron ... SA . MacBook Pro 8 显示 共享 窗口 帮助 7 daxiei2 T V 图表 形状 ** 125% 缩放 添加到面 插入 表格 Included a title that accurately reflect the plan 媒体 批注 Technical Merit /1 points 0 1 Paper clearly organized: Proper Identification at the upper left-hand corner 0 1 Paper clearly organized: The different sections specified and clearly labeled Conformed to formatting instructions and length limit 0 1 2 0 1 2 3 4 Conformed to standards of appropriate university writing (e.g., grammar, punctuation, spelling, clarity, sentence structure, proper expression, etc.) Submitted on time to Canvas on the due date References If information was borrowed from a source, the necessary citation information was included Draft 1 Yes No (No Credit for Assignment–Plagiarism) 2points /12 points TOTAL Other Comments: : 244 A MacBook Pro
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

At...


Anonymous
Goes above and beyond expectations!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags