Building Actionable Tableau Dashboards | Dataford Interview Questions

Describe a time you built a complex Tableau dashboard from scratch; how did you ensure the end-user could derive actionable insights from it?

Using the supplied Tableau dashboard data, write a SQL query that identifies dashboards with sufficient usage but an actionable insight rate below 50%.

Output

One row per qualifying dashboard with dashboard_id, dashboard_name, owner_team, total_views, actionable_views, action_rate, and latest_view_date.
Include dashboards with at least two views and an action rate below 0.50. Order by action_rate ascending, total_views descending, and dashboard_id ascending.

Schema

tableau_dashboards

Column	Type	Description
dashboard_idPK	INT	Unique dashboard identifier
dashboard_name	VARCHAR(120)	Published Tableau dashboard name
owner_team	VARCHAR(80)	Team responsible for the dashboard

dashboard_sessions

Column	Type	Description
session_idPK	INT	Unique dashboard viewing session
dashboard_id	INT	Dashboard viewed during the session
user_id	VARCHAR(40)	Identifier for the dashboard viewer
viewed_at	DATE	Date of the dashboard view
insight_action	BOOLEAN	Whether the viewer performed a tracked insight action
action_type	VARCHAR(40)	Type of tracked action, when applicable

Your question is Building Actionable Tableau Dashboards. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem