Tell me about a time when you had to lead the design of a complex dashboard in Looker or Tableau for a cross-functional team. How did you navigate conflicting priorities or stakeholder feedback to ensure the final product met business objectives and remained user-friendly?

Use STAR framework: 1) Situation: Set context (e.g., project goal, team dynamics). 2) Task: Define your role and objectives. 3) Action: Detail strategies to resolve conflicts (e.g., workshops, prioritization frameworks, prototyping). 4) Result: Quantify outcomes (e.g., adoption rates, efficiency gains, stakeholder satisfaction). Focus on collaboration, data-driven decisions, and balancing technical feasibility with user needs.

As a BI Analyst, I led the design of a Tableau dashboard for a cross-functional team of 15+ stakeholders in a retail client's supply chain optimization project. The team had conflicting priorities: finance wanted real-time cost tracking, while operations needed inventory visibility. I initiated a series of workshops to align stakeholders on core business objectives, using a RICE scoring framework to prioritize 20+ requested metrics. I prototyped dashboards with both teams, incorporating feedback through iterative reviews. To ensure usability, I integrated intuitive filters and pre-built templates. The final dashboard, launched in 6 weeks, achieved 90% adoption across departments, reduced reporting time by 40%, and enabled faster inventory adjustments, directly contributing to a 12% reduction in stockouts. Post-launch surveys showed 85% stakeholder satisfaction, with finance and operations both meeting their KPIs.