A business analyst needs to create an interactive sales dashboard in Looker for regional managers. The dashboard must present regional revenue metrics using visual charts and allow managers to dynamically filter all visualizations by date range and product category. Which approach should the analyst use to design and build this dashboard?

Query data in an Explore using dimensions and measures, select appropriate visualization types to save as dashboard tiles, and add dashboard filters mapped to the relevant fields.: ### **What Looker Dashboards and Explores Are** **Looker** is a modern business intelligence and data exploration platform. In Looker, users interact with data models through **Explores**, which expose curated **dimensions** (attributes or categories) and **measures** (aggregations like sums and counts). Dashboards in Looker serve as collections of visual **tiles** created from Explore queries or saved **Looks**, organized to deliver actionable insights. ### **How it Meets the Business Requirements** - **Visualizing Revenue Metrics (✓):** The analyst can choose fields from the Explore (such as `Order Date`, `Product Category`, and `Total Revenue`), configure chart types (such as bar charts, line graphs, or tables), and save them directly as dashboard tiles. - **Interactive Filtering (✓):** Looker allows dashboard editors to add **dashboard filters** (like date range and category dropdowns) that apply across multiple tiles simultaneously, updating query results interactively for each manager. - **Governed Data Access (✓):** Because Explores are built on centralized LookML models, business definitions remain consistent and secure across all tiles on the dashboard. ### **Key Advantages and Capabilities** - **Native Interactivity:** Adding dashboard-level filters empowers business users to slice and dice metrics on demand without editing underlying queries. - **Dynamic In-Database Processing:** Looker executes SQL queries directly against the underlying database when filter values change, ensuring fresh and accurate results. - **Flexible Layouts:** Tiles can be rearranged, resized, and styled with customized color palettes and themes to suit stakeholder needs. - **Drill-Down Capabilities:** Users can click on specific visualization components within a tile to drill into more detailed records. ### **Why This is Optimal** Building tiles from **Explores** and implementing native **dashboard filters** represents standard best practice in Looker. It avoids hardcoded queries, supports self-service interactivity, and ensures centralized governance across all analytical views.