Topic 1 Question 53
Your company uses Looker as its primary business intelligence platform. You want to use LookML to visualize the profit margin for each of your company’s products in your Looker Explores and dashboards. You need to implement a solution quickly and efficiently. What should you do?
Create a derived table that pre-calculates the profit margin for each product, and include it in the Looker model.
Define a new measure that calculates the profit margin by using the existing revenue and cost fields.
Create a new dimension that categorizes products based on their profit margin ranges (e.g., high, medium, low).
Apply a filter to only show products with a positive profit margin.
ユーザの投票
コメント(1)
- 正解だと思う選択肢: B
The best option is B. Define a new measure. Option B is best: Measures are for on-the-fly calculations in Looker, quick & efficient. Option A (Derived table) is incorrect: Slower, pre-calculation not needed. Option C (New dimension) is incorrect: Dimensions are for categories, not metrics. Option D (Apply filter) is incorrect: Filter restricts data, doesn't calculate margin. Therefore, Option B, new measure, is the fastest, most efficient LookML solution.
👍 1n21837128472025/03/05
シャッフルモード