You
are presented with a data file that includes sales to date by product, customer
type etc. You have actuals to date as well as the
yearly forecast. You have to develop a
dashboard that indicates whether they will hit their year end target, and
provide sufficient analysis and visual presentation for the sales executives to
be able to understand why, or why not.
You must use at least 3 of the functions
we have used this semester.
Present results by quarter.
The
dashboard file should be created in
Excel should include the following on separate worksheets: the raw data
(formatted to remove all irrelevant fields), the analyses performed on the raw
data (via pivot tables and other Excel functions), and graphs to display the
results of the analyses performed. The arrangement of these graphs within a
single worksheet forms the actual dashboard.





