Reference no: EM133758250
Purpose
You are to create a dashboard that gives the user a snapshot of key elements in your chosen dataset. Dashboards allow users to view several charts or other visual indicators on one page or screen. Dashboard examples and design resources are included on the course site. You will also want to view the video tutorial on dashboards.
Assignment:
You can use one of the provided datasets.
Dashboard Details:
You should build your dashboard on the first sheet and name it appropriately. Be creative and professional. Use charts that best represent the chosen data. Depending on how you create them, you should aim for between 6 and 8 charts for your dashboard. This can vary based on other visualizations you include, such as small tables with conditional formatting and sparklines. The data for the dashboard is located on sheet 2 of the project file.
You are given several different types of data. You should not only use the raw data that's given to you, but you should also use the functions you learned in class to create more meaningful transformations of the data. To refresh your memory, these functions include (but are not limited to) SUM, AVERAGE, MIN, MAX, STDEV, etc. For example, you could calculate percent changes in sales for each month, then create a mini table of the results, using either conditional formatting or sparklines to help visualize the data.
Analysis:
You will also need to write a report that analyzes the output of your dashboard. This report should be between 750 and 1250 words in length. You should use your Dashboard Plan questions to guide this report. In addition, be sure that the following are also addressed:
What kinds of decisions can a manager make based on your dashboard (this should be based on the questions you developed in your dashboard plan)?
What difficulties did you have in creating the dashboard?
What are some improvements for future versions of your dashboard if you had access to more data?
Option to work with one other student:
You may work with one other student as a team to complete the project. Here are the specifics:
Find another student in the class you would like to work with. If you do not know anyone, you may post a request in the Dashboard Project Find a Team Member forum. Send an email to me with your partner's name. This must be done prior to the Dashboard Plan due date.
Send an email to me with your team member's name
Team members will receive the same grade unless a peer review notes a significant lack of work by one of the team members.