Identify a key regression for the dashboard

Assignment Help Business Management

Reference no: EM133763396

Assignment: Module

Overview

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:

Identify key charts for the dashboard.

Use your completed worksheets in the TC Ice Cream Excel Workbook to complete this step.

A. Identify three charts that you created in previous modules to include in your dashboard.

B. 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.

A. Identify a key regression for the dashboard.

B. Use your completed worksheets in the TC Ice Cream Excel Workbook to complete this step.

C. Identify one regression that you created in previous modules to include in your dashboard.

D. Create a table that summarizes the regression models created in previous modules.

1. The table should show your dependent variable, independent variable(s), the linear regression formula, p values for the independent variable, and R2.

2. The table should consist of all five regression models created.

3. You do not need to paste the entire output of the regression models.

Create a dashboard that includes the following:

Three key charts identified from previous modules

One table that summarizes the identified regression from previous modules

1. Slicers that interact with the three key charts on the dashboard sheet
2. A header and title

A. Create a PowerPoint Presentation to explain why you chose the identified charts and regression, including key visualizations and analysis to support your answers.

B. 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.

C. 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?

Reference no: EM133763396

Questions Cloud

What is the oldest source used by the primary source : What is the oldest source used by the primary source? Are there any journals that you see that are cited more than once?

Reducing their psychosocial stress reactions : A client with social anxiety disorder is exploring new treatments for reducing their psychosocial stress reactions.

What are tertiary intervention for arthritis patient : What are tertiary intervention for arthritis patient: Moderate and severe joint pain can make it harder for people to do daily activities and affect quality

Community health nursing for your local community : What changes can you make in your current role to better suit your definition of community health nursing for your local community?

Identify a key regression for the dashboard : Identify a key regression for the dashboard. Use your completed worksheets in the TC Ice Cream Excel Workbook to complete this step.

What insights or revelations did you gain : BUS501 Entrepreneurship, Polytechnic Institute Australia - Reflective Analysis on Simulation Experience and Describe a specific challenge or decision point

Patient population you work with or work environment : Your assignment is to go to CMS, STEEEP, and AHRQ to select an area for a gap that may exist in the patient population you work with or the work environment.

Exacerbation of chronic obstructive pulmonary disease : A client with exacerbation of chronic obstructive pulmonary disease (COPD) is scheduled for a thoracentesis.

Discuss the topics framing in relation to the practice : Each critique must discuss the topic's framing in relation to the practice of emergency management. Blatant summaries of the works will not be accepted.

User Account

All Pages