What does the C-suite look for in an analytic
I’m so excited to announce that I’ve joined up with Lindsay Betzendahl this year to collaborate and will continue to drive forward the #ProjectHealthViz community initiative. I’m so excited to be on the team and we’ve got some cool coming in 2021! And it’s starting right now with our first dataset, NHS Admissions.
One of the new things we’re going to be doing this year with #ProjectHealthViz is adding additional “challenges” on top. Think of it as a starting purpose for making something. And for our first challenge with this dataset, we asked folks to create a c-suite dashboard.
And that’s what I’ve done with my submission. I created a very high level of the most important metrics. Now its no surprise that every stakeholder is different but there are a few things that every c-suite stakeholder is going to want in their dashboards. Let’s cover them.
- Next level drill/detail
- Few filters & little interactivity
There aren’t many business-first dashboards that won’t have some type of KPI, so be sure to start off your dashboard with big numbers! Be sure to understand what are the drivers, what’s important. This is different for each domain, so you definitely want to have a conversation with your stakeholder if you don’t already know what they are. Yes, it’s okay to ask. You can see in my example that I created that I gave 4 KPIs. And for each, I created a sub-dimension that allows the user to understand both the top level number but also compared that to the top n specialties.
Next Level Drill/Detail
After the user takes a look at the KPIs, they’re gonna be ready for the next-level detail. There is a specific difference between next level and low level detail. As BI developers, we do not want to bog down our stakeholder’s time with making them sift through lots of detail trying to find the insight. So I like to give them the next level down from KPIs. So use the KPIs to determine which dimensions measures you should use to give them the next level of detail.
Few filters & little interactivity
This next one is such a hard lesson for newer BI developers to learn (take it from one who knows, first hand 😉 ). As much as interactivity can help with data understanding in a dashboard. But for C-suite executives, too much interactivity can be a determent rather than a help. I put this filters in the bucket as well. We’ve all had that stakeholder that gets too bogged down in the details to see the forest and the vision, right? And then they spend way too much time looking into every detail. Then the next thing you know you’ve got another 50 items to look into. This is not a plea to do less work, you are actually doing them a favor. To get around that in my dashboard, I added a popout box of all the available specialties with a integer parameter to increase or decrease the top specialties.
My one level of interactivity that I added was a hover-to-highlight action based on specialty. This helps the user make the connection between the different charts.
The last piece of advice I’ll leave you with is to make you dashboard consumable in multiple formats. Try to think if this will be printed out and delivered in a meeting. Or perhaps it’ll be added to a slide deck for a presentation. You can rest assured that content will be consumed, at some point, outside of computer screen. You can use Tableau’s built-in dashboard sizing options to format your dashboard for multiple sizes.