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.

HardTechnical

0 practiced

Design an approach for measuring and improving dashboard adoption across the company. Define adoption metrics (daily/weekly active users, time spent, tasks completed), instrumentation strategies, experiments (A/B tests to improve onboarding or default views), a feedback loop, and incentives to move users from emailed static reports to interactive dashboards.

MediumTechnical

0 practiced

Write a DAX measure in Power BI that computes a 7-day moving average of daily active users (DAU). Assume a Date table (Date[Date]) and a Usage table (Usage[occurred_date], Usage[user_id]). Explain how your measure behaves when dates are missing and how to ensure correct continuity.

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

Compare two approaches to embedding dashboards for multiple tenants: (a) provisioning single-tenant BI instances per customer, and (b) running a single instance with Row-Level Security and tenant theming. Evaluate cost, operational complexity, security/isolation risk, and which you would recommend for 100 small-to-midsize tenants.

MediumTechnical

0 practiced

Compare LookML's model layer and Tableau's data source layer from the perspective of metric standardization and reuse. What are the pros and cons of each approach when trying to enforce consistent metrics across teams and self-serve environments?

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.