BI Tools and Scalability | Dataford Interview Questions

Which BI tools (such as Tableau or Power BI) have you used, and how do they differ in terms of scalability?

Write a SQL query that summarizes recorded BI tool usage and assigns a scalability assessment based on runtime and data volume.

Output

One row per BI tool, including tools with no recorded runs.
Return tool_name, vendor, usage_count, unique_users, avg_runtime_seconds, max_rows_processed, and scalability_assessment.
Sort by usage count descending, then tool name ascending.

bi_tools

Column	Type	Description
tool_idPK	INT	Unique BI tool identifier
tool_name	VARCHAR(100)	BI tool name
vendor	VARCHAR(100)	Tool vendor
is_active	BOOLEAN	Whether the tool is currently active

dashboard_runs

Column	Type	Description
run_idPK	INT	Unique dashboard execution identifier
tool_id	INT	BI tool used for the execution
user_id	INT	User who launched the dashboard
runtime_seconds	INT	Dashboard execution time in seconds
rows_processed	INT	Number of rows processed
run_status	VARCHAR(20)	Execution status

Your question is BI Tools and Scalability. 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.