A dashboard to understand profitability

Having covered some conceptual topics as well as practical matters related to dashboard design, we’ll dive into an example.

Let’s say you’ve been tasked with helping management find which items are the least profitable. Management feels that most of the least profitable items should be eliminated from their inventory. However, since you’ve done your analysis, you’ve discovered that certain items, while not profitable overall, have made a profit at times in various locations. Your primary objective is to give management the ability to quickly see an analysis of the least profitable items to identify whether an item has always been unprofitable, answering the question, “Is the least profitable item always unprofitable?” This example will combine aspects of a guided analytics dashboard and an exploratory tool.

Building the views

Use the Superstore Sales dataset and follow these steps...