Posted: December 6th, 2016

FoodiesNW sells specialty food items to customers around the world. Increasing competition and costs are cutting into the company’s profits.

 

OBJECTIVE

 

Your objective is to use analytical tools to understand and improve business performance and to present your analysis using effective data visualizations in a dashboard format.

 

FoodiesNW sells specialty food items to customers around the world.  Increasing competition and costs are cutting into the company’s profits.  FoodiesNW’s CEO has contacted you and asked you to design a prototype dashboard that can identify potential problems and opportunities and improve the company’s performance and profitability.  You will create a dashboard in Excel and then write a memo to the CEO describing your dashboard and how it can benefit the company.  You will also be invited to present your dashboard to a team of expert analysts (335 students) during the first week of December.

 

MEMO

 

The main deliverable for your individual project is a memo you will write to the CEO of FoodiesNW.  The memo will provide a description of the system you have developed and how it will be beneficial to the company.

Your memo should be clear and brief.  The CEO has requested dashboards from more than 100 analysts, so the contents, purpose, and value of the dashboard you are proposing should be easily identifiable.

Your memo will include the following sections (in order):

Screenshot.  Copy and paste a screenshot of your dashboard.  If your dashboard elements don’t have easily visible titles, please label them in your Word document or by hand.  Please print this page in color if possible.

The problem.  Describe the general problem your system is addressing.  Your system should focus on a general problem, which can be broad—such as: increasing sales or reducing costs, or narrow—such as: determining which countries or products to drop.  All of the reports you include in the dashboard should address different aspects of this problem.

Dashboard elements.  Provide each element on your dashboard a descriptive name and a number.  Aim for 3-4 items on your dashboard and list the interactive element first.  For each element provide the following:

  • number (1, 2, 3…)
  • element title
  • a very brief description of content/data included in that element
  • type of element (table, pivot chart, bar chart, etc.)
  • brief discussion of how the element will add value by supporting decisions or process changes. “The chart adds value by showing which customers have purchased most.” Is not sufficient.  Think about how the information will be used and the decisions or processes that can be improved as a result.

Summary and conclusions.  A brief and clear summary of how the dashboard as a whole addresses the problem you’ve described above, and the preliminary conclusions you have drawn from the data.  Although you are an information analyst and not a food industry expert, your insights can be helpful for demonstrating the value of your dashboard as well as improving company performance.

 

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00
Live Chat+1-631-333-0101EmailWhatsApp