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

  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

Related Questions

Module 1 – SLPEquilibrium, Supply and DemandAssignment OverviewProfessional Application with Excel Throughout the MBA program, you will have multiple

Module 1 – SLPEquilibrium, Supply and DemandAssignment OverviewProfessional Application with Excel Throughout the MBA program, you will have multiple opportunities to work with Excel using discipline-specific tools. Beyond learning to analyze data, it is crucial to apply findings for practical situations. Combining data, economic theory, and research provides hands-on practical

HRM 3302-22.02.00-5A25-S1, Human Resource Management Unit IV Journal Assignment Instructions Review the performance methods and forms discussed in the

HRM 3302-22.02.00-5A25-S1, Human Resource Management Unit IV Journal Assignment Instructions Review the performance methods and forms discussed in the textbook in Chapter 8 beginning with the How Do We Use Appraisal Methods and Forms? section. This includes the Critical-Incidents Method, Management by Objectives (MBO), Narrative Method or Form, Graphic Rating Scale

REAL WORLD APPLICATION: PLANNING AND DECISION-MAKING ASSIGNMENTINSTRUCTIONSINSTRUCTIONSSelect a technique/concept from the reading regarding Planning and

REAL WORLD APPLICATION: PLANNING AND DECISION-MAKING ASSIGNMENTINSTRUCTIONSINSTRUCTIONSSelect a technique/concept from the reading regarding Planning and Decision-Making (Cost-Volume-Profit) anddevelop a real-world application paper. Select a company that you work for now or have workedfor in the past, or a company in your community of which you have sufficient knowledge. Showhow the

You will create a 10-minute video presentation of your Final MBA Concentration: Corporate Innovation Stratasys Ltd., and post it to the Unit 8 Discussion

You will create a 10-minute video presentation of your Final MBA Concentration: Corporate Innovation Stratasys Ltd., and post it to the Unit 8 Discussion Capstone Project Presentation forum. You will comment on at least two fellow students’ presentations. Instructions: Please complete a 10-minute video presentation of your Final Capstone project