MIS 180 Study Guide - Final Guide: Data Warehouse
Internet and WWW
Focus on who, what, and how the Internet and WWW had formed how we do
business today
Origins
○
Protocols of the internet
○
Ecommerce
○
eBusiness
○
•
Network
Focus on components of networks
Protocols
○
Ethernet hardware
○
Wireless hardware
○
Topologies
○
•
Business Intelligence
Focus on data warehouse and dashboards and how they relate to Business
Analytics
Know where date comes from for a DW
○
Know the process for importing data into the DW
○
Know the tools used to in creating BI
○
Know how the dashboard relates to strategic plans
○
Know the components of the dashboard
○
•
Access and Excel
Focus on knowing the basic functions of each of these applications and how
they are used in business
Excel: IF Statements, count, goal, seek, conditional formatting, etc.
○
Access: entities, attributes, etc.
○
•
ERP, SCM, and CRM
Focus on the role each of these enterprise systems play in information systems
and how they support business functions, processes, and customer interactions
Centralized DB's and modularization
○
Players form upstream and downstream
○
Touchpoints with the customer and the value generated
○
•
SDLC and Adaptive Methodologies
Focus on the phases of the SDLC and how adaptive methodologies are used as
part of or in place of the SDLC
Purpose of each phase
○
Activities and tasks
○
•
Project Management
Focus on how business uses PM to meet the business goals•
MIS180 Final Exam Focus
Tuesday, May 1, 2018
5:10 PM
Document Summary
Focus on who, what, and how the internet and www had formed how we do business today. Focus on data warehouse and dashboards and how they relate to business. Know where date comes from for a dw. Know the process for importing data into the dw. Know the tools used to in creating bi. Know how the dashboard relates to strategic plans. Focus on knowing the basic functions of each of these applications and how they are used in business. Excel: if statements, count, goal, seek, conditional formatting, etc. Focus on the role each of these enterprise systems play in information systems. Focus on the role each of these enterprise systems play in information systems and how they support business functions, processes, and customer interactions. Touchpoints with the customer and the value generated. Focus on the phases of the sdlc and how adaptive methodologies are used as part of or in place of the sdlc.