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

17 practiced

Explain how to use Tableau Performance Recording and Power BI Performance Analyzer to diagnose a slow workbook. List the key metrics you would inspect (query time, viz rendering, data engine time), and outline a workflow to isolate the slowest element and recommend fixes.

HardSystem Design

18 practiced

Architect an enterprise BI platform that must support 10,000 concurrent users, sub-second response for a few executive dashboards, and near-real-time streaming dashboards for operations. Describe components (data warehouse, semantic layer, caching, query layer, BI tools), scaling strategies, freshness SLAs, and cost-performance trade-offs.

HardTechnical

25 practiced

Optimize the following generic SQL pattern used by a BI tool on a warehouse with >1B rows: SELECT c.category, SUM(s.amount) FROM sales s JOIN products p ON s.product_id = p.id JOIN categories c ON p.category_id = c.id WHERE s.order_date >= '2023-01-01' GROUP BY c.category HAVING SUM(s.amount) > 10000 ORDER BY SUM(s.amount) DESC. Propose indexing, partitioning, rewrite, and materialization strategies to reduce runtime and resource usage.

HardTechnical

19 practiced

Design a strategy to consolidate fragmented KPI definitions across global regions into a single global KPI catalog with aliases, localized thresholds, and contextual filters. Include migration steps, stakeholder engagement plan, technical enforcement mechanisms, and automation to keep definitions synchronized.

MediumTechnical

17 practiced

Write a LookML example that creates a derived table (PDT) computing 365-day customer LTV aggregated by customer_id. Include the view with a measure and a dimension, and explain how you'd schedule the PDT refresh to balance freshness and compute cost.

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.