Module 8 Excel 504
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 organizations 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 to complete this step.
- Identify three charts that you created in previous modules to include in your dashboard.
- 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.
- 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.
- 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 regression models created.
- 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
- Slicers that interact with the three key charts on the dashboard sheet
- A header and title
- 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 . 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 . If references are included, they should be cited in APA format. Consult the for more information on citations.
Module Eight Excel Workbook Rubric
| Criteria | Exceeds Expectations (100%) | Meets Expectations (90%) | Partially Meets Expectations (70%) | Does Not Meet Expectations (0%) | Value |
|---|---|---|---|---|---|
| Identify: Key Charts | Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner | Identifies key charts for the dashboard | Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include identifying charts for the dashboard that provide key insights into the status of the business | Does not attempt criterion | 10 |
| Create Key Slicers | Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner | Creates slicers for date and flavor for the dashboard | Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include creating slicers for date and flavor | Does not attempt criterion | 10 |
| Identify: Key Regression | Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner | Identifies a key regression for the dashboard | Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include identifying a regression for the dashboard that provides key insights into the status of the business | Does not attempt criterion | 10 |
| Create Table | Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner | Creates a table that summarizes the key regression | Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include creating a table that summarizes the key regression | Does not attempt criterion | 15 |
| Create Dashboard | Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner | Creates a dashboard | Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include creating a dashboard that includes all required elements | Does not attempt criterion | 25 |
| PowerPoint Presentation: Explanation | Exceeds expectations in an exceptionally clear, insightful, sophisticated, or creative manner | Explains why the identified charts and regression were chosen | Shows progress toward meeting expectations, but with errors or omissions; areas for improvement may include explaining why the identified charts and regression were chosen with greater detail and insight | Does not attempt criterion | 25 |
| Clear Communication | Exceeds expectations with an intentional use of language that promotes a thorough understanding | Consistently and effectively communicates in an organized way to a specific audience | Shows progress toward meeting expectations, but communication is inconsistent or ineffective in a way that negatively impacts understanding | Shows no evidence of consistent, effective, or organized communication | 5 |
| Total: | 100% | ||||
Calculate the price of your order
Select your paper details and see how much our professional writing services will cost.
- Freebies
- Format
- Formatting (MLA, APA, Chicago, custom, etc.)
- Title page & bibliography
- 24/7 customer support
- Amendments to your paper when they are needed
- Chat with your writer
- 275 word/double-spaced page
- 12 point Arial/Times New Roman
- Double, single, and custom spacing
-
We care about originality
Our custom human-written papers from top essay writers are always free from plagiarism.
-
We protect your privacy
Your data and payment info stay secured every time you get our help from an essay writer.
-
You control your money
Your money is safe with us. If your plans change, you can get it sent back to your card.
How it works
-
1
You give us the detailsComplete a brief order form to tell us what kind of paper you need.
-
2
We find you a top writerOne of the best experts in your discipline starts working on your essay.
-
3
You get the paper doneEnjoy writing that meets your demands and high academic standards!
Get your own paper from top experts
Order nowPerks of our essay writing service
We offer more than just hand-crafted papers customized for you. Here are more of our greatest perks.
Frequently asked questions
Get instant answers to the questions that students ask most often.
See full FAQHow do you find the best essay writer for me?
Our professional writing service focuses on giving you the right specialist so the one assigned will have the knowledge about the right topic. However, if you’ve used our essay service before, you can ask us to assign you the expert writer who used to complete papers for you in the past. We can easily do so if the specialist in question is available at the moment.
If you’re ordering from our essay writing service for the first time, we will assign you a suitable expert ourselves and ensure that your academic essay writer is a pro. Moreover, let us know how complex your assignment is so that we can find the best match for your order.
We’ve hired the best writers in 80+ academic subjects to complete any paper you need. As soon as we hear, “Write my essays,” our support team assigns you the writer who understands your needs and subject.
In case you need to make sure we’ve picked a great specialist to deal with your paper, you can chat with the expert writers directly. We do our best to make sure you’re happy with the writer we’ve selected for you.
How can you prove that your paper writing service is not a scam?
We have been selling original essays for more than 15 years. To prove that we are a trustworthy custom essay writing company, we provide quick delivery and a money-back guarantee. If we can’t complete your paper for any reason, we’ll send your money back to the credit card. We want to deliver the finest services, so you can decide if the paper is good enough; from our side, we’ll edit it according to your primary requirements to make the writing perfect. Our online paper writing service is about both giving you the materials you need when you need them and ensuring that your private data is safe. Check out our guarantees to see how we control the quality of your assignment and protect you as a customer.