You are hired by JJ Office Supper, an office supply

You are hired by JJ Office Supper, an office supply company with almost ten years of experience in the business and have expanded its business nationwide.In the last four years, the company has tried to introduce a new ERP system and seen the value of data.As a new hire, the COO (Chief Operational Officer) Kim Smith met your team leader and assigned you a task. They would like you to analyze the sales data and create a report that will help the management team to monitor the essential business activities and make sound decisions backed up by data. This task will help you to understand the business better. They also want to see if they hired the right person.Please follow the instruction below to complete the task:

  1. Download the data file (MiniProject_1_DataSet.xlsx) in the attachment;
  2. Read each table, and understand what kinds of information are available in each of them;
  3. Considering the following questions:
    • Think about what kind of information may be interesting to your audience? What kind of question may they use your report to find answers to?
    • What are essential measures that matter to the management team? e.g., Sales Revenue? Sales Quantity? Cost? Profit margin? Are they available in the data file, or do you need to create a calculated field?
    • What dimensions should be used? e.g., Date? Location? Customer? Product? Manufacturer?
  4. Create at least three data visualization graphs or tables using Tableau. Each graph should include different dimensions and measures combination;
  5. Take a screenshot of each visualization and insert them into a new MS Word document;
  6. Write a short paragraph (less than one hundred words for each paragraph) under each graph to:
    • Describe the meaning of the graph
    • Explain why it matters to the business
    • Explain what attempts you have made to reduce your audience’s cognitive load and help them focus on the essential information?
  7. Submit both MS Word document and Tableau file (save the Tableau file in *.twbx format). The file name should be: MiniProject1_globalID

Bonus task:

  1. Download the data file (MiniProject_1_BonusPoint_DataSet.xlsx) in the attachment;
  2. Connect the data to the Tableau file you created in the task above; (Hint: You can add new columns in the data file if needed)
  3. Create a visualization to demonstrate the relationship between sales target and actual sales.
  4. Take a screenshot of this visualization and insert it into the MS Word document created in the task above;
  5. Write a short paragraph (less than one hundred words) to:
    • Describe the comparison between the sales target and actual sales;
    • What are the potential causes for the gap between target and reality;
    • Explain what attempts you have made to reduce your audience’s cognitive load and help them focus on the essential information?

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Submit a 2-3-page paper in which you continue to build

Submit a 2-3-page paper in which you continue to build the marketing plan for your t-shirt company in the apparel industry. This paper will consist of three sections: B2B or B2C business, wants and needs, and societal marketing. Your paper needs to be in APA format, include a title page,

Strategic human resource management: Analyze and assess the following

In the Final Project for this course, you demonstrate your understanding of the major topics presented by applying these concepts to a government or non-profit organization of your choice. In your Final Project, you analyze and assess the following areas of the organization based on the processes and principles related to human

Week 6 Assignment 2 Write your introduction here. Include one

   Week 6 Assignment 2 Write your introduction here. Include one (1) paragraph (not more than 6 lines of text) that explains what your paper will discuss. Much of your introduction may be taken from the assignment instructions (in your own words). Read all assignment resources to understand what should

Overview Realizing that an organization’s CMMI level affects an organization’s

Overview Realizing that an organization’s CMMI level affects an organization’s success on requests for proposals (RFPs), your CIO wants to get the software development processes to CMMI level 3. Your organization has started developing software applications and database systems for their customers. The CIO wants to ensure that the software

Carlos Del Rey decided to open a fast-food Mexican restaurant

Carlos Del Rey decided to open a fast-food Mexican restaurant and signed a franchise contract with a national chain called La Grande Enchilada. Under the franchise agreement, Del Rey purchased the building, and La Grande Enchilada supplied the equipment. The contract required the franchisee to strictly follow the franchisor’s operating

I have created a simple app that displays the current

I have created a simple app that displays the current weather using an API. I need to now use Tkinter Notebook to create a Tab that says ‘Current’ and display the current weather under that tab. I tried creating the tab in the view.py file named current_frame but I am

The purpose of this assignment is to analyze how an

The purpose of this assignment is to analyze how an organization’s quality and improvement processes contribute to its risk management program. This assignment builds on the Risk Management Program Analysis – Part One assignment you completed in Topic 1 of this course. Assume that the sample risk management program you

HATE CRIME BY JOYCE KING

 CONNOR INDICATED IN A CHAT THAT THE TEXT NEEDED, HATE CRIME BY JOYCE KING IS AVAILABLE TO WRITERS. You are expected to provide enough detail and thoughtfulness in your responses to show me that you read and comprehended the content. 1. Did James Byrd, Jr. do anything to precipitate this

Instructions After reading Chapter 7, review Case Activity: A New

  Instructions After reading Chapter 7, review Case Activity: A New Campaign to Combat Heart Disease on page 134 of your text and answer the questions from the Writing Prompt section. Be specific to receive full credit. Case Activity: A New Campaign to Combat Heart DiseaseThe American Heart Association (AHA)

Select and discuss one Do, and one Don’t related to

Select and discuss one Do, and one Don’t related to physical activity during pregnancy. (#1_Do and Do Not) Evaluate the statement that “no level of alcoholic beverage intake is safe or advisable during pregnancy.” (#2_Alcoholic Intake) What is the relationship between childhood obesity and chronic diseases? (#3_Childhood Obesity) Explain why

Research any article related to your topic based on The

  Research any article related to your topic based on The New Jim Crow: Mass Incarceration in the Age of Colorblindness. This process will be similar to the one you used for Enhancement Module #1. Researching a Topic Using the Pro Quest Database Go to the Evergreen Valley College Library

After reading the Marketing Management article located in the Module

After reading the Marketing Management article located in the Module 3: Lecture Materials & Resources, write a summary of the article and answer the questions at the end of the article. Submission Instructions: The paper is to be clear and concise and students will lose points for improper grammar, punctuation,

Instructions This week, you will prepare a white paper. Explain

 Instructions This week, you will prepare a white paper.  Explain cultural competence for administrators who will act as advocates and policy makers. Consider how social work administrators might apply their leadership roles to increase cultural competency and advance social and economic justice within their organizations. Address the following in your white

Researching Business Disciplines A successful academic career usually includes teaching,

Researching Business Disciplines A successful academic career usually includes teaching, research, and service. In pursuing a doctorate in business, you are choosing a field rich with well-grounded theory and practical application of your interests. For this week’s research paper, choose one of the business disciplines, such as accounting, human resources,

Reply to: The main difference between experiments and non-experimental methods

Reply to:   The main difference between experiments and non-experimental methods is that in experiments, researchers could manipulate the independent variable. Experiments are a scientific approach that manipulates one or more control variables to measure their defect on the dependent variables. In non-experimental methods, researchers must rely on interpretation and observations to conclude and it does not involve

Imagine you are an information security manager in a medium-sized

Imagine you are an information security manager in a medium-sized organization. Your CIO has asked you to prepare a case analysis report and presentation on establishing internal controls in cloud computing. The CIO has seen several resources online that discuss the security risks related to cloud-based computing and storage. One

Explain how the nurse leader who conducts an external analysis

Explain how the nurse leader who conducts an external analysis of competitors lays the groundwork for internal organizational analysis and development of a competitive advantage. Expectations Initial Post: Due: Thursday, 11:59 pm PT Length: A minimum of 250 words, not including references Citations: At least one high-level scholarly reference in