Business Intelligence Flashcards
6 cards from real Data and Analytics practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Business Intelligence flashcards as text
What is OLAP in business intelligence?
Answer: Online Analytical Processing for multidimensional analysis
OLAP (Online Analytical Processing) enables fast, multidimensional analysis of large datasets by organizing data into cubes for slicing, dicing, and drilling.
What is a star schema in data warehousing?
Answer: A central fact table connected to multiple dimension tables
A star schema has a central fact table containing measurable metrics connected to multiple denormalized dimension tables, optimized for analytical queries.
What is the difference between OLTP and OLAP systems?
Answer: OLTP handles real-time transactions; OLAP handles analytical queries on historical data
OLTP (Online Transaction Processing) systems handle high-volume day-to-day transactions, while OLAP systems are optimized for complex analytical queries on historical data.
What is a dimension table in a data warehouse?
Answer: A table storing descriptive attributes used to filter and group fact data
Dimension tables contain descriptive attributes (like customer name, product category, or date) used to provide context and filtering for measures in fact tables.
What is a slowly changing dimension (SCD) in data warehousing?
Answer: A technique for managing historical changes to dimension attributes over time
SCD (Slowly Changing Dimension) is a method for handling changes to dimension attributes over time, preserving history of how values changed.
What does 'drill down' mean in OLAP analysis?
Answer: Moving from a summary view to a more detailed level of data
Drilling down navigates from a higher-level summary (e.g., annual sales) to a more granular level (e.g., monthly or daily sales).