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 a fact table in a data warehouse?
Answer: A central table storing measurable, numeric business metrics and foreign keys to dimensions
A fact table stores quantitative business metrics (like sales revenue or order quantity) along with foreign keys linking to dimension tables.
What is a snowflake schema in data warehousing?
Answer: A variation of the star schema where dimension tables are normalized into sub-dimensions
A snowflake schema normalizes dimension tables into multiple related tables, reducing redundancy at the cost of more complex joins.
What is the purpose of a BI semantic layer?
Answer: To provide a business-friendly abstraction layer between raw data and end users
A semantic layer translates technical database structures into business terms, allowing non-technical users to query data using familiar business concepts.
What is ad hoc reporting in business intelligence?
Answer: Custom, on-demand reports created by users to answer specific questions
Ad hoc reporting allows business users to create custom, one-time reports on demand without relying on IT, using self-service BI tools.
What does 'self-service BI' mean?
Answer: Empowering business users to access, analyze, and visualize data without IT assistance
Self-service BI enables non-technical business users to create reports, dashboards, and analyses without depending on IT or data engineers.
What is data governance in a BI context?
Answer: The framework of policies, processes, and standards ensuring data quality, security, and proper use
Data governance establishes the policies, roles, and procedures that ensure data is accurate, consistent, secure, and used appropriately across the organization.