IKM Data Analysis and Business Intelligence

Question 1

Which type of data analysis focuses on understanding what happened in the past by examining historical data?

Accepted Answer

Descriptive analysis

Answer

Descriptive analysis summarizes historical data to answer 'what happened,' making it the foundational type of business intelligence reporting.

Question 2

In a data warehouse, what is a 'fact table'?

Accepted Answer

A table that stores the measurable, quantitative data for analysis

Answer

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.

Question 3

What does ETL stand for in the context of data warehousing?

Accepted Answer

Extract, Transform, Load

Answer

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.

Question 4

A KPI dashboard shows sales are 15% below target. Which analytical step should be taken next to investigate further?

Accepted Answer

Diagnostic analysis to identify root causes of the shortfall

Answer

Diagnostic analysis answers 'why did it happen' by drilling down into data to uncover root causes of a deviation from targets.

Question 5

What is a 'dimension table' in a star schema data model?

Accepted Answer

A table containing descriptive attributes used to filter or group facts

Answer

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.

IKM - International Knowledge Measurement Practice Test

IKM - International Knowledge Measurement Practice Test

IKM Data Analysis and Business Intelligence