Exam 7: Accounting and Business Intelligence
What is the integrative decision model?
The integrative decision model (IDM)provides a framework to structure and organize the decision-making process. IDM integrates consideration of both quantitative factors, such as dollars of revenue and costs, and qualitative factors that cannot be quantified in dollars. Qualitative factors might include product quality or customer satisfaction. An IDM spreadsheet template includes both quantitative (financial)and qualitative (non-financial)analysis.
As the business environment becomes more complex and diverse, more and more factors must be considered when making decisions. For example, as environmental considerations, diversity, and corporate social responsibility are increasingly considered when evaluating a firm's performance, enterprises may include these factors in the decision process. Some of these considerations cannot be quantified in dollars, however. Though difficult to place a dollar amount on the factor, there are times when the factor can be overriding, such as for product safety.
The IDM serves to integrate both qualitative and quantitative factors into the decision. This process of integrating financial and non-financial factors into the decision process can improve the quality of the decision.
Why can data in a dimensional database with a star or snowflake structure be retrieved more quickly than from a relational database?
Because of the database structure. In a relational database, a query may be required to traverse many tables. The more tables required to locate the data, the more time required to run the query. In a star structured database, a query will traverse only two database tables. In a snowflake structure, a query will traverse, at the most, three database tables.
What are some of the data analysis tools available for software spreadsheets, such as MS Excel?
Foreign keys in a dimensional table are primary keys in a fact table.
The purpose of integrating quantitative and qualitative factors in the decision making process is to
A ________ graphically represents BI, allowing the user to manipulate data and view the resulting changes.
Business intelligence technologies are typically under the control of the enterprise's IT professionals.
Business Intelligence Technologies are a type of advanced data analytics used to support business decision making.
Uninformed consumers drive enterprises to use their information assets in more intelligent ways.
A dimensional database has one ________ table and two or more dimension (Dim)tables.
The dimension tables in a star database are dimensions of the database, such as time dimension, product information, sales territory, and currency.
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)