BI Tools Trade-offs | Dataford Interview Questions

Which BI tools have you used, and what are their good and bad sides?

For this practical exercise, use the provided BI tool and feedback data to produce a concise comparison of every listed tool, including tools without feedback.

Output

One row per BI tool, ordered alphabetically by tool_name
Columns: tool_name, vendor, feedback_count, average_rating, good_sides, and bad_sides
Combine distinct non-null positive and negative comments into semicolon-separated values
Keep tools without feedback and return null for their rating and comment summaries

Schema

bi_tools

Column	Type	Description
tool_idPK	INT	Unique BI tool identifier
tool_name	VARCHAR(100)	BI tool name
vendor	VARCHAR(100)	Tool vendor or maintaining organization

tool_feedback

Column	Type	Description
feedback_idPK	INT	Unique feedback identifier
tool_id	INT	Referenced BI tool
rating	INT	Reviewer rating from zero to five
good_side	VARCHAR(255)	Positive aspect mentioned by the reviewer
bad_side	VARCHAR(255)	Negative aspect mentioned by the reviewer

Your question is BI Tools Trade-offs. 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