Download CIS 405 Exam 1 With Correct Answers and more Exams Business Informatics in PDF only on Docsity!
CIS 4 05 Exam 1 With
Correct Answers
What is Analytics? - ANSWER Computerized support for managerial decision making. It concentrates the theoretical and conceptual foundations of decision support as well as the commercial tools and techniques that are available
What is Business Intelligence (BI)? - ANSWER A conceptual framework for decision support. It combines architecture, databases (or data warehouses), analytic tools, and applications; transformation process
BI is a content-free expression ___ - ANSWER so it means different things to different people
What is BI's major objective? - ANSWER To enable easy access to data (and models) to provide business managers with the ability to conduct analysis
Sequence of BI - ANSWER Transform data, to information (and knowledge), to decisions, and finally to action
What are the four major components of BI Architecture? - ANSWER A data warehouse, business analytics, business performance management, a user interface
A data warehouse is - ANSWER A large store of data accumulated from a wide range of sources within a company and used to guide management decisions; source data
Business analytics is - ANSWER A collection of tools for manipulating, mining, and analyzing the data in the data warehouse; transform data into knowledge
Business performance management (BPM) is - ANSWER Also referred to as corporate performance management (CPM), is an emerging portfolio of applications within the BI framework that provides enterprises tools they need to better manage their operations; Monitoring and analyzing performance; not just data, but also managerial decisions
A user interface is - ANSWER A dashboard; provide a comprehensive graphical/pictorial view of corporate performance measures, trends, and exceptions
What does OLTP stand for? - ANSWER Online Transaction Process
What does OLAP stand for? - ANSWER Online Analytic Process
What does OLTP do? - ANSWER -Capturing and storing data from ERP, CRM, POS, etc.
-The main focus is on efficiency of routine tasks
-"Get the Data"
What does OLAP do? - ANSWER -Converting data into information for decision support
-Data cubes, drill-down / rollup, slice & dice, ...
-Requesting ad hoc reports
-Conducting statistical and other analyses
-Developing multimedia-based applications
subject-oriented databases designed to support DSS functions, where each unit of data is non-volatile and relevant to some moment in time
What are characteristics of data warehousing? - ANSWER -Subject orientated, integrated, time variant (time series), nonvolatile, not normalized (this is a critical difference between an operational database and a warehouse), metadata (what is stored, how do you know what it is and how to access/retrieve/define it?)
-Web based, relational/multi-dimensional
-Client/server, real-time/right-time/active ...
What is a Data Mart? - ANSWER A departmental small-scale "DW" that stores only limited/relevant data; a piece of the pie for specific investigations, more or less.
What is a dependent data mart? - ANSWER A subset that is created directly from a data warehouse. Advantage: consistency, quality
What is a independent data mart? - ANSWER A small data warehouse designed for a strategic business unit or a department
What are Operational Data Stores (ODS)? - ANSWER A type of database often used as an interim area for a data warehouse
What are Oper Marts? - ANSWER An operational data mart. Multidimensional analysis of immediate operational data
What is an Enterprise Data Warehouse (EDW)? - ANSWER A data warehouse for the enterprise
What is Metadata? - ANSWER Data about data. In a data warehouse, metadata describe the contents of a data warehouse and the manner of its acquisition and use
What is three tier architecture? - ANSWER -Data acquisition software (back-end)
-The data warehouse that contains the data & software
-Client (front-end) software that allows users to access and analyze data from the warehouse
What is two tier architecture? - ANSWER -First two tiers in three-tier architecture is combined into one
Pros and cons of three tier architecture - ANSWER -Operational system has the data and data acquisition software at one level
What is Dice (OLAP Operations)? - ANSWER A slice on more than two dimensions
What is Drill Down/Up (OLAP Operations)? - ANSWER Navigating among levels of data ranging from the most summarized (up) to the most detailed (down)
What is Roll Up (OLAP Operations)? - ANSWER Computing all of the data relationships for one or more dimensions
What is Pivot (OLAP Operations)? - ANSWER Used to change the dimensional orientation of a report or an ad hoc query-page display
What is a Report? - ANSWER A written document that contains information regarding business matters; Used to guide and improve managerial decisions
What are the functions of a report? - ANSWER -To provide information (decision support)
-To provide the results of an analysis
-To persuade others to act
-To ensure proper departmental operation
-To create an organizational memory (KM)
What are the different types of business reports? - ANSWER Metric Management Reports, Dashboard-Type Reports, Balanced Scorecard-Type Reports
What is a Metric Management Report? - ANSWER Help manage business performance through metrics (SLAs for externals; KPIs for internals); Can be used as part of Six Sigma and/or TQM
What is a Dashboard-Type Report? - ANSWER Graphical presentations of several performance indicators in a single page using dials/gauges
What is a Balanced Scorecard-Type Report? - ANSWER Include financial, customer, business process, and learning & growth indicators
1900's history of data visualization - ANSWER -More formal attitude toward visualization
-Focus on color, value scales, and labeling
-Publication of the book Semiologie Graphique
2000's history of data visualization - ANSWER -Emergence of Internet as the
