***THIS IS DUE TONIGHT 11 APR 2017***<\/p>\n
Instructions<\/p>\n
Throughout this course, we’ve practiced ways to analyze and model data from<\/p>\n
financial operations so that it assists in decision-making. Most of our<\/p>\n
models have been discrete, standalone designs. Often managers in<\/p>\n
organizations would like a high-level snapshot of financial performance that<\/p>\n
coveys critical information at a glance. Dashboards are such presentation<\/p>\n
tools. Excel has made creating dashboards easier and more effective.<\/p>\n
In this assignment, you are required to create an Excel Dashboard by using<\/p>\n
at least three of the Excel functions and\/or capabilities that we have<\/p>\n
learned in class. The details of the case and the raw data from which to<\/p>\n
work are in the attached Excel workbook. Since this is raw data, there may<\/p>\n
be analysis steps that you have to perform to prepare the data for its final<\/p>\n
presentation on your dashboard.<\/p>\n
There is a lot of information in the course content on dashboards. Please<\/p>\n
read it carefully. You should recognize most of this advice from our early<\/p>\n
lectures on graphs and charts. What is different for this dashboard<\/p>\n
assignment is that you are bringing together multiple displays of<\/p>\n
information in a meaningful way to tell a story, or in this case, respond to<\/p>\n
the question in the problem (will the company achieve 2010 forecasted<\/p>\n
sales).<\/p>\n
The DUE DATE on this assignment is listed in the syllabus. I suggest that<\/p>\n
you start the project early. In this situation, you MAY use the attached<\/p>\n
spreadsheet that contains the raw data as the starting place for your<\/p>\n
dashboard.<\/p>\n
As you research and work on this project, I encourage you to post additional<\/p>\n
references and\/or video links that you think may be helpful to the group.<\/p>\n
You have a lot of freedom in this project and it is an opportunity to<\/p>\n
practice and demonstrate the skills you’ve gained in class. You will be<\/p>\n
graded on the following criteria:<\/p>\n
1) appropriateness and complexity of Excel features used<\/p>\n
2) accuracy of calculations, analyses, or presentations<\/p>\n
3) overall theme and presentation<\/p>\n
4) effectiveness of dashboard in communicating results and responding to the<\/p>\n
question<\/p>\n
5) the quality and accuracy of your narrative response to the question<\/p>\n
Make the dashboard meaningful, but have fun!<\/p>\n","protected":false},"excerpt":{"rendered":"
***THIS IS DUE TONIGHT 11 APR 2017*** Instructions Throughout this course, we’ve practiced ways to analyze and model data from financial operations so that it assists in decision-making. Most of our models have been discrete, standalone designs. Often managers in Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-27358","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/27358","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=27358"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/27358\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=27358"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=27358"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=27358"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}