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

You will interview at least two people who belong to cultural groups other than your own and who themselves are from different cultures so that you

You will interview at least two people who belong to cultural groups other than your own and who themselves are from different cultures so that you may reflect on and analyze your intercultural communication competence as well as the importance of cultural diversity awareness. As part of your analysis, you

Research Application-Psychology is a science and gathers its information from inquiry and research studies. · To gain more experience

Research Application-Psychology is a science and gathers its information from inquiry and research studies. · To gain more experience with the science of developmental psychology, you will need to locate a peer-reviewed empirical journal article (it contains an introduction, methods, results, and discussion sections) USE THIS ONE: · Next, briefly

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 1 Knowledge Management (MGT 403) Due Date: 05/10/2024 @ 23:59 Course Name: Knowledge Management Student’s Name: Course Code: MGT403 Student’s ID Number: Semester: First

For this assignment, you will research the different ways that managers and leaders use communication to guide their organizations. Find an instance

For this assignment, you will research the different ways that managers and leaders use communication to guide their organizations. Find an instance where the organizational leader communicates directly with his or her employees, investors, or customers. Analyze the message, the channel, and the potential for feedback. Do you believe that

SLP/BUS530 Managerial Economics Consumer Behavior, Production and Cost SLP Assignment Expectations Economic Impacts for Producers This week’s case focused

SLP/BUS530 Managerial Economics Consumer Behavior, Production and Cost SLP Assignment Expectations Economic Impacts for Producers This week’s case focused on the consumer side of economics. Producers must manage more constraints in their decision-making. Session Long Project 2 ResourcesProducer Price Index (PPI) (2022)Purchasing Power (2022)The Market System as an Efficient Mechanism for Information (2022) Business

One day, while Officer Careful is sitting behind his desk, he gets a phone call from a person identifying himself as Snitch, who tells the officer, “Trust me,

One day, while Officer Careful is sitting behind his desk, he gets a phone call from a person identifying himself as Snitch, who tells the officer, “Trust me, Batman and Robin are planning to start a huge narcotics smuggling ring. They’ve already imported more than 100 kilos of cocaine and

see attachment Fields of Industrial-Organizational Psychology After you have read the content and resources of this module,

see attachment Fields of Industrial-Organizational Psychology After you have read the content and resources of this module, perform the following discussion: · Select one of the fields described in this module. · Analyze the importance of this field for the profession and how you would adapt it to our current

The body must include details of the program: 1-2 paragraphs 1. Exactly what the program is.2. Address these questions:– Who? What people will benefit?–

The body must include details of the program: 1-2 paragraphs 1. Exactly what the program is.2. Address these questions:– Who? What people will benefit?– Where? Is there a specific location or will it takeplace across the entire neighborhood?– How/what? What will happen? If it is a program,exactly what will happen in

Overview In this course, the learner-faculty connect check-in assignments will be used for discussing the Milestone One, Milestone Two, and project guidelines.

Overview In this course, the learner-faculty connect check-in assignments will be used for discussing the Milestone One, Milestone Two, and project guidelines. These are private conversations between

Chamberlain NR505NP-10882 PICOT Question Worksheet Assignment Purpose Evidence-based practice is initiated

Chamberlain NR505NP-10882 PICOT Question Worksheet Assignment Purpose Evidence-based practice is initiated by nurses and other healthcare professionals who identify questions about specific health-related interventions and the outcomes of those interventions on individuals and populations. The creation of a PICOT question helps guide evidence-based initiatives. The purpose of this worksheet is

Ethical Paper 1 6-7 pagesAs an organizational leader, one of your primary roles is establishing programs and policies that ensure the organization operates

Ethical Paper 1 6-7 pagesAs an organizational leader, one of your primary roles is establishing programs and policies that ensure the organization operates under ethical considerations and legal mandates. This responsibility includes informing employees of the organization’s code of ethics, communicating the code of ethics, providing training, and ensuring that

Complete Web Exercise 12.6 Upload your work via files as instructed. In case the link in the book does not work properly, this link will take you

Complete Web Exercise 12.6 Upload your work via files as instructed. In case the link in the book does not work properly, this link will take you directly to the hardware PDF to an external site. Once you complete the online catalog portion of this assignment, you are done,

Assessment Description As part of the capstone requirements, design an educational leadership action research project that is built as part of several

Assessment Description As part of the capstone requirements, design an educational leadership action research project that is built as part of several courses in the program of study. The topic for the project is your choice, but it must be focused on an educational issue or problem within your school

How do the depictions of rituals, symbols, and cultural assumptions govern interpretation of the world? This file is too large to display.View in

How do the depictions of rituals, symbols, and cultural assumptions govern interpretation of the world? This file is too large to display.View in new window

Your Outline should list the main point for each paragraph you plan to write. I have created a model that has 3 body paragraphs for each of the 3 body sections.

Your Outline should list the main point for each paragraph you plan to write. I have created a model that has 3 body paragraphs for each of the 3 body sections. Your outline should have at least this

As an analyst at a Policy Think Tank (choose one between – Brookings Institute, Center for American Progress, Rand Corporation, or Heritage Foundation),

As an analyst at a Policy Think Tank (choose one between – Brookings Institute, Center for American Progress, Rand Corporation, or Heritage Foundation), you must conduct research on select public accounting firms, including overview of the industry, public sentiment, and regulatory framework before and after the enactment of the Sarbanes-Oxley

In the simplest of terms, a strategic plan can be thought of as: Where are we now? Where are we going? How will we get there? The county/city manager has

In the simplest of terms, a strategic plan can be thought of as: Where are we now? Where are we going? How will we get there? The county/city manager has hired you for a special project where you have been tasked with developing a new 3-year strategic plan outline for

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