How to Get Stakeholders to Actually Use Your Dashboards (Data Scientist’s Guide)
January 17, 2025
Business Intelligence, Data Analysis, Excel, ODK Central, Power BI, Tableau, Visualization

I once spent 2 months building a “perfect” ODK dashboard—only to learn later that nobody used it. Executives still asked for Excel files, field teams ignored it, and my hard work collected digital dust.
After this (painful) lesson, I developed a battle-tested strategy to ensure stakeholders actually engage with dashboards. Here’s how to turn passive viewers into active users.
Step 1: Identify Why They’re Not Using It
(Diagnose the problem before prescribing solutions.)
Symptom | Likely Cause | Fix |
---|---|---|
“Just export me the data.” | Dashboard doesn’t answer their questions. | Co-design metrics with them. |
“I forgot it existed.” | No reminders/triggers. | Automate alerts (Step 3). |
“It’s too complicated.” | Overwhelming UI. | Simplify (Step 4). |
Step 2: Co-Design the Dashboard
A. Ask Stakeholders: “What’s Your #1 Question?”
- Bad request: “I need all the data.”
- Good request: “Which clinics have vaccination rates below 70%?”
→ Build a dedicated “Action Needed” tab.
B. Prototype in 1 Hour (Then Iterate)
- Use dummy data to mock up one key visual.
- Get feedback before building the full dashboard.
- Example: I used a sketch on paper to validate a map layout with field teams.
Step 3: Embed Dashboards into Their Workflow
A. For Executives: Automated Emails
- Power BI: Set up Power Automate to:
- Export PDF snapshots.
- Email every Monday at 7 AM (when they check inboxes).
- Tableau: Use subscriptions.
B. For Field Teams: Mobile Alerts
- Trigger SMS/WhatsApp when:
- A survey submission needs review (
Power Automate + Twilio
). - Coverage drops below target (
Tableau + Zapier
).
- A survey submission needs review (
C. For Analysts: Integrate with Tools They Use
- Embed dashboards in:
- Slack/MS Teams (via Power BI/Tableau tabs).
- Google Sheets (with Power BI’s Analyze in Excel).
Step 4: Reduce Friction (UX Tricks)
A. Pre-Set Filters They Always Use
- Example: Default to “Last 30 days” + “Region = User’s Region.”
B. Label Actions Clearly
- Bad: A slicer labeled “Filter.”
- Good: “Select your district to see data.”
C. Add a “How to Use This” Video
- Record a 30-second Loom video embedded in the dashboard.
Step 5: Train with a “Sticky” Strategy
A. Gamify Adoption
- Leaderboard: “Top 10 Active Users This Month.”
- Rewards: Coffee gift cards for early adopters.
B. Assign a “Dashboard Champion”
- Nominate a super-user in each team to:
- Answer peers’ questions.
- Report pain points.
Real-World Example: From Ignored to Addicted
A health NGO’s dashboard had 0 logins/week until we:
- Added SMS alerts for missing data.
- Showed a “Top Performer” clinic each week.
- Ran a 5-minute demo at their weekly huddle.
Result: 80% adoption in 4 weeks.
Want me to audit your dashboard for adoption blockers? DM me!
Related Posts