Supporting Processes with ERP Systems
What is an ERP system and what is it used for?
Enterprise resource planning, very large enterprise IS that bring data together in a big database and help a company improve its processes.
- Type of software system that helps organizations automate and manage core business processes
What is the purpose of a database?
Databases keep track of things
Lists of data and themes
What is analytics, and why is it important to business?
Analytics is a process of acquiring, analyzing, and publishing data with an objective of discovering or revealing patterns in data that will inform an individual.
The business world is increasingly awash in data, and analytics IS are growing in their capacity to help businesses identify important patterns in that data.
What is the employment environment life for IS graduates?
Role of IT is growing
IS graduates job prospects are very bright
Growing demand IS careers
What do pivot tables accomplish?
Let you summarize and manipulate your data without changing anything in the worksheet.
What is SCM system and what is it used for?
Supply chain management, administration of supply chain processes
- Centralized management of the flow of goods and services to and from a company and includes all of the processes involved in transforming raw materials and components into final products
What are the contents of a database?
Database
Characters
Columns
Rows
Tables
Key: Primary and Foreign
What are the objectives of the analytics process?
Effectiveness: Informing
- Descriptive
- Predictive
- Prescriptive
Efficiency
- Time
- Cost
What are the duties of IT jobs? (Name three)
Duties:
Technology
Operations
Development
Outsourcing Relations
Chief Information Security Officer
What tab do you click on in Excel when creating a pivot table?
Insert tab
What is a CRM system and what is it used for? (look this up on the internet)
Customer relationship management, system for managing all of your company’s interactions with current and potential customers
What are the components of a database application system?
Database apps
Forms
Reports
Queries
Application programs
Multi-user processing
Enterprise DBMS
Personal DBMS
Database
DBMS
What are the key components of an analytics IS?
Hardware
Software
Data
Procedures
People
What are the titles of IT jobs?
Titles:
Chief Executive Officer
Chief Operating Officer
Chief Marketing Officer
VP Sales
VP Manufacturing
Chief Information Officer
Chief Financial Officer
VP Engineering
Chief Security Officer
What country is the Maple Game company based in?
Germany
Explain how the ERP system supports business strategies (look it up on the Internet)
Facilitating streamlined processes
Data integration
Real-time insights
Improved decision-making
Enhanced visibility
Scalability
Adaptability
Integration of strategic initiatives
How is a data model transformed into a database design?
Normalization: Converting poorly structured tables into two or more well-structured tables, data integrity problems, normalizing for data integrity
Representing relationships: 1:N relationships and N:M relationship
Converting a data model into tables and relationships and data constraints
How do businesses manage the risks of business intelligence?
Data problems:
- Dirty and missing data
- Data silos, data not integrated
- Wrong granularity
People Problems:
- Users
- Analysts
- Leaders
What IS-related job positions exist?
Business Analyst
Systems or IT Analyst
Security Analyst
Programmer
Technical Writer
Tech Support Engineer
Network Administrator
IT Consultant
Technical Salesperson
IT Project Manager
IT Manager
Database administrator
Data Administrator
Business Intelligence Analyst
Data Scientist
How many products do you sell?
What are the many reasons a company would implement an ERP systems? (look it up on the internet)
Promoting the free flow of communication and sharing of knowledge across an organization
Integrating systems for improved productivity and efficiencies
Increasing synergies across teams and departments
Improving internal business processes
Improving company performance
Reducing IT expenses and labor costs
Streamlining business processes
Automating several daily tasks
Why are NoSQL and Big Data important? (Look this up on the Internet)
Scalability
High availability
Ease of development, functionality, and scale
How does SAP do analytics?
All three analytics activities:
- SAP
- Microsoft
- Oracle
- Teradata
- IBM
- HP
Analyze and/ or Present Analytics Activities:
- Tableau
- SAS
- Open Source R
What do IT Professionals like about their jobs?
Challenging work
Interesting people
Variety of work
Work from home
How can you create profit or sell more products?
- Change the prices of certain products to adapt to the market
- Increase the price when you see the demand is increasing
- Decrease the price when you see the demand is decreasing
- Marketing expense should be very little
- Only Market to certain regions and products