Kibata

Sign In

Our Services

Get 15% Discount on your First Order

Order Now
[rank_math_breadcrumb]

Hello. The following assignment has been done.As per the professor’s feedback, it needs to BE ADDED. Slicers for date and flavor for the dashboard.!!!! MBA 504 Module Eight Ex

  1.  Hello.   The following assignment  has  been done.As per the professor’s feedback, it needs to BE ADDED. Slicers for date  and flavor for the dashboard.!!!!                  
  2. MBA 504 Module Eight Excel Workbook Guidelines and RubricOverview

A dashboard is a collection of charts and analyses. Executive dashboards play a significant role in business intelligence. They provide vital information at a glance and a deeper understanding of an organization’s current situation. Dashboards are used as a point in time, a high-level view of a business or organization.

In this scenario, you will continue to work as a consultant trainee with the TC Ice Cream management team. The team has requested that you create a dashboard so leadership can effectively and efficiently have key insights about their sales revenue. Remember that TC Ice Cream is interested in whether specific trends are identified that can help grow its business through improved operations and sales. You are required to identify three key charts and a regression for presenting your analysis. The dashboard should depict clear insights from your analysis and findings.

Prompt

Specifically, you must address the following rubric criteria:

  1. Identify key charts for the dashboard.
    • Use your completed worksheets in the TC Ice Cream Excel Workbook to complete this step.
    • Identify three charts that you created in previous modules to include in your dashboard.
  2. Create key slicers for the dashboard. 
    • Use the “Dashboard” sheet to create the dashboard.
    • You should have three slicers for the dashboard that interact with the three charts on the dashboard sheet.
    • The slicers will enable the dashboard user to filter (slice) the data by date and flavor.
  3. Identify a key regression for the dashboard.
    • Use your completed worksheets in the TC Ice Cream Excel Workbook to complete this step.
    • Identify one regression that you created in previous modules to include in your dashboard.
  4. Create a table that summarizes the regression models created in previous modules.
    • The table should show your dependent variable, independent variable(s), the linear regression formula, p values for the independent variable, and R2.
    • The table should consist of all five regression models created.
    • You do not need to paste the entire output of the regression models.
  5. Create a dashboard that includes the following:
    • Three key charts identified from previous modules
    • One table that summarizes the identified regression from previous modules
    • Slicers that interact with the three key charts on the dashboard sheet
    • A header and title
  6. Create a PowerPoint Presentation to explain why you chose the identified charts and regression, including key visualizations and analysis to support your answers.
    • Using the three charts you created in the dashboard, along with the slicers, display the charts summarizing your specific division and flavors you have used throughout the modules.
    • Display the regression table and provide a high-level analysis. Which of the regression models have a greater impact on the quantity sold variable for the division and flavors used throughout the modules?

What to Submit

  • TC Ice Cream Excel Workbook: Submit the TC Ice Cream Excel Workbook. For this assignment, work should be completed in the “Dashboard” sheet. Do not remove any sheets from the workbook.
  • PowerPoint Presentation: Submit a PowerPoint presentation using the Module Eight 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.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Order Now

Related Questions

CASE STUDY METHODOLOGY ASSIGNMENT INSTRUCTIONS OVERVIEW Researchers describe the background of the problem to define the root problem and explain the organizational consequences – this is where you wi

CASE STUDY METHODOLOGY ASSIGNMENT INSTRUCTIONSOVERVIEWResearchers describe the background of the problem to define the root problem and explain theorganizational consequences – this is where you will ‘well-define’ your case study. The problemstatement is a foundational component of the research study. In this assignment, you will beginto craft a single case

Discussion Thread: Problem Statements and Research Questions Business Problem Information A bank is experiencing a decrease in productivity. Employees appear to be stressed as a result of unmitigated

Discussion Thread: Problem Statements and Research Questions Business Problem Information A bank is experiencing a decrease in productivity. Employees appear to be stressed as a result of unmitigated job demands. Bank leaders have tried to address the issues but their efforts have had minimal positive impact. Leaders at the bank,

This is a journal entry that must be written in your own words, no ai or plagiarism included please! Instructions below: Strategic management includes an analysis of a business’s current state. Contin

This is a journal entry that must be written in your own words, no ai or plagiarism included please! Instructions below: Strategic management includes an analysis of a business’s current state. Continuing with your research of Alphabet, you will leverage the business SWOT tool to identify and drive organizational strategic

OVERVIEW OF CASE STUDIES ASSIGNMENT INSTRUCTIONS OVERVIEW Each case study type and its design are slightly different. These differences are important for researchers to consider when selecting a case

OVERVIEW OF CASE STUDIES ASSIGNMENT INSTRUCTIONSOVERVIEWEach case study type and its design are slightly different. These differences are important forresearchers to consider when selecting a case study type most appropriate for their research.Regardless of the type or design, each case study centers around its subject and object.Researchers typically build their

In a two page Word document, summarize the concepts learned in this course. Be sure to include: The role of forecasting in decision makingRisks associated with capital budgetingHow financial ratios (

In a two page Word document, summarize the concepts learned in this course.  Be sure to include: The role of forecasting in decision making Risks associated with capital budgeting How financial ratios (analysis) assist in forecasting and budgeting Challenges in budgeting and forecasting Your paper should be in APA format

You will be using the “Repairing Customer Satisfaction” Download “Repairing Customer Satisfaction”case study for all of the assignments in this course. To complete the first assignment, you will need

You will be using the “Repairing Customer Satisfaction” Download “Repairing Customer Satisfaction”case study for all of the assignments in this course. To complete the first assignment, you will need to read the case study to develop the first progress report on your findings for the CEO. You will access the case study

Hello I need a short paper written in your own words, no AI or plagiarism please Write a 525- to 875-word response to the following prompts as your journal entry: Justify the guiding principles requ

Hello I need a short paper written in your own words, no AI or plagiarism please  Write a 525- to 875-word response to the following prompts as your journal entry:  Justify the guiding principles required for preparing effective statements that describe the mission, vision, and the core values of an organization.

Module 4 – SLPBusiness Analytics & Intelligence ReportingAssignment Overview Final Analysis **Complete Module 4 SLP before Module 4 Case** We have been working with survey data throughout class. C

Module 4 – SLPBusiness Analytics & Intelligence ReportingAssignment Overview Final Analysis **Complete Module 4 SLP before Module 4 Case** We have been working with survey data throughout class. Create a final report that can be used by industry leaders. Data analysis is transformed to business intelligence. This is where you

You will be using the “Repairing Customer Satisfaction” Download “Repairing Customer Satisfaction”case study for all of the activities in this course. In week 3 you will develop the first progress rep

You will be using the “Repairing Customer Satisfaction” Download “Repairing Customer Satisfaction”case study for all of the activities in this course. In week 3 you will develop the first progress report where you will outline the root cause(s) and create a problem statement. For this activity, you will start the process by

Module 3 – CaseCorrelation Regression AnalysisAssignment Overview Regression Analysis **Complete Module 3 SLP before Module 3 Case** This is your final data analysis project in class. You have become

Module 3 – CaseCorrelation Regression AnalysisAssignment Overview Regression Analysis **Complete Module 3 SLP before Module 3 Case** This is your final data analysis project in class. You have become very familiar with the data and have a number of findings that may assist in managerial decision-making. The goal is to

Module 3 – SLPCorrelation Regression AnalysisAssignment Overview Correlation and Scatterplots **Complete Module 3 SLP before Module 3 Case** Let us delve into Organizational Commitment. In your earlie

Module 3 – SLPCorrelation Regression AnalysisAssignment Overview Correlation and Scatterplots **Complete Module 3 SLP before Module 3 Case** Let us delve into Organizational Commitment. In your earlier research, you discovered how important this is to a company. Now, we will investigate what types of correlations exist between Organizational Commitment and

QUANTITATIVE ANALYSIS: COMPARING GROUPS WITH T TESTS, ANALYSIS OF VARIANCE (ANOVA) AND SIMILAR NON-PARAMETRIC TESTS SPSS Questions Chapter 9 Using the CollegeStudentData.sav file, do the following pro

QUANTITATIVE ANALYSIS: COMPARING GROUPS WITH T TESTS, ANALYSIS OFVARIANCE (ANOVA) AND SIMILAR NON-PARAMETRIC TESTSSPSS QuestionsChapter 9Using the CollegeStudentData.sav file, do the following problems. Print your outputs aftertyping your interpretations on them. Please circle the key parts of the output that you use foryour interpretation.Identify an example of a variable measured

The student must then post 1 reply to another student’s post. The reply must summarize the student’s findings and indicate areas of agreement, disagreement, and improvement. It must be supported with

The student must then post 1 reply to another student’s post. The reply must summarize thestudent’s findings and indicate areas of agreement, disagreement, and improvement. It must besupported with scholarly citations in the latest APA format and corresponding list of references.The minimum word count for Integrating Faith and Learning discussion

The student must then post 1 reply to another student’s post. The reply must summarize the student’s findings and indicate areas of agreement, disagreement, and improvement. It must be supported with

The student must then post 1 reply to another student’s post. The reply must summarize thestudent’s findings and indicate areas of agreement, disagreement, and improvement. It must besupported with scholarly citations in the latest APA format and corresponding list of references.The minimum word count for Integrating Faith and Learning discussion