Learning Goal: I’m working on a business question and need an explanation and an

Learning Goal: I’m working on a business question and need an explanation and answer to help me learn.Dashboard ProjectIntroduction: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 three provided datasets. Dashboard Plan:Your plan is a separately graded assignment. Please see the Dashboard Plan assignmentDashboard 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.
You Dashboard will be graded based on:Meeting
the minimum number of charts (6) – You most likely will use more than
6, including at least one pivot chart that uses slicers.
The meaningfulness and appropriateness of the charts you use.
The
layout of the dashboard, including the use of headings and subheadings,
and the logical organization of charts. For example, charts related to
revenues and expenses should most likely be grouped together.
The quality of your analysis paper
See the rubric for specific details

Leave a comment

Your email address will not be published.