Introduction
I’ve been reading the new book Dashboards That Deliver by Andy Coatgreave, Amanda Makulec, Jeffrey Shaffer, and Steve Wexler. Chapter 14 contains an eCommerce dashboard by Dorian Banutoiu that shows how many people viewed a product, added it to their cart, and then actually purchased it. I appreciated the compact nature of what the book calls the “bar-in-bar-in-bar chart” and the way the product table used microcharts to show both a percentage and absolute numbers in a compact design.
Below is my own take on those microcharts using a matrix in Power BI and a color scheme with higher contrast. I used SVG measures to incorporate the charts into the matrix, but you can use whatever method you would like to complete the requirements.
Requirements
- Retrieve the data from Data.World.
- Create a way for the user to choose whether they want to see the metrics by product or department.
- Create a visual with a tabular layout that includes the product or department, the page views, the purchases, a progress bar that shows the conversion rate (purchases/page views), and the bar-in-bar-in-bar visual that shows views/adds to cart/purchases.
- Create an “explainer” image that users can reference to understand how to read the visuals. It can be shown by selecting a button or image, or simply placed on the page.
Dataset
Data for this challenge can be found on Data.World at https://data.world/workoutwednesdayforpowerbi/wow2025w41.
There is a single table in the dataset.
Note: Data.World requires you to create a free account to access the data. You may use the Data.World connector in Power BI or download the file to your local machine and connect to it there.
Share
After you finish your workout, share on Bluesky or LinkedIn using the hashtags #WOW2025 and #PowerBI, and tag @MMarie, @shan_gsd, @KerryKolosko (on BlueSky).