For this last week of March, we are continuing our project management theme.
The challenge this week is to use Deneb to build bullet charts using the provided data. Bullet charts were created by Stephen Few to offer an alternative to clunky gauges. Bullet charts are used to compare a featured measure to one or more related measures in a small amount of space. You can read the original design specification for bullet charts here.
While there are a few custom visuals that can help you create a bullet chart, we are going to make our own using the Deneb custom visual. Deneb allows developers to use the declarative JSON syntax of the Vega or Vega-Lite languages to create their own data visualizations. If you aren’t familiar with Vega-Lite, you can check out an example bullet chart here to help you get started.
- Retrieve the data from data.world.
- Sort the metrics by the [Metric Order] column
- Using a single Deneb custom visual, create a set of 8 bullet charts (one for each metric) that show the current results as a bar, the previous month results as a bar, and the goal as a tick.
- Use colorblind friendly colors.
- Set the color of the actuals bar based upon whether the metric actual value is meeting the goal. Note that there are some metrics where being below the goal is good (as noted by the [High is Good] column).
- Use independent scales for each bullet chart.
- Set the tooltip on the Deneb visual to show Actual, Goal, and Prev Actual when hovering over any data point in a bullet chart.
- Create a legend to explain the marks used in the bullet charts.
- Add a visual that displays the last updated date. Use the max [Reporting Date] value.
This challenge uses data provided on data.world specifically for this exercise. You can use the data.world connector in Power BI (recommended) or download the Excel file to your local machine. You will need to log in to data.world to retrieve the data, but accounts are free.
After you finish your workout, share on Twitter using the hashtags #WOW2022 and #PowerBI, and tag @JSBaucke, @MMarie, @shan_gsd, @KerryKolosko, and @NerdyWithData. Also make sure to fill out the Submission Tracker so that we can count you as a participant this week in order to track our participation throughout the year.