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

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

Discussion Thread: Comparing Groups Respond to the following short answer questions from Morgan, Leech, Gloeckner, & Barrett textbook: D.8.9.6 In Output 9.6: (a) Describe the F, df, and p values f

Discussion Thread: Comparing Groups Respond to the following short answer questions from Morgan, Leech, Gloeckner, & Barrett textbook: D.8.9.6 In Output 9.6: (a) Describe the F, df, and p values for each dependent variable as you would in an article. (b) Describe the results in nontechnical terms for visualization 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.9.1 Is there a significant difference between

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

DISCUSSION ASSIGNMENT INSTRUCTIONS In the thread for each short-answer discussion the student will post short answers to the prompted questions. The answers must demonstrate course-related knowledge a

DISCUSSION ASSIGNMENT INSTRUCTIONS In the thread for each short-answer discussion thestudent will post short answers to the prompted questions. The answers must demonstratecourse-related knowledge and support their assertions with scholarly citations in the latest APAformat. Minimum word count for all short answers cumulatively is 200 words. or each thread thestudent

Balance Sheet versus Income Statement Part A Study the article Sample Balance Sheet and Income Statement for Small Business to answer the following questions in a 250-word essay: What is the differenc

Balance Sheet versus Income Statement Part A Study the article Sample Balance Sheet and Income Statement for Small Business to answer the following questions in a 250-word essay: What is the difference between the balance sheet and the income statement? How can the information on both statements influence your investment decision-making? FreshBooks.

QUANTITATIVE ANALYSIS: CORRELATION AND REGRESSION SPSS Questions Chapter 8 Using the CollegeStudentData.sav set (see Appendix A on how to retrieve it), do the following problems. Print your outputs af

QUANTITATIVE ANALYSIS: CORRELATION AND REGRESSIONSPSS QuestionsChapter 8Using the CollegeStudentData.sav set (see Appendix A on how to retrieve it), do the followingproblems. Print your outputs after typing your interpretations on them. Please circle the keyparts of the output that you discuss.8.1 What is the correlation between student’s height and parent’s height?

Discussion Thread: Integrating Faith and Learning Reflect on the course content and think about the level of knowledge and skill required to effectively conduct meaningful and accurate quantitative an

Discussion Thread: Integrating Faith and Learning Reflect on the course content and think about the level of knowledge and skill required to effectively conduct meaningful and accurate quantitative analysis. Reflect on the Keller book “Every Good Endeavor” and think about God’s plan for how we should handle challenging work, the