Data Analysis and Business Intelligence Flashcards
21 cards from real IKM practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 20 Data Analysis and Business Intelligence flashcards as text
Which type of data analysis focuses on understanding what happened in the past by examining historical data?
Answer: Descriptive analysis
Descriptive analysis summarizes historical data to answer 'what happened,' making it the foundational type of business intelligence reporting.
In a data warehouse, what is a 'fact table'?
Answer: A table that stores the measurable, quantitative data for analysis
A fact table contains the numeric, measurable metrics (facts) of a business process, such as sales amounts or quantities, and is the central table in a star schema.
What does ETL stand for in the context of data warehousing?
Answer: Extract, Transform, Load
ETL (Extract, Transform, Load) is the process of pulling data from source systems, cleaning and reshaping it, then loading it into a target data warehouse.
A KPI dashboard shows sales are 15% below target. Which analytical step should be taken next to investigate further?
Answer: Diagnostic analysis to identify root causes of the shortfall
Diagnostic analysis answers 'why did it happen' by drilling down into data to uncover root causes of a deviation from targets.
What is a 'dimension table' in a star schema data model?
Answer: A table containing descriptive attributes used to filter or group facts
Dimension tables hold descriptive, qualitative attributes (e.g., customer name, product category, region) that provide context for the numeric facts stored in the fact table.
Which of the following best describes 'data normalization' in relational database design?
Answer: Organizing data to reduce redundancy and improve data integrity
Normalization is the process of structuring a relational database to eliminate redundant data and ensure data dependencies make logical sense, typically following normal forms (1NF, 2NF, 3NF).
In business intelligence, what is the purpose of OLAP (Online Analytical Processing)?
Answer: To enable fast, multi-dimensional analysis of large data sets from multiple perspectives
OLAP allows analysts to quickly query and analyze data across multiple dimensions (e.g., time, geography, product) to support complex business intelligence and decision-making tasks.
In predictive analytics, what is 'overfitting' in a machine learning model?
Answer: When a model learns the training data too precisely and performs poorly on new data
Overfitting occurs when a model memorizes noise and detail in training data to such a degree that it fails to generalize to new, unseen data, resulting in poor predictive performance in production.
What is a 'Slowly Changing Dimension' (SCD) in data warehousing?
Answer: A dimension whose attribute values change over time and must be managed historically
A Slowly Changing Dimension (SCD) is a dimension whose attributes change slowly over time (e.g., a customer's address), requiring strategies like Type 1, 2, or 3 to track or overwrite historical values.
Which measure of central tendency is LEAST affected by extreme outlier values in a dataset?
Answer: Median
The median is the middle value when data is sorted, making it resistant to outliers because extreme values do not shift it significantly, unlike the mean which is pulled toward outliers.
In SQL, what is the difference between WHERE and HAVING clauses?
Answer: WHERE filters rows before aggregation; HAVING filters groups after aggregation
WHERE filters individual rows before any grouping or aggregation occurs, while HAVING filters the resulting groups after a GROUP BY clause and aggregate functions have been applied.
A business analyst creates a report showing that ice cream sales and drowning incidents both rise in summer. What analytical error does this illustrate?
Answer: Confusing correlation with causation
This illustrates confusing correlation with causation — both variables are driven by a common third factor (hot weather), but ice cream sales do not cause drownings; they are merely correlated.
What is the primary advantage of using a 'star schema' over a fully normalized schema in a data warehouse?
Answer: Star schemas simplify queries and improve read performance for analytical workloads
Star schemas denormalize dimension data into flat tables around a central fact table, which reduces the number of joins required for analytical queries and improves query performance for BI tools.
Which data visualization principle does the concept of 'data-ink ratio' (Edward Tufte) promote?
Answer: Maximizing the proportion of ink used to convey actual data versus decorative elements
Tufte's data-ink ratio principle states that every element of a visualization should serve a purpose in conveying data — excess gridlines, borders, and decorative elements ('chartjunk') should be removed.
What primarily distinguishes a snowflake schema from a star schema?
Answer: Dimension tables are normalized into related sub-tables
A snowflake schema normalizes dimension tables into multiple related tables, while a star schema keeps them denormalized.
A Type 2 slowly changing dimension handles a customer's address change by doing what?
Answer: Inserting a new row with effective dates or a current flag
Type 2 SCDs preserve full history by adding a new versioned row for each change.
A salary dataset contains a few extremely high executive salaries. Which measure of central tendency best represents a typical employee?
Answer: Median
The median is resistant to outliers, unlike the mean, which extreme values pull upward.
In an OLAP cube, moving from yearly sales totals to quarterly and then monthly figures is called what?
Answer: Drill-down
Drill-down navigates from summarized data to more detailed levels of a hierarchy.
In hypothesis testing, what is a Type I error?
Answer: Rejecting a null hypothesis that is actually true
A Type I error is a false positive: rejecting a true null hypothesis, with probability equal to alpha.
Scores of 100, 90, 90, 80 are ranked in descending order with SQL's RANK() function. What rank does the score of 80 receive?
Answer: 4
RANK() gives tied rows the same rank and skips the following numbers, so the ranks are 1, 2, 2, 4.
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- ikmnet.com — Test delivery, passing score · verified Oct 2026
- online.ikmnet.com — Eligibility, exam format, retake policy, score release, time limit · verified Oct 2026