Using Tableau or Power BI at Work | Dataford Interview Questions

How did you use Tableau or Power BI at your previous workplace?

For this SQL exercise, demonstrate the data-preparation portion by producing a dashboard-ready monthly summary from the provided tables. Include only production encounters in calendar year 2025.

Output

One row per department and month with activity.
Return department_name, report_month, total_encounters, completed_encounters, cancelled_encounters, and completion_rate_pct.
Order by department name, then month ascending.

Schema

departments

Column	Type	Description
department_idPK	INT	Unique department identifier
department_name	VARCHAR(100)	Department display name

encounters

Column	Type	Description
encounter_idPK	INT	Unique encounter identifier
department_id	INT	Referenced department identifier
encounter_date	DATE	Date the encounter occurred
status	VARCHAR(30)	Encounter outcome status
is_test	BOOLEAN	Whether the record is test data

Your question is Using Tableau or Power BI at Work. 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