Final Review Flashcards
(24 cards)
Information center professionals
Primary responsibility is moving info about people, products, and processes across the company to facilitate decision making and problem solving
Ex: addressing technology issues, writing code, help desk support
Transactional processing systems (TPS)
Support the monitoring, collection, storage, and processing of data from basic business transactions
Form the foundation of operational level information systems
Decision making at different organizational levels
Operational level - employees use transactional information for structured decisions
Different information needs exist at tactical and strategic levels
Enterprise resource planning
Heart of an ERP system is a central data base that connects all modules
Support cross departmental process that originate in one department and end in a different department or involve another department
Provide a foundation for collaboration between departments
Enable communication between business areas
Store critical knowledge for organizational decision making
Decision support systems (DSS) vs executive information systems (EIS)
EIS requires data from external sources to support unstructured decisions
DSS typically used internal sources to support semi structured decision
Ex of DSS applications - risk assessment insurance, medical diagnosis systems
Manufacturing dashboards are typically not DSS systems
Customer relationship management (CRM)
Split into operational CRM (front office, customer facing) and analytical CRM (back office, strategic analysis
Manages all aspects of customer relationships to increase loyalty, retention, and profitability
Supply chain management systems
Designed to coordinate raw material purchases from different suppliers for finished products
Manages information flows to maximize supply chain effectiveness and profitability
Business process reengineering
Improved business by identifying inefficiencies in current workflow
Not about copying competitors or just buying advanced technology
Business process models
Show the sequence of tasks necessary to complete a business activity
Different from storyboards or general information systems
On premise systems
All hardware and software are owned by the company using the systems
Different from “software as a service” model
Systems development lifecycle
Designed phase includes interface design to ensure usability and user experience
Other phases include requirements gathering and process diagramming
User interface design principles
Make interface easy to learn
Create consistency within and across interfaces
Provide feedback to users
DO allow users to go backwards
Pivot tables
Used to determine total quarterly sales by salesperson from transaction data
Dynamic interactive table that quickly summarizes large amounts of data
“Values” field would use the sales field for summing data
Conditional statements
=IF(B2>2400,”Party”,” “) displays party when value in B2 exceeds 2400
VLOOKUP syntax
Use $J$2:$L$6 format to maintain absolute references to lookup table
SUM formula for range
=SUM(A1:A10)
Average formula
=AVERAGE(B1:B20)
Cell references
Relative reference change when copied absolute references don’t
Data value characteristics
Data type, timeliness, quality, and governance
High quality data
Accurate, complete, consistent, timely, and unique
Database keys
Primary - a records unique identifier
Foreign - references the primary key in another table
Data integrity and transactions
Data integrity constraints- rules that restrict what values can be stored in a database
Database transaction - a unit of work performed within a database system
Data Warehousing and business intelligence
ETL - extract transform load
Operational database - support daily operations and transitions
Data warehouse - support complex analytical queries and decision making
Data dictionary - physical database structure storing table relationships
Day visitations
Pie chart - best for showing parts of a whole
Line charts - best for showing trends overtime
