Practice BI dashboard vocabulary: KPI widgets, drill-down, drill-through, slice-and-dice, time series, trailing periods, YTD, filters, dimensions, and measures.
0 / 5 completed
1 / 5
What is the difference between 'drill-down' and 'drill-through' in a BI dashboard?
Drill-down moves to a finer granularity within the current visualization — clicking a year bar to see quarters. Drill-through opens a related detailed report — clicking a product category to navigate to a product-level detail page.
2 / 5
What does 'slice-and-dice' mean in BI analytics?
Slice-and-dice means filtering (slicing) data by one dimension and grouping (dicing) by another to explore the data from multiple angles. Example: slice by region, dice by product category — 'Let me slice this by geography and dice it by customer segment.'
3 / 5
What does 'trailing 30 days' mean on a dashboard?
'Trailing 30 days' (also T30D) is a rolling window — it always shows the 30 days immediately before today. Unlike a calendar month, it moves every day. 'As of today, trailing 30 days revenue is $X' means the sum from yesterday back 30 days.
4 / 5
What is the difference between a 'dimension' and a 'measure' in BI?
Dimensions are the 'what' — categorical attributes like Region, Product Type, or Customer Segment that you group and filter by. Measures are the 'how much' — numerical values like Revenue, Orders, or Conversion Rate that you aggregate (sum, average, count).
5 / 5
What does 'YTD' stand for and when would you use it on a dashboard?
YTD (Year-To-Date) shows the cumulative value from January 1st of the current year to today. It's used to track progress against annual targets. Example: 'YTD revenue is $4.2M against our $10M annual target — we're 42% of the way through the year with 58% of days remaining.'