Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
70 Cards in this Set
- Front
- Back
What is Business Intelligence?
|
-A broad category of applications, technologies, and processes for gathering, storing, accessing, and analyzing data to help business users make better decisions
|
|
What are examples of BI systems that you might have used?
|
-Individuals may have used small-scale BI applications, such as Excel spreadsheets to provide some BI functions
|
|
What can add BI capabilities to Microsoft Excel, allowing the program to interact with other tools and databases, creating ““Excel on steroids”?
|
-Plug-ins
|
|
What is management?
|
- A process by which an organization achieves its goals through the use of resources
|
|
List the Decision Making steps in order.
|
- Input
- Process (Management) - Output |
|
Input involves?
|
- People
- Money - Materials - Information |
|
Process (management) involves what?
|
- Interpersonal roles
- Informational roles - Decisional roles |
|
Output means
|
- Achieving the organization's goals
|
|
Explain the meaning of "decision".
|
- A choice among two or more alternatives made by individuals and groups
- Diverse in nature and made continuously. - Decision making is a systematic process |
|
Explain the Phases of the Decision Making Process.
|
-First, is Examination or Intelligence Phase (what is the problem)
- Second, is Validation of the Model or Design Phase (what are my options) - Third, is Verification, Testing of the Model or Choice Phase (Pick an option and decide how to implement it.) - Fourth, is Implementation of Solution - 5th, ask "Did my option work as proposed" - If no, it was a failure then you must repeat phases. - If yes, then it was a sucess - All based off REALITY. |
|
Why do Managers need IT support? (4 reasons)
|
- The number of alternatives to be considered increases constantly.
- Decisions must be made under time pressure. - Decisions are becoming more complex. - Decision makers can be situated in different locations, as can the information they need |
|
What information technologies are available to support managers?
|
- Computer hardware
- software - Electronics - Semi-conductors - Internet - Tele-com equipment - E-commerce - Computer services |
|
What are the three types of problem structures of decisions?
|
- Unstructed( Fuzzy, complex problems with no-cut-and dried procedures and solutions)
- Semistructured - Structured (Routine and competitive problems with standard procedures and solutions |
|
What are the two dimensions of decisions?
|
- Problem structures
- The nature of decisions |
|
What are three types of nature of decisions?
|
- Operational control (Executive specific tasks efficiently and effectively)
- Management control (Acquiring and using resources efficiently in accomplishing organizational's goals) - Strategic planning (Long-range goals and policies for growth and resource allocation |
|
What is the decision making framework used for unstructured decisions within operational control? And which managers perform these tasks?
|
- Accounts receivable, order entry
- Lower-level managers -1 |
|
What is the decision making framework used for unstructured decisions within management control? And which managers perform these tasks?
|
- Budget analysis, short-term forecasting, personnel reports, make-or-buy analysis
- Lower-level managers - 2 |
|
What is the decision making framework used for unstructured decisions within strategic planning? And which managers perform these tasks?
|
- Financial management (investment)
- Warehouse location - Distribution Systems - Middle managers and staff -3 |
|
What is the decision making framework used for semistructured decisions within operational control? And which managers perform these tasks?
|
- Production scheduling, inventory control
- Lower level managers -4 |
|
What is the decision making framework used for semistructured decisions within management control? And which managers perform these tasks?
|
- Credit evaluation, budget preparation, plant layout, project scheduling, reward systems design
- Middle managers and staff -5 |
|
What is the decision making framework used for semistructued decisions within strategic planning?And which managers perform these tasks?
|
-Building new plant, mergers and acquisitions, new product planning, compensation planning, quality assurance planning
- Senior executives - 6 |
|
What is the decision making framework used for structured decisions within operational control? And which managers perform these tasks?
|
-Selecting a cover for a magazine, buying software, approving loans
- Middle managers and staff - 7 |
|
What is the decision making framework used for structured decisions within management control? And which managers perform these tasks?
|
- Negotiating, recruiting an executive, buying hardware, lobbying
- Senior executives - 8 |
|
What is the decision making framework used for structured decisions within strategic planning? And which managers perform these tasks?
|
- R & D planning, new technology development, social responsibility planning
- Senior Executives - 9 |
|
What support is needed for unstructured decisions?
|
- MIS, management science models, financial and statistical models
|
|
What support is needed for semistructured decisions?
|
- DSS
|
|
What support is needed for structured decisions?
|
- DSS, ES, neural networks
|
|
What support is needed for operational control decisions?
|
- MIS, management science
|
|
What support is needed for management control decisions?
|
- Management science, DSS, EIS , ES
|
|
What support is needed for strategic planning decisions?
|
- EIS, ES, neural networks
|
|
What are some popular BI software vendors?
|
- SAS, Hyperion, Business Objects, SPSS, COGNOS, Information Builders
|
|
What is involved in the scope of BI?
|
- Small organizations (Excel spreadsheet)
- Large organizations (Data mining/predictive analysis, dashboard, data visualization) |
|
What levels of change are involved in the data mart BI system?
|
-Develop a single or a few, related BI applications
(target a point solution for a departmental need) |
|
What levels of change are involved in the enterprise data warehouse? (2)
|
-Develop infrastructure to support enterprise-wide BI
(support current and future BI needs) -Support for organizational transformation (transform the ways a company competes in the market) |
|
What are BI applications for Data Analysis?
|
- Multidimensional analysis or online analytical processing (OLAP)
- Data mining - Decision support systems (DSS) |
|
Explain online analytical processing (OLAP).
|
- Also called multidimensional analysis
-Provides users with a look at what is happening or what has happened -Allows users to analyze data in such a way that they can quickly answer business questions - Ex. Fig 3-11 Data Cube |
|
Define data mining and explain its two basic operations.
|
-The process of searching for valuable information in a large database, data warehouse, or data mart
-Predicting trends and behaviors -Identifying previously unknown patterns and relationships |
|
Define decision support systems (DSS) and name its models and commonly supported applications.
|
-Computer-based information systems that combine models and data in an attempt to analyze semistructured and some unstructured problems with extensive user involvement
--simplified representations, or abstractions, of reality ---Sensitivity analysis, what-if analysis, and goal-seeking analsis |
|
What is Sensitivity analysis
|
-A study of the impact that changes in one (or more) parts of a model may have on other parts
|
|
What is What-If analysis
|
-A study of changes in assumptions (input data) about a proposed solution and the possible impact of those changes
|
|
What is Goal-seeking analysis
|
-A study to find the input values necessary to achieve a desired level of output (backward solution)
|
|
What are BI Applications used for presenting results
|
- Dashboards (screens that have various data on various formats)
- Data visualization technologies - Real-time BI |
|
Real-time BI enables users to
|
-employ multidimensional analysis, data mining, and decision support systems to analyze data in real time
|
|
What are the types of dashboards
|
- Digital dashboards
- Management cockpit |
|
Digital dashboards do what
|
- Provide rapid access to timely info.
- Provide direct access to management reports - Are very user friendly and supported by graphics - Fig 5-3 and 5-5 |
|
What is a management cockpit and name 3 benefits.
|
-A strategic management room displaying a series of dashboards that helps managers pilot their businesses better
- Creates an environment that encourages more efficient management meetings and boosts team performance via effective communication -Displays key performance indicators and information relating to critical success factors graphically on the walls of the meeting room -Offers options for external information to be easily imported to the room for competitive analysis - Fig 5-6 |
|
What are the capabilities of dashboards
|
- drill down, critical success factors (CSFs). key performance indicators (KPIs), statues access, trend analysis, exception reporting
|
|
Drill down means
|
- The ability to go to details, at several levels. Can be done through a series of menus
|
|
Critical success factors (CSFs) are
|
- the factors most critical for the success of business. Can be organizational, industry, departmental, or for individual workers.
|
|
Key performance indicators (KPIs) are
|
- the specific measures of CSFs
|
|
Status access are
|
- The latest data available on KPIs or some other metric, often in real time.
|
|
Trend analysis are
|
- Short-term, medium-term, and long-term trend of KPIs or metrics, which are projected using forecasting methods.
|
|
Exception reports are
|
- Reports that highlight deviations larger than certain thresholds. Reports may include only deviations.
|
|
How do you make knowledge powerful
|
- With color to show correlation
- Size to show quantity - Data to display trends |
|
What are the three data visualization technologies
|
- Data visualization
- Geographic information systems (GIS) - Reality mining |
|
What is data visualization
|
-The process of presenting data to users in visual formats, thereby making IT applications more attractive and understandable to users
|
|
What are Geographic information systems (GIS) (2)
|
-A computer-based system for capturing, integrating, manipulating, and displaying data using digitized maps
-Geocoding |
|
Define geocoding and a benefit.
|
-The process of assigning a geographical location to every object
-Enables users to generate information for planning, problem solving, and decision making |
|
What are examples of Geographic info. systems (GIS)
|
-ESRI, Intergraph, Pitney Bowes Mapinfo
|
|
Name 2 benefits of reality mining.
|
-Uses GISs and Global Positioning Systems (GPSs) together
-Allows analysts to extract information from the usage patterns of mobile phones and other wireless devices |
|
BI in action is
|
- Corporate performance management (CPM)
|
|
CPM (Corporate Performance Management) does what
|
- Monitors and manages an organization's performance according to KPIs
|
|
Examples of KPIs are
|
- Revenue, return on investment (ROI), overhead, and operational costs
|
|
What's in IT for me (6 fields)
|
- Accounting, Finance, Marketing, Production/Operations Management, Human Resources Management, MIS
|
|
Accounting is involved with BI when (2)
|
- Auditors use BI to uncover irregularities
- CPAs use BI for risk analysis, cost control |
|
Finance is involved with BI by
|
Financial-related BI applications include stock market decisions, refinancing bonds, assessing debt risks, etc.
Marketing |
|
Marketing is involved with BI when
|
Marketers use BI for planning and executing marketing campaigns, allocating advertising budgets, evaluating alternative routings of salespeople, etc.
|
|
Production/Operations Management uses BI when
|
BI supports complex operations and production decisions, from inventory control to production planning to supply chain integration
|
|
BI and Human Resources Management are connected when:
|
BI applications can find resumes of applicants on the Web and sort them to match needed skills and to support management succession planning
|
|
What does MIS provide for BI
|
MIS provides the data infrastructure used in BI including building, deploying, and supporting BI applications
|