2024/ WGU C175 Study Notecards, Exam Review Questions and answers, VERIFIED.

WGU C175 Study Notecards, Exam Review Questions and answers, VERIFIED. What are the values of Business Intelligence? - -- Financial value associated w/ increased profitability. - Productivity value associated with increased throughput. - Trust value (customer, employee, supplier satisfaction) as well as increased confidence in forecasting. - Risk value - decreased risk associated with decision making What are the reasons for using the Dimensional Model for Business Intelligence? - -- Simplicity. - Lack of bias. - Extensibility. What are the fundamental aspects of a Data Warehouse? - -- Centralized repository of information. - Organized around relevant subject areas. - Provides platform for queries. - Used for analysis and not transactional processing. - Data is nonvolatile. - Target location for integrating data from multiple sources. What is the general theme of the ETL process? - -1. Get the data 2. Map the data to staging area 3. Validate and clean the data 4. Apply necessary transformations 5. Map data to loading model 6. Move data to repository 7. Load data to warehouse What is the key factor based on the need for linear scalability? - -Performance What is used for populating summaries or any cube dimensions that can be performed at the staging area (ETL)? - -Aggregation What data mining activity is a process of assigning some continuously valued numeric value to an object? - -Estimation