Business Intelligence Tools and Features Questions

Covers expert proficiency with major business intelligence tools such as Tableau, Power BI, and Looker, and the advanced capabilities these platforms provide. Topics include creating calculated fields and parameters, conditional formatting, complex filtering, dashboard interactivity and responsive layout design, and best practices for visualization and user experience. Includes performance optimization techniques such as extract versus live connection trade offs, query optimization, incremental refresh strategies, and general performance tuning. Also covers governance and security features including access controls and sharing models, considerations for tool selection and recommending the right tool for a specific use case, and high level migration strategies between BI platforms.

MediumTechnical

0 practiced

A Tableau dashboard connected to a Redshift table is slow. Describe a step-by-step diagnostic approach you would take to find the bottleneck (what metrics/tools you check), and list five concrete optimization actions (e.g., extracts, aggregations, reducing marks) you might apply with reasons for each.

EasyTechnical

0 practiced

Define parameters in BI platforms (Tableau/Power BI/Looker). Describe three practical use-cases (dynamic thresholds, switching metrics, what-if analysis). Explain, at a high level, how you would implement a parameter-driven filter in Power BI (What-If parameter or slicer + measure) and in Tableau (parameter + calculated field).

HardTechnical

0 practiced

Explain how to implement dataset lineage and metadata management for BI reports across multiple tools. Include techniques for capturing lineage (parsing SQL, connector metadata, logging), integrating with a data catalog (e.g., Alation), and how to present lineage to business users to increase trust and enable impact analysis.

HardTechnical

0 practiced

Explain how to implement column-level and row-level security in Looker. Describe using access_filters, user_attributes, and access_grants, and outline an audit and testing plan to ensure policies are correctly enforced across explores and dashboards.

HardTechnical

0 practiced

A Tableau LOD calculation 'FIXED [Region] : COUNTD([Customer ID])' returns inflated counts when dashboard filters are applied. Explain why this happens, and propose two corrected approaches (one using INCLUDE/EXCLUDE or context filters, another using alternative aggregation) with formulas and discuss performance considerations for each fix.

Unlock Full Question Bank

Get access to hundreds of Business Intelligence Tools and Features interview questions and detailed answers.

Join thousands of developers preparing for their dream job.