Question | Answer |
What are computer-based systems that collect, store, and manipulate data? | IS (Information System) |
What does CRM stand for? | Customer Relationship Management |
What is the purpose of CRM? | Continuous Maintaining, Enhancing, and Improving Relationships with Customers |
What are the components of an Information System? | People, information, and Information Technology |
Hardware, software and networks are the three components of what? | Information Technology |
What is buyer power? | The ability of customers to influence the prices, (High if the buyer has many alternatives, lower if fewer) |
What impact do loyalty programs and switching costs have on buyer power? | Reduce buyer power |
What is the difference between direct and indirect database users? | Direct: Communicate directly through DBMS, Indirect: communicate through front end applications |
Which of Porter's models is used to determine the attractiveness of an industry? | Product Differentiation |
Redesigning and changing existing business processes is known as what? | Business Process Reengineering (BPR) |
A high what can make customers reluctant to switch to another product or service? | Switching Cost |
What is an ERP system? | Enterprise resources planning (ERP)—pre-made, integrated, corporate information system. ERP is one of the ways to achieve an integrated enterprise-wide information system |
What does SCM stand for? | Supply Chain Management |
What is used to support decision making without disrupting day-to-day operations? | Data warehouse |
What process do we use to find patterns in data? | Data mining |
What is the basic business database system that serves the operational level in an organization? | Transaction Processing System |
What is the general activity of updating, querying and presenting data from databases for operational purposes? | OLTP |
What is the general activity of updating, querying and presenting data from databases for analytical purposes? | OLAP |
The capability to consolidate, drill-down and slice and dice is offered by most of what type of tools? | OLAP |
In market basket analysis, how do you calculate support of A to C? | A&C/Total |
In market basket analysis, how do you calculate confidence of A to C? | A&C/A |
What is the most appropriate and fertile source of data for meaningful and effective data mining? | The enterprise-wide corporate data warehouse that contains all the information from the operational data sources that has analytical value |
Diagram the supply chain. What direction is upstream? What direction is downstream? | Supplier-Manufacturer-Distributor-Retailer-Customer. Upstream goes right to left; downstream goes left to right |
What are three e-business models? | Brick and Mortar, Click and Mortar, and Pure-Play EBusiness |
What do most ERP systems offer? | provides function-specific modules integrated into larger system. Typically processes that are same across industries. Reflect best industry practices of particular business process. Cannot fulfill all of info system needs. Deployment can be lengthy |
What is the difference between goal seek, solver, and scenario manager? | Goal Seek: trying to hit a goal by changing a single cell; Solver: Many different scenarios (Good day/bad day); scenario: similar to goal seek, but with multiple constraints and cells |
Describe and define all data quality characteristics. First 3: | Accuracy: extent to which data correctly reflects real-world instances it is supposed to show; Uniqueness: requires each instance to be represented only once in data collection; Completeness: degree to which all required data is present in data collection |
Describe and define all data quality characteristics. Last 3: | Consistency: extent to which data properly conforms to & matches up w/ other data; Timeliness: degree to which data is aligned w/ proper time window in its representation of real world; Conformity: extent to which the data conforms to its specified format |
True or false: Buyer power is low when buyers have many options? | False |
What kind of threat occurs when there are many alternatives to a product or service? | Threat of Substitutes |
What term is used to describe quantifiable measurements that are agreed to beforehand, and which reflect the critical success factors of an organization? | KPI |
What type of information encompasses all of the information contained within a single business process or unit of work? Its primary purpose is to support daily operational tasks. | Transactional |
What type of information encompasses organizational information, with the primary purpose being to support the performing of managerial analysis? | Analytical |
How do you determine the number of table in an ER diagram? | Count the amount of entities and many-to-many relationships |
How do you determine the number of columns/fields in a table from an entity in an ER diagram? | Count the attributes for each entity |
What error occurs in a database if a name is spelled incorrectly? | Accuracy |
What error occurs in a database if the area code is missing from a phone book? | Completeness |
What error occurs in a database if an entity is entered multiple times? | Uniqueness |
What error occurs in a database if the information to be entered falls outside the relevant timeframe? | Timeliness |
What is the manufacturer in relation to the supplier? | Downstream |
What are the 3 OLAP operations? | Slice and Dice, Pivot, and Drill Down/Drill Up |
What OLAP operations will result in more data being displayed? | Drill Down |
What OLAP operations will result in less data being displayed? | Drill Up, Slice and Dice |
What is the difference between direct and indirect interaction with a database? | Indirect: user communicating with the database through front-end applications; Direct: user communicating with the database directly through DBMS |
T or F: Data generated by a customer transaction can exist in both the operational database as well as the data warehouse. | True |
What impact do loyalty programs have on buyer power? | Lowers the chance of customers switching to someplace else |
Do I see more or less data when I slice and dice data? | Less |
Do I see more or less data when I pivot data? | Same |
Do I see more or less data when I drill down? | More |
Do I see more or less data when I drill up? | Less |