Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started
QuickSight vs Tableau Dashboards
00:00
5 left

QuickSight vs Tableau Dashboards

HardSQL · PostgreSQL

Problem

Compare and contrast the use of QuickSight and Tableau for building automated dashboards.

Using the supplied tables, return a SQL-based comparison of the two tools across documented dashboard capabilities.

Output

  1. One row per tool, limited to QuickSight and Tableau.
  2. Include tool_name, matched feature_count, automated_feature_count, native_integration_count, average_score, and an alphabetically ordered feature_summary.
  3. Sort by tool_name ascending.

Schema

tool_feature_assessments
ColumnTypeDescription
assessment_idPKINTUnique capability assessment identifier
tool_nameVARCHAR(50)Analytics tool being assessed
feature_idINTCapability catalog identifier
automation_supportedBOOLEANWhether the capability supports dashboard automation
native_integrationBOOLEANWhether the capability is natively integrated
scoreDECIMAL(3,1)Illustrative capability assessment score
dashboard_features
ColumnTypeDescription
feature_idPKINTUnique capability catalog identifier
capabilityVARCHAR(100)Dashboard capability name
capability_descriptionTEXTDescription of the capability
Tablestool_feature_assessmentsdashboard_features
Interviewer

Your question is QuickSight vs 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.

You need to log in / sign up to run or submit.
CodePostgreSQL
You need to log in / sign up to run or submit.Ln 1
Run your query to see results here.