SIT Test 2
Sustainable, or "green," MIS
production, management, use, and disposal of technology in a way that minimizes damage to the environment
What is data that humans, in interaction with computers, generate?
unstructured data
Database
collection of related tables
Warm site
computer equipment, but requires installation and configuration
What is it called when a manager has so much data and information that he or she cannot make a decision?
data rich, information poor
Hybrid Cloud
mix of private, public or community ex: private cloud of the company and a public cloud for customers, suppliers and partners financials on a private cloud and the rest of the company on a public cloud
Public cloud
multi-tenancy off-premise several organizations ex: amazon EC2, Windows azure save money
Community cloud
multi-tenancy off-premise several organizations ex: private hospital, all Colorado state gov't organizations pharmaceuticals and financial services
In a data warehouse information is:
multidimensional with layers
Cold site
no computer equipment just a place for employees
Cloud sharing sites
outright.com (accounting and finance) box.com
Backup and Recovery Plan
Hot site Cold site Warm site
Agile MIS infrastrucure
Support 50% growth- If an organization grows by 50 percent in a single year, its systems must be able to handle a 50 percent growth rate.
Analytical CRM
Supports back-office (accounting, finance, human resources, data warehouses, business intelligence) operations and strategic analysis
broad network access
all devices can access data and applications
Enterprise Resource Planning or ERP software packages can be purchased from several companies including
all of the above
In which of the five basic supply chain activities do you build relationships with suppliers to procure raw materials?
source
rapid elasticity
storage, network bandwidth, and computing capacity can be increased or decreased immediately, allowing for optimal scalability
infrastructure as a service
A service that delivers hardware networking capabilities, including the use of servers, networking, and storage over the cloud using a pay-per-use revenue model. No software. ex: Amazon EC2
Characteristics of an agile MIS infrastructure
Accessibility Availability - five 9's Maintainability - flexibility Portability - Mac, PC Reliability - Accurate Scalability - Growth Usability - iPod click wheel
Which of the following lists include all of the five characteristics common to high-quality information?
Accuracy, completeness, consistency, timeliness, and uniqueness
Which of the following occurs when everyone involved in sourcing, producing, and delivering the company's product works with the same information in an ERP system like SAP?
All of these are correct
Accenture Management Consulting
As-Is (2001) 200 different legacy financial applications WW To-Be (2004) Big-Bang SAP FI/CO implementation, Single-Instance, 2,500 licenses for core users Ride SAP applications for 2 or 3 versions Governance - project prioritization based on ROI. Predicted value Vs. Realized value Workforce doubled, IT expenses down 60%
Accenture - split audit and management consulting
As-Is (2001) 600 global and 1,500 local applications Complex, patchwork of legacy systems To-Be (2004) Single-vendor approach, simplify, rationalize SAP (Finance and HR) and Microsoft (Windows, Outlook e-mail and SQL DB) Outsource 86% to low cost regions. Only 14% permanent IT staff. Virtualization 250 to 115
Jet Blue and Dodge have both learned that because of social media today:
Both of the above
The main reasons for ERP failures include:
Both of the above
Advanced analytics
Focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization.
Production and materials management components of ERP
handle the various aspects of production planning and execution such as demand forecasting, production scheduling, job cost accounting, and quality control
Which ERP component can help an organization determine such things as the identification of individuals who are likely to leave the company unless additional compensation or benefits are provided?
human resource components
A sustainable MIS infrstructure
identifies ways that a company can grow in terms of computing resources while simultaneously becoming less dependent on hardware and energy consumption.
Logistics (Inbound & Outbound)
includes the processes that control the distribution, maintenance, and replacement of materials and personnel to support the supply chain Inbound logistics acquires raw materials and resources and distributes them to manufacturing as required. Outbound logistics distributes goods and services to customers ex: drones, radio frequency identification
The example the book gave of www.EllisIsland.org, which generates more than 2.5 billion hits, is a site that offers a database that can easily adjust to handle massive volumes of information. What is this an example of?
increased scalability and performance
Analytical CRM can help you determine which type of marketing and sales campaign to launch and which customers to target so that you can achieve uplift. Uplift means?
increasing sales
This allows separate systems to communicate directly with each other, eliminating the need for manual entry into multiple systems?
integration
What did the UK Defense department do so that they did not have to do manual entry into multiple databases?
integration
Application integration
integration of a company's existing management information systems.
Data integration
integration of data from multiple sources, which provides a unified view of all data
Procurement
is the purchasing of goods and services to meet the needs of the supply chain. ex: 3D Printing
What is one of the biggest pitfalls associated with real-time information?
it continually changes
What is the primary tool that retrieves information and helps managers graphically design the answer to a question?
query-by-example tool
How would the banking industry use business intelligence?
understand customer credit card usage and nonpayment rates
Drones are now being used by Amazon to support logistics. What are drones?
unmanned aircraft that can fly autonomously, or without a human
In big data analytics more data is typically _______ than _______.
unstructured (80%); structured (20%)
Eintegration
use of the Internet to provide customers with the ability to gain personalized information by querying corporate databases and their information sources.
Kaiser
used CRM to enforce more rigorous eye-screening for diabetic patients
On-demand self-service
users can increase storage and processing power as needed
What is supply chain visibility?
views all areas up and down the supply chain in real time like at GBI Bikes
Transactional information examples
withdrawing cash from an ATM, making an airline reservation, purchasing stocks, daily sales, hourly employee payroll, product orders, shipping an order
Data center
(Server farm), A facility used to house MIS including telecommunications and storage systems Google, Microsoft, Amazon - Columbia River in the North West
Foreign key
A primary key of one table that appears an attribute in another table
Three most common core ERP components
1. Accounting and finance FI/CO 2. Production and materials management MM/PP 3. Human resource HR
Three main links of supply chain
1. Materials flow from suppliers 2. Transformation of materials into products 3. Distribution of products to customers
Instead of shipping parts from Germany, Porsche uses what new local procurement process, building parts layer by layer in an additive process - a three-dimensional solid object from a digital model?
3D Printing
Server
A computer dedicated to providing information in response to requests
Three key main integration tools include:
All of the above CRM ERP SCM
Article - Strategic IT Transformation Accenture (World's largest Management Consulting Organization)
As-Is (2001) Anderson Consulting became > Accenture IT is a cost center, decentralized, mixed approach, legacy systems To-Be (2004) (Best-of Breed or One Platform?) New IT Infrastructure, One-Firm approach, centralized, business within a business Support business requirements
MIS infrastructurre supporting operations
Backup and recovery plan - weekly Disaster recovery plan Business continuity plan
Kaplan and Norton developed the _______ so that companies could measure ERP success as well as to clarify their strategy and translate it into action.
Balanced scoreboard
What is it called when distorted product-demand information like Dodge Dealers discounting Vipers and artificially increasing demand, ripples from one partner to the next throughout the supply chain?
Bullwhip effect
Which application's primary business benefits include sales forecasts, sales strategies, and marketing campaigns?
CRM
What is an organization performing when it asks CRM questions such as "who are our best and worst customers"?
CRM analyzing technologies
What is an organization performing when it asks CRM questions such as "which customers are at risk of leaving"?
CRM predicting technologies
Corporate social responsibility
Companies' acknowledged responsibility to society
Hardware
Consists of the physical devices associated with a computer system
Which of the choices below does not represent an organization that requires up-to-the-second information?
Construction companies
The data warehouse compiles information from internal databases and external databases through _______.
ETL
What is the key word in ERP? Hint: You have one single database for the entire _______.
Enterprise
Which of the following occurs when the same data field has different values?
Information inconsistency issue
What do data warehouses support?
Only analytical processing (OLAP): business analysis and decision-making both a and b
What is a real-time system?
Provides real-time information in response to query requests
Sustainable data centers
Quincy, Washington Reduces carbon emissions - hydroelectricity, not coal Reduces required floor Space - MS = 10 football fields Chooses Geographic location - cheap land, electricity
3 Evolution's of CRM
Reporting - Identify customers across other applications Analysis - Segment customers - best and worst customers Predicting - Make predictions - which customers are at risk of leaving?
Which of the following was one of the first CRM components built to address the issue that sales representatives were struggling with overwhelming amounts of customer account information that they were required to maintain and track in the sales process?
Sales force automation system
Cloud computing
Stores, manages, processes data and applications over the internet Easy for SME to gain access to LE computing power!
Downstream SCM
Supplier-> Customer
Software
The set of instructions the hardware executes to carry out specific tasks
Which of the following are examples of transactional information?
airline tickets, sales receipts, and packing slips
Union Bank of California
created a disaster recovery plan that includes multiple data centers in diverse locations, mirrored sites which can take over at the flick of a switch, hot sites - where staff can walk in and start working exactly as they would if they were in their normal location - and a vast amount of redundancy.
Effective and efficient supply chain management systems can enable Procter & Gamble to:
decrease buyer power increase supplier power increase switching costs create entry barriers increase efficiencies- competitive advantage all of these are correct
What is erroneous or flawed data?
dirty data
Walmart and Procter & Gamble (P&G) implemented a tremendously successful SCM system. The system linked Wal-Mart's ________ centers directly to P&G's ________ centers.
distribution; manufacturing
Nestle had poor information and was unable to evaluate its business effectively. The problem was that its 9 million records including 550,000 vendors were:
duplicated inaccurate incomplete all of the above
What is information redundancy?
duplication of data storing the same data in multiple places storing duplicate data in multiple places All of these are correct.
What is data mining?
extracting information to find trends and patterns and relationships in large volumes of information
Materials management
includes activities that govern the flow of tangible, physical materials through the supply chain such as shipping, transport, distribution, and warehousing. ex: robotics
What is dynamic information?
includes data that change based on user action
Data visualization uses _______ that display information graphically so that it can be more easily understood.
infographics- periodic table of elements
In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?
record
Which of the following stores information about a person, place, thing, transaction, or event?
record
Charles Schwab
recouped the cost of a multimillion-dollar CRM system in less than two years. System segmented its customers in terms of serious and nonserious investors
Cube
representation of multidimensional information
Forward integration
sends information entered into a given system automatically to all downstream systems and processes
Backward integration
sends information entered into a given system automatically to all upstream systems and processes
SCM disruptive technologies
3D printing Radio frequency identification Drones Robotics
Using CRM to measure success effectively, only requires tracking _______ sales, marketing or customer service metrics.
5 to 7
Through data mining, Best Buy discovered the pattern/trend that _______ of their customers were responsible for _____ of their sales.
7, 43
Client
A computer designed to request information from a server
Why is the ability to look at information based on different dimensions critical to a businesses success?
Ans: The ability to look at information from different dimensions can add tremendous business insight By slicing-and-dicing the information a business can uncover great unexpected insights
Record
Collection of related fields - person, place, thing, transaction one customer
Table
Collection of related records
Who is the person responsible for creating the original website content?
Content creator
Virtualized Computing
Creates multiple "virtual" machines on a single computing device (SAP -1,400 servers) Multiple OS + multiple SW applications
Upstream SCM
Customer-> Supplier
What is the cost to the business of sending multiple identical marketing materials to the same customers?
Expense Risk of alienating customers
Which of the following is not one of the three main integration tools?
FI
Which of the following creates, reads, updates, and deletes data in a database while controlling access and security?
Database management system
Software as a service
Delivers applications over the cloud using a pay-per-use revenue model.
Which of the following would not be considered part of the timely characteristic of high-quality information?
Is the zip code missing in the address?
What is the primary problem with redundant information?
It is difficult to determine which values are the most current. It is often inconsistent. It is difficult to determine which values are the most accurate. All of these are correct.
If you were looking for an ERP or Enterprise Resource Planning software package specifically for a small enterprise _______ might be the best company or vendor to look into.
NetSuite
Which of the following is a common CRM sales metric?
Number of new customers
Which city did Golfsmith discover through BI; was the worst possible location for a new mega golf store?
Phoenix
Organizations can find their most valuable customers through RFM, which stands for?
Recency (how recently a customer purchased items), frequency (how frequently a customer purchased items), monetary value (the monetary value of each customer purchase)
Which of the following systems allow users to create, read, update, and delete data in a relational database?
Relational database management system
Organizations that use CRM to increase sales and improve operations
Ritz-Carlton Hotels Harrah's Harley-Davidson
Platform as a service
Supports the deployment of entire systems including hardware, networking, and applications using a pay-per-use revenue model
Cloud fabric
The software that makes possible the benefits of cloud computing, such as multi-tenancy
What is a primary key?
a field that uniquely identifies a given record in a table
Jay Wright works at a top accounting firm in Salt Lake City and his responsibilities include writing letters, memos, and emails along with generating reports for financial analysis and marketing materials for products. Jay's duties provide value-add to his company and would be categorized as occurring at the different information ________.
formats
Hot site
fully equipped facility, resume business immediately, NY, SF
A data warehouse:
logical collection of information - from many different operational databases Supports business analysis and decision-making all of the above
A data warehouse is a ________ collection of information, gathered from many different ________ databases, that supports business analysis activities and decision-making tasks.
logical; operational
Accounting and finance components of ERP
manage accounting data and financial processes within the enterprise with functions such as general ledger, accounts payable, accounts receivable, budgeting, and asset management
QBE or Query By Example is a query methodology in Access used primarily by
managers
MIS infrastructure
plans to build, deploy, use, and share data, processes, and MIS assets ex: hardware, software, networrk, client- requests info., serve- provides info.
Imagine you need to find information on customer Steve Smith. You may have 20 customers with the same name so a _______ helps to identify each record uniquely.
primary key
What is procurement?
purchase goods and services like large McDonald's potatoes to meet the needs of the supply chain
Field
single unit of data customer name, address, email
Which of the following occurs when everyone involved in sourcing, producing, and delivering the company's product works with the same information in an ERP system like SAP?
-Eliminates redundancies -Cuts down wasted time -Removes misinformation all of these are correct
Grid Computing
A collection of computers, geographically dispersed, coordinated to solve a common problem
Network
A communications system created by linking two or more devices and establishing a standard methodology in which they can communicate
Enterprise architect
A person grounded in technology, fluent in business, and able to provide the important bridge between MIS and the business
Which software application's primary business benefits include forecasting, planning, purchasing, material management, warehousing, inventory, and distribution?
ERP
Single-tenancy
Each customer must purchase individual system
What takes information entered into a given system like sales, and sends it automatically to all downstream systems and processes like billing?
Forward integration
Forward/backward integration of customer information
Forward: Sales system-> Order entry system-> Order fulfillment system-> Billing system Backward: Billing system-> Order fulfillment system-> Order entry system-> Sales system
Three components of a sustainable MIS infrastructure
Grid computing Virtualized computing Cloud computing
Harley-Davidson
Has obtained great success through CRM
Three Primary Side Effects Of Businesses' Expanded Use Of Technology
Increased electronic waste Increased energy consumption Increased carbon emissions
Database advantages
Increased flexibility Increased scalability and performance Reduced information redundance Increased information security Increased information integrity
Reasons ERP systems are powerful tools include?
Logical solution to incompatible applications Global information sharing and reporting Avoid pain and expense of fixing legacy systems all of the above
Dynamic scaling
Means that the MIS infrastructure can be automatically scaled up or down based on needed requirements.
In 2015, a tiered ERP architecture can include:
On premise - ERP system - HQ On demand - Cloud ERP applications - mobility On device all of the above
Which CRM system supports the traditional transactional processing for day to day front office customer transactions?
Operational CRM
The benefits of CRM
Organizations can find their most valuable customers through RFM
Which of the following is not one of the three phases in the evolution of CRM?
Processing
What is the purchasing of goods and services such as large McDonald's potatoes, to meet the needs of the supply chain?
Procurement
Three components of supply chain management
Procurement Logistics Materials management
Which of the following is an example of Analytical information?
Product statistics Trend projection Sales projection Both B and C'
One of the primary goals of a database is to eliminate information redundancy by recording each piece of data in only one place in the database. What does the elimination of information redundancy do for a database?
Reduces disk space requirements Makes updating information easier Improves information quality all of the above
Which of the following is an extended ERP componenet?
SCM CRM BI all of these are correct
DreamWorks Shrek
Shrek 1 = 5 million computer hours Shrek 2 = 10 Shrek 3 = 20
Operational CRM
Supports traditional transactional processing for day-to-day front-office (customers)
What is enterprise resource planning?
The integration of all departments and functions throughout an organization into a single IT system so that employees can make decisions by viewing enterprise wide information on all business operations.
What is customer relationship management (CRM)?
a means of managing all aspects of a customer's relationship with an organization to increase customer loyalty and retention and an organization's profitability
Multi-tenancy
a single instance of a system serves multiple customers - Financials? Customers share pooled computing resources
Green Computing
Using computing resources efficiently - PCs, Servers... Power management / energy efficient devices - TBL,3BL,PPP Alternative energy sources for powering and cooling - Google barges
What occurs when a website can know enough about a person's likes and dislikes that it can fashion offers that are more likely to appeal to that person?
Website Personalization
Which question below represents a CRM reporting technology example?
What is the total revenue by customer?
Which question below represents a CRM analyzing technology question?
Why did sales not meet forecast?
What is the primary difference between a database and data warehouse?
a database stores information for a single application, whereas a data warehouse stores information from multiple databases, or multiple applications, and external information such as industry information
Who are the primary users of ERP systems? Hint: They use the SAP FI, CO, MM and PP modules.
accounting, finance, logistics, and production
Which of the following is one of the three business areas of supply chain management?
all of the above
Several historic large ERP failures include:
all of the above software customization, cost Nike, Hershey, K-Mart
Which of the following encompasses all organizational information, and its primary purpose is to support the performing of managerial decisions and analysis tasks?
analytical information
How would the marketing industry use business intelligence?
analyze customer demographic
How would the airline industry use business intelligence?
analyze popular vacation locations with current flight listings
Which of the following is not one of the three most common core ERP components focusing on internal operations?
business intelligence
Most people request real-time information without understanding that continual ________ is one of its biggest pitfalls.
change
Measured service
clients can monitor and measure transaction and use of resources
Gordon Moore
co-founder of Intel, the world's largest producer of computer chips or microprocessors, observed in 1965 that continued advances in technological innovation made it possible to reduce the size of a computer chip (the brains of a computer, or even a cell phone now) while doubling its capacity every two years.
Which of the following implies that aggregate or summary information is in agreement with detailed information?
consistency
What type of website like Zappos is an interactive website kept constantly updated and relevant to the needs of its customers using a database?
data-driven website
What is at the heart or center of any ERP system so that you have one version of the truth?
database
Private cloud
single-tenancy on-premise one organization ex: bank, gov't, corporation use if you are worried about your finances
Moore's Law
smaller, faster, cheaper - chip performance per dollar doubles every 18 months
What modifies existing software according to the business's or user's requirements?
software customization
SCM stands for:
supply chain management
What is enterprise resource planning (ERP)?
the integration of all departments and functions throughout an organization into a single IT system (or integrated set of IT systems) so employees can make decisions by viewing enterprisewide information about all business operations EX: SAP, Sage, NetSuite
What is supply chain management (SCM)?
the management of information flows between and among activities in a supply chain to maximize total supply chain effectiveness and corporate profitability
Some of the serious business consequences that occur due to using low-quality information to make decisions are all of the following except:
the success of the organization depends on appreciating and leveraging the low-quality information.
Why do relational databases use primary keys and foreign keys?
to create logical relationships
Human resource components of ERP
track employee information including payroll, benefits, compensation, performance assessment, and assumes compliance with the legal requirements of multiple jurisdictions and tax authorities
Which of the following represents sales force automation?
tracking all of the steps in the sales process automatically
What encompasses all of the information contained within a single business process or unit of work and its primary purpose is to support the performing of daily operational tasks?
transactional information
Analytical information examples
trends, sales, product statistics, future growth projections, cost/benefit analysis, sales forecast, market trends, industry trends and regulations
Which of the following is an advantage of using a data-driven website like Zappos?
• Easy to eliminate human errors • Easy to manage content • Easy to store large amounts of data all of the above