Let's say you've been tasked with helping management for a superstore chain to find which items are the least profitable. The management feels that most of the least profitable items should be eliminated from the inventory. However, as you've done your analysis, you've discovered that certain items, while not profitable overall, have made profit at times in various locations. Your primary objective is to lead management through the discovery of the least profitable items and then guide them through a simple analysis that identifies whether an item has always been unprofitable.
Let's start by creating the individual views that will comprise your dashboard: