Our Services

Get 15% Discount on your First Order

MBA 504 Module Two Excel Workbook Guidelines and RubricOverview Data visualization is a quick, easy, and effective way to convey concepts in a universal

October 21, 2024

MBA 504 Module Two Excel Workbook Guidelines and RubricOverview

Data visualization is a quick, easy, and effective way to convey concepts in a universal manner. Visualized data helps you understand large and complex data sets easily so you can make decisions based on the analysis. It also helps you identify new patterns, trends, and correlations in the attributes.

In this scenario, you are continuing to work as a business consultant trainee with the TC Ice Cream client. Now you will take a deeper dive into the analysis, focusing on a division of your choice. The division that you select will be used for future assignments as well. The division “West North Central” cannot be used for your analysis.

After having spent time reviewing your initial discoveries, the TC Ice Cream management team has asked you to create an in-depth visualization of the data. You will be required to create multiple charts of each type: line, pie, column, and combo. Your analysis should now focus on the quantitative variables (quantity sold, advertising expenses, flavor rating, social media posts, and event promotions) and the data for the specific region you selected. Different visualizations can help one discover new aspects of the data. Examining the division data will provide further insight as you begin to identify new patterns, trends, and relationships or correlations in the key variables.

Additionally, you will create a PowerPoint presentation to present your findings for the TC Ice Cream management team. In this short presentation, you will also explain the new insights that you have gathered during your continued analysis.

Prompt

You will create multiple charts of each type: line, pie, column, and combo. Then explain the new insights that you have gathered during your continued analysis.

Specifically, you must address the following rubric criteria:

Create multiple charts to represent the division you have selected. The division “West North Central” cannot be used for your analysis. Within the TC Ice Cream Excel Workbook, use the “Division Analysis” sheet to create the following charts. It is recommended that you use pivot table filtering functionality to filter the data to the specific division you have selected.
- Create a pie chart using the qualitative variable Flavor and the quantitative variable Quantity Sold to provide a visualization of percentage overview of quantity sold by flavor for the division.
- Create a line chart (also known as a trend chart) using the qualitative variable Date and the quantitative variable Quantity Sold to provide a visualization displaying quantity sold by month for the division.
- Create a bar chart using the qualitative variable Flavor and the quantitative variable Flavor Rating to provide a visualization displaying average flavor rating by flavor.
- Create a combo chart using the qualitative variable Date (x-axis) and the quantitative variables Quantity Sold (clustered column) and Advertising Expenses (line – secondary axis).
- Create a combo chart using the qualitative variable Flavor (x-axis) and the quantitative variables Quantity Sold (clustered column) and Average Flavor Rating (line – secondary axis).
Use the Module Two PowerPoint Template to create a PowerPoint presentation that explains the identified patterns, trends, and correlations. This should include key visualizations and analysis to support your answers. The template includes specific questions to answer. Use the visualizations and data analysis you created in the “Division Analysis” sheet to support your analysis.

What to Submit

In this assignment you will submit an updated Excel file and a PowerPoint presentation.

TC Ice Cream Excel Workbook: Submit the TC Ice Cream Excel Workbook. For this assignment, work should be completed in the “Division Analysis” sheet.
PowerPoint Presentation: Submit a PowerPoint Presentation using the Module Two PowerPoint Template. If references are included, they should be cited in APA format. Consult the Shapiro Library APA Style Guide for more information on citations.

Business & Finance

Share This Post

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

Related Questions

attached Comment about this post: Adolescence is a special and forming period of life. Adolescents who experience physical, emotional, or social

attached Comment about this post: Adolescence is a special and forming period of life. Adolescents who experience physical, emotional, or social changes, such as being exposed to domestic violence, assault, or poverty may be more susceptible to psychological problems. Adolescent health and mind wellness during adolescence and adulthood depend on

IT 212 Milestone One Guidelines and Rubric Overview In Milestone One, you will: Given the provided scenario, explain the key considerations

IT 212 Milestone One Guidelines and Rubric Overview In Milestone One, you will: Given the provided scenario, explain the key considerations (must-haves) and constraints of the networking project at the �rm’s new location. Then make a well-reasoned recommendation of local area network (LAN) topology. Scenario You work for an advertising

1 2 Please select a topic from the list below Topics for Research Paper 1. Genetics and

1 2 Please select a topic from the list below Topics for Research Paper 1. Genetics and environment in schizophrenia. 2. Childhood trauma and borderline personality disorder. 3. Substance abuse and mood disorders. 4. Culture and eating disorder treatment. 5. Stigma and mental health treatment. 6. Sleep disturbances and psychiatric

SOAP Note 1 A SOAP note is a method of documentation employed by healthcare

SOAP Note 1 A SOAP note is a method of documentation employed by healthcare providers to record and communicate patient information in a clear, structured, and in an organized manner. This assignment will provide students with the necessary tools to document patient care effectively, enhance their clinical skills, and

Your assignment is to write a 4-5 page argumentative paper (not including works cited or the cover letter; and longer papers are acceptable) that addresses

Your assignment is to write a 4-5 page argumentative paper (not including works cited or the cover letter; and longer papers are acceptable) that addresses a topic of your choice affecting the United States. This assignment has two parts: an informal cover letter, and the essayYour paper should be an original work of your own, and not

Week 5 – Assignment: Identify Strategies to Address Loss of Market Advantage For this assignment, you will use this

Week 5 – Assignment: Identify Strategies to Address Loss of Market Advantage For this assignment, you will use this scenario: You were recently hired by Hospital G to fill the vacancy of a long-term chief executive officer (CEO) who retired. In a meeting with your new executive leadership team to

Student Self-Assessment of Participation-Engagement-Attendance and Motivational Speech a) A check-in paper is a chance for you to tell me what you want from

Student Self-Assessment of Participation-Engagement-Attendance and Motivational Speech a) A check-in paper is a chance for you to tell me what you want from this class and this experience. You should

Planning Guide Medical/Health Center PART 2: CURRICULUM COMPONENTS

Planning Guide Medical/Health Center PART 2: CURRICULUM COMPONENTS Setting: Medical/Health Center Identifying Curriculum Components For your Part 2: Curriculum Components Module Assignment, you will select the overarching philosophies, theories, and frameworks that will shape your nursing staff educational program. When creating these curriculum components, consider the following: · What is

need help getting ideas together Project Management MGMT

need help getting ideas together Project Management MGMT 6100-01 Fall Semester 2022 Writing Assignment 1 Scope Statement Due Date August 23, 2022 – 11:59 PM Points 200 (20% of overall course grade) Aligns with Learning Objective: Identify key elements of a project scope statement and understand why a complete scope

Community Partnerships and Resources Assessment Student Name:_________________________________

Community Partnerships and Resources Assessment Student Name:_________________________________ Date:____________________________ Section I: Utilize this template to guide a short interview with your liaison. Use substantive examples to support each section. Partnership Template Date and Time of Interview Who is your liaison? (Name, title, credentials, etc.) Describe the role they are in currently

BUS2303-19.01.02-5B24-S3 Part I: Take a moment and introduce yourself to the class, sharing your status and what you hope to obtain from the course. Part

BUS2303-19.01.02-5B24-S3 Part I: Take a moment and introduce yourself to the class, sharing your status and what you hope to obtain from the course. Part II: Describe your personality within a work environment, discussing how you deal with such things as teamwork, stress, and time management. Knowing that not all

Watercolor painting is popular because the materials are simple and cleaning up is easy, but it can be challenging because the artist must plan ahead. The

Watercolor painting is popular because the materials are simple and cleaning up is easy, but it can be challenging because the artist must plan ahead. The key to making a good watercolor is to anticipate where the white areas will be because once painted, the color cannot be removed. The

Identify 2 teaching strategies that you would use to teach fractions to a group of students whose native language is not English. (ESOL)

Identify 2 teaching strategies that you would use to teach fractions to a group of students whose native language is not English. (ESOL) Describe your strategies in two sentences. Tell how you would assess the ESOL students in one sentence. Discussion Board Rubric Candidates demonstrate mastery as follows: Exceeded –

Which of the following best summarizes the passage? A Volcanic rocks and mountains are found in Santa Cruz. B Chert has a heavy concentration of silicon

Which of the following best summarizes the passage? A Volcanic rocks and mountains are found in Santa Cruz. B Chert has a heavy concentration of silicon and oxygen. C Sand is tiny bits of worn-out rock made mostly of oxygen and silicon. D A few common elements make most of

select a different piece of art or architecture from this week’s reading to write about. See Attachment for the architecture What is the best way to

select a different piece of art or architecture from this week’s reading to write about. See Attachment for the architecture What is the best way to present this ancient piece of art? What presentation will give today’s viewers the clearest and most honest picture of the past? Should we present

Description Using your own words, give three differences between the Gantt Chart and Network Diagram. Briefly explain how to assess the economic

Description Using your own words, give three differences between the Gantt Chart and Network Diagram. Briefly explain how to assess the economic feasibility of an information system development project, mentioning the different types of benefits and costs that can be considered in the analysis process. Discuss the difference between top-down

Please read and summarize one article on Tarasoff’s duties. Share how you would integrate the article’s findings into your practice with your

Please read and summarize one article on Tarasoff’s duties. Share how you would integrate the article’s findings into your practice with your classmates and professors.

Desmos can be a powerful tool in a math classroom. The Desmos calculator tool is a user-friendly resource to help students better understand a wide array of

Desmos can be a powerful tool in a math classroom. The Desmos calculator tool is a user-friendly resource to help students better understand a wide array of connected concepts like tables, graphs, and

Our Services

MBA 504 Module Two Excel Workbook Guidelines and RubricOverview Data visualization is a quick, easy, and effective way to convey concepts in a universal

Share This Post

Related Questions

Use Our 6 Free Tools