BI Dashboard Vocabulary
Practice BI dashboard vocabulary: KPI widgets, drill-down, drill-through, slice-and-dice, time series, trailing periods, YTD, filters, dimensions, and measures.
0 / 26 completed
1 / 26
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 / 26
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 / 26
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 / 26
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 / 26
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.'
6 / 26
During a code review for the new sales dashboard, Sarah mentions needing to 'normalize' the data. Mark asks her what she means. Which of the following best describes Sarah's intention?
{code}
Sarah is referring to data normalization—a crucial step in BI. Normalization involves transforming data values to a standard scale, often using techniques like Z-score standardization or min-max scaling. This addresses issues of differing scales and magnitudes, improving the accuracy and interpretability of charts and calculations within the dashboard. Simply removing missing data wouldn't address potential skewness or outliers.
7 / 26
You're reviewing a PR for the new marketing dashboard. The developer, David, uses the term 'cohort analysis'. During the discussion, you want to clarify what he means in this context. Which of the following best explains cohort analysis as it relates to a marketing dashboard?
Cohort analysis is a powerful technique that goes beyond simple trend visualization. It specifically groups users based on shared attributes (like signup date or acquisition channel) and then monitors their behavior *over time*. This allows marketers to understand how different cohorts respond to campaigns, revealing valuable insights into customer retention, engagement, and the long-term impact of marketing efforts – a critical aspect often missed when simply looking at aggregate metrics.
8 / 26
You're reviewing a pull request for the new e-commerce dashboard. The developer, Emily, is explaining her use of 'funnel analysis'. During the discussion, you want to ensure you understand her approach. Which of the following best describes what Emily means in this context?
{code}
// Example API response snippet
{
"stage": "Checkout",
"value": 125,
"users": 34
}
Funnel analysis focuses on tracking users as they progress through a defined sequence of steps – often visualized as a funnel. In this case, Emily's 'funnel' represents the stages in an e-commerce purchase, allowing her to pinpoint where customers are leaving the process and identify areas for improvement. The other options describe different analytical approaches but don't capture the core concept of sequential user behavior tracking.
9 / 26
During a standup update for the new customer support dashboard, Ben reports that he's using 'anomaly detection' to identify unusual user behavior. Maria asks him to elaborate. Which of the following best describes what Ben is trying to accomplish with anomaly detection in this scenario?
{code}
// Example API response snippet
{
"metric": "Ticket Resolution Time",
"threshold": 720, // seconds
"value": 654,
"anomalous": true
}
Anomaly detection employs statistical algorithms to spot unusual data points—like significantly longer ticket resolution times than usual. This isn't about manual review or basic sorting; it's about identifying deviations from the expected pattern, which could signal a service outage, a bug, or an emerging trend. The API response snippet illustrates this – the `anomalous: true` flag indicates that the detected value exceeds a defined threshold.
10 / 26
During a code review for the new sales dashboard, Sarah mentions needing to 'normalize' the data. Mark asks her what she means. Which of the following best describes Sarah's intention?
{code}
Sarah is referring to data normalization—a crucial step in BI. Normalization involves transforming data values to a standard scale, often using techniques like Z-score standardization or min-max scaling. This addresses issues of differing scales and magnitudes, improving the accuracy and interpretability of charts and calculations within the dashboard. Simply removing missing data wouldn't address potential skewness or outliers.
11 / 26
You're reviewing a PR for the new marketing dashboard. The developer, David, uses the term 'cohort analysis'. During the discussion, you want to clarify what he means in this context. Which of the following best explains cohort analysis as it relates to a marketing dashboard?
Cohort analysis is a powerful technique that goes beyond simple trend visualization. It specifically groups users based on shared attributes (like signup date or acquisition channel) and then monitors their behavior *over time*. This allows marketers to understand how different cohorts respond to campaigns, revealing valuable insights into customer retention, engagement, and the long-term impact of marketing efforts – a critical aspect often missed when simply looking at aggregate metrics.
12 / 26
You're reviewing a pull request for the new e-commerce dashboard. The developer, Emily, is explaining her use of 'funnel analysis'. During the discussion, you want to ensure you understand her approach. Which of the following best describes what Emily means in this context?
{code}
// Example API response snippet
{
"stage": "Checkout",
"value": 125,
"users": 34
}
Funnel analysis focuses on tracking users as they progress through a defined sequence of steps – often visualized as a funnel. In this case, Emily's 'funnel' represents the stages in an e-commerce purchase, allowing her to pinpoint where customers are leaving the process and identify areas for improvement. The other options describe different analytical approaches but don't capture the core concept of sequential user behavior tracking.
13 / 26
During a standup update for the new customer support dashboard, Ben reports that he's using 'anomaly detection' to identify unusual user behavior. Maria asks him to elaborate. Which of the following best describes what Ben is trying to accomplish with anomaly detection in this scenario?
{code}
// Example API response snippet
{
"metric": "Ticket Resolution Time",
"threshold": 720, // seconds
"value": 654,
"anomalous": true
}
Anomaly detection employs statistical algorithms to spot unusual data points—like significantly longer ticket resolution times than usual. This isn't about manual review or basic sorting; it's about identifying deviations from the expected pattern, which could signal a service outage, a bug, or an emerging trend. The API response snippet illustrates this – the `anomalous: true` flag indicates that the detected value exceeds a defined threshold.
14 / 26
During a code review for the new sales dashboard, Sarah mentions needing to 'normalize' the data. Mark asks her what she means. Which of the following best describes Sarah's intention?
{code}
Sarah is referring to data normalization—a crucial step in BI. Normalization involves transforming data values to a standard scale, often using techniques like Z-score standardization or min-max scaling. This addresses issues of differing scales and magnitudes, improving the accuracy and interpretability of charts and calculations within the dashboard. Simply removing missing data wouldn't address potential skewness or outliers.
15 / 26
You're reviewing a PR for the new marketing dashboard. The developer, David, uses the term 'cohort analysis'. During the discussion, you want to clarify what he means in this context. Which of the following best explains cohort analysis as it relates to a marketing dashboard?
Cohort analysis is a powerful technique that goes beyond simple trend visualization. It specifically groups users based on shared attributes (like signup date or acquisition channel) and then monitors their behavior *over time*. This allows marketers to understand how different cohorts respond to campaigns, revealing valuable insights into customer retention, engagement, and the long-term impact of marketing efforts – a critical aspect often missed when simply looking at aggregate metrics.
16 / 26
You're reviewing a pull request for the new e-commerce dashboard. The developer, Emily, is explaining her use of 'funnel analysis'. During the discussion, you want to ensure you understand her approach. Which of the following best describes what Emily means in this context?
{code}
// Example API response snippet
{
"stage": "Checkout",
"value": 125,
"users": 34
}
Funnel analysis focuses on tracking users as they progress through a defined sequence of steps – often visualized as a funnel. In this case, Emily's 'funnel' represents the stages in an e-commerce purchase, allowing her to pinpoint where customers are leaving the process and identify areas for improvement. The other options describe different analytical approaches but don't capture the core concept of sequential user behavior tracking.
17 / 26
During a standup update for the new customer support dashboard, Ben reports that he's using 'anomaly detection' to identify unusual user behavior. Maria asks him to elaborate. Which of the following best describes what Ben is trying to accomplish with anomaly detection in this scenario?
{code}
// Example API response snippet
{
"metric": "Ticket Resolution Time",
"threshold": 720, // seconds
"value": 654,
"anomalous": true
}
Anomaly detection employs statistical algorithms to spot unusual data points—like significantly longer ticket resolution times than usual. This isn't about manual review or basic sorting; it's about identifying deviations from the expected pattern, which could signal a service outage, a bug, or an emerging trend. The API response snippet illustrates this – the `anomalous: true` flag indicates that the detected value exceeds a defined threshold.
18 / 26
During a code review for the new sales dashboard, Sarah mentions needing to 'normalize' the data. Mark asks her what she means. Which of the following best describes Sarah's intention?
{code}
Sarah is referring to data normalization—a crucial step in BI. Normalization involves transforming data values to a standard scale, often using techniques like Z-score standardization or min-max scaling. This addresses issues of differing scales and magnitudes, improving the accuracy and interpretability of charts and calculations within the dashboard. Simply removing missing data wouldn't address potential skewness or outliers.
19 / 26
You're reviewing a PR for the new marketing dashboard. The developer, David, uses the term 'cohort analysis'. During the discussion, you want to clarify what he means in this context. Which of the following best explains cohort analysis as it relates to a marketing dashboard?
Cohort analysis is a powerful technique that goes beyond simple trend visualization. It specifically groups users based on shared attributes (like signup date or acquisition channel) and then monitors their behavior *over time*. This allows marketers to understand how different cohorts respond to campaigns, revealing valuable insights into customer retention, engagement, and the long-term impact of marketing efforts – a critical aspect often missed when simply looking at aggregate metrics.
20 / 26
You're reviewing a pull request for the new e-commerce dashboard. The developer, Emily, is explaining her use of 'funnel analysis'. During the discussion, you want to ensure you understand her approach. Which of the following best describes what Emily means in this context?
{code}
// Example API response snippet
{
"stage": "Checkout",
"value": 125,
"users": 34
}
Funnel analysis focuses on tracking users as they progress through a defined sequence of steps – often visualized as a funnel. In this case, Emily's 'funnel' represents the stages in an e-commerce purchase, allowing her to pinpoint where customers are leaving the process and identify areas for improvement. The other options describe different analytical approaches but don't capture the core concept of sequential user behavior tracking.
21 / 26
During a standup update for the new customer support dashboard, Ben reports that he's using 'anomaly detection' to identify unusual user behavior. Maria asks him to elaborate. Which of the following best describes what Ben is trying to accomplish with anomaly detection in this scenario?
{code}
// Example API response snippet
{
"metric": "Ticket Resolution Time",
"threshold": 720, // seconds
"value": 654,
"anomalous": true
}
Anomaly detection employs statistical algorithms to spot unusual data points—like significantly longer ticket resolution times than usual. This isn't about manual review or basic sorting; it's about identifying deviations from the expected pattern, which could signal a service outage, a bug, or an emerging trend. The API response snippet illustrates this – the `anomalous: true` flag indicates that the detected value exceeds a defined threshold.
22 / 26
During a Slack discussion about the new analytics dashboard, Liam mentions using 'segmentation' to group users. You want to ensure you understand how he's applying this concept. Which of the following best describes Liam's intention?
segmentation = dividing data into distinct groups based on shared characteristicsSegmentation, in the context of dashboards, refers to dividing your user base or data into distinct groups based on shared characteristics like demographics, behavior, or purchase history. This allows for more focused analysis and tailored reporting; simply partitioning a database doesn't capture this nuanced meaning. The key is understanding it's about *categorization* for insights.
23 / 26
You are reviewing a PR description for the new fraud detection dashboard. The developer, Chloe, writes: 'We're using 'statistical significance' to determine if our anomaly alerts are truly indicative of fraudulent activity.' Which of the following best explains what Chloe is referring to?
statistical significance = a measure of how likely an observed effect is due to a real difference rather than random chanceChloe is using 'statistical significance' to evaluate whether the anomalies flagged by her system are genuinely indicative of fraudulent behavior or just random noise. It's a critical concept in data analysis – determining if an observed difference is statistically meaningful and not simply due to chance. A low p-value indicates strong evidence for a real effect.
24 / 26
During a standup meeting, Alex reports that he's implementing 'data masking' in the new user profile dashboard. Sarah asks him to clarify. Which of the following best describes what Alex is doing?
Data Masking = obscuring sensitive data (e.g., PII) by replacing it with placeholder valuesAlex's use of 'data masking' means he's protecting user profiles by replacing sensitive details like names or addresses with placeholder values. This is crucial for complying with privacy regulations (like GDPR) and preventing data breaches. It's a security practice, not just a technical optimization technique.
25 / 26
You're reviewing a pull request for the new e-commerce dashboard. The developer, James, mentions 'KPIs' when discussing performance metrics. Which of the following best describes what James means?
KPIs = Key Performance Indicators – quantifiable measures used to evaluate the success of an organization or activityJames is referring to 'KPIs' – Key Performance Indicators. These are critical metrics that provide quantifiable insights into the dashboard's success and how it contributes to broader business objectives. They aren't just arbitrary numbers; they're carefully selected measures of performance.
26 / 26
You are reviewing a code review comment from David regarding the new sales dashboard. He states: 'I've applied a logarithmic scale to the revenue chart.' What does David likely intend to achieve?
Applying a logarithmic scale makes it easier to visualize large differences in data values, highlighting percentage changes rather than absolute numbersDavid's use of a logarithmic scale is designed to better represent revenue trends, particularly when there are large differences in values. Logarithmic scales make percentage changes more apparent than absolute numbers, which is often crucial for understanding sales performance over time. This is especially helpful when dealing with data that's heavily skewed.
Frequently Asked Questions
What will I practice in "BI Dashboard Vocabulary"?
This is a BI Analytics Language exercise set. It walks through 26 scenario-based multiple-choice questions built around real usage of BI Analytics Language terminology that IT professionals encounter on the job.
Is this exercise free to use?
Yes. Every exercise on CoderSlingo, including this one, is free to complete with no account, sign-up, or paywall.
How many questions are in this exercise?
This set contains 26 questions. Each one shows immediate feedback and a detailed explanation after you answer, so you learn the correct usage right away rather than waiting for a final score.
Do I need prior experience to complete this exercise?
No prior experience is required. Each question includes a full explanation covering the reasoning behind the correct answer, so the exercise itself teaches the BI Analytics Language vocabulary as you go.
Can I retry the exercise if I get questions wrong?
Yes — use the "Try again" button on the results screen to reset your answers and go through all the questions again. There is no limit on attempts.
Is my progress saved?
Your answers and score for the current session are tracked in the browser as you go. No account or login is needed, and there is nothing to install.
What if I don't understand a term used in a question?
Read the explanation shown after you answer each question — it breaks down the correct term in plain English with a real-world example. You can also check the site Glossary for quick definitions.
How is this different from reading a blog article on the topic?
Exercises like this one are interactive drills that test and reinforce specific vocabulary through multiple-choice questions, while blog articles explain concepts in prose. Practising here after reading builds active recall, not just passive recognition.
Where can I find more BI Analytics Language exercises?
See the BI Analytics Language exercises hub for the full set of related pages, or browse all exercise categories from the main Exercises index.
Can I use this exercise to prepare for a technical interview?
Yes — BI Analytics Language vocabulary comes up often in technical discussions and interviews. Pair this exercise with our dedicated Interview Preparation section for role-specific practice.