In this scenario, you will continue to work as a business consultant trainee with the superstore client. The superstore has requested that you create a dashboard so leadership can effectively and efficiently have key insights about their sales revenue. Remember that the superstore is interested in whether specific trends are identified that can help grow its business through improved operations and sales. You are required to identify two 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 Superstore Excel Workbook to complete this step.
Identify two charts that you created in previous modules to include in your dashboard.
Identify a key regression for the dashboard.
Use your completed worksheets in the Superstore Excel Workbook to complete this step.
Identify one regression that you created in previous modules to include in your dashboard.
Create a table that summarizes the key regression.
The table should show your dependent variable, independent variable, p values, and R2.
You do not need to paste the entire output.
Create a dashboard that includes the following:
Two key charts identified from previous modules
One table that summarizes the identified regression from previous modules
A header and title
Explain why you chose the identified charts and regression.
What insights do your selected charts offer?
What insights does your selected regression offer?
Guidelines for Submission
Superstore Excel Workbook: Submit the Excel workbook. This should include one additional worksheet: Dashboard. Please do not remove any existing sheets in the workbook
Short Report: Submit a Word document using double spacing, 12-point Times New Roman font, and one-inch margins. This assignment should be 1 to 2 pages in length.
—
In this scenario, you will continue to work for the superstore customer as a business consultant trainee. The superstore has asked you to design a dashboard so that management can get vital insights into their sales revenue quickly and easily. Remember that the superstore wants to know whether there are any patterns that can help it develop its business by improving operations and sales. In order to present your analysis, you must identify two essential charts and a regression. The dashboard should show clear conclusions based on your research and findings.
Prompt
You must specifically address the following rubric criteria:
Determine the dashboard’s most important charts.
To finish this phase, use the Superstore Excel Workbook’s completed worksheets.
Determine which two charts from previous modules should be included in your dashboard.
Determine a significant regression for the dashboard.
To finish this phase, use the Superstore Excel Workbook’s completed worksheets.
To include in your dashboard, choose one regression that you developed in earlier sections.
Make a table that outlines the most important regression.
Your dependent variable, independent variable, p values, and R2 should all be listed in the table.
It is not necessary to copy and paste the full result.
Make a dashboard with the following items:
Two key charts from earlier modules have been highlighted.
One table that lists all of the regressions found in prior modules.
A title with a header
Explain why you chose the charts and regression you did.
What insights can you get from the charts you’ve chosen?
What kind of information does your chosen regression provide?
Submission Instructions
Excel Workbook for Superstore: Submit the Excel workbook. One more worksheet, Dashboard, should be added to the mix. Please do not remove any of the workbook’s existing sheets.
Brief Report: Use double spacing, 12-point Times New Roman font, and one-inch margins in a Word document. This assignment should be between one and two pages long.
The post Identify two charts that you created in previous modules appeared first on Research Quora.
