Learning Objectives

This course is designed for learners who need to understand the principles of designing and using databases, particularly in business intelligence and business analytics capacities. It discusses the concepts, techniques, and tools necessary to develop a working application using a relational database management system (DBMS). The specific topics covered include conceptual data modeling, logical database design, database administration, and data warehousing. Learners spend a great deal of time learning and using the structured query language (SQL) and use it within a DBMS, such as Oracle. The major ideas and techniques presented in the course are reinforced through the work on successive segments of a group project.

The course will involve multiple short, individual assessments and a group project. While some project–related assignments will be well specified, others may be purposely less specified or less structured because an objective of these assignments is for you to not only solve the problems posed, but also to learn how to approach database design and development situations in general.

Specific learning objectives for the MIS 533 course are:

1. Define key terms related to database management

2. List the components of a typical database environment

3. Describe the life cycle of a data-centric systems application

4. Explain the various schemas used in the contemporary environment

5. Identify the entities and relationships in a business scenario

6. Identify the business rules contained within a business scenario

7. Draw an ER diagram with entities, relationships, and attributes

8. Differentiate between relationship and entity types

9. Revise ER diagrams to incorporate time-dependent data.

10. Extend ER diagrams to incorporate super-types and sub-types.

11. Explain what is meant by a relation and candidate key

12. Define first, second, and third normal form

13. Create a logical set of relations from an ERD or Extended ERD

14. Create relational tables with entity integrity and referential integrity constraints

15. Apply normalization to break a relation with anomalies into well-structured relations.

16. Write single-table queries using SQL commands

17. Impose referential integrity using SQL commands

18. Write multiple-table queries using SQL commands

19. Define a database using SQL data definition language

20. Explain the term data warehouse

21. Name the three levels in a data warehouse architecture

22. Describe the components of a star schema

23. Create a star scheme from a given scenario

24. Compute the number of rows and total size, in bytes, of a fact table.

25. Explain the term data mart and the circumstances in which a data mart may be created

26. Describe data governance

27. List ways in which data quality can be improved

28. Identify different data integration approaches

29. Explain the components of extract, transform, and load (ETL) processes

30. Identify security problems associated with databases

31. Explain database backup and recovery processes

32. Define concurrency control

Learning Outcomes

This course aims to provide you with the basic concepts and skills you need to analyze the database requirements for a business information system as well as to design and implement the logical structure of the resulting database. Upon successful completion of the course, you should be able to do the following:

1. Describe database management processes and explain the importance of these processes.

2. Interpret a business scenario and determine the database requirements of that scenario.

3. Create Entity-Relationship diagrams (ERDs) from a business scenario.

4. Translate ERDs into normalized logical relations.

5. Write simple and complex data retrieval and maintenance commands in Structured Query Language (SQL)

6. Implement a simple database.

7. Describe basic data warehousing concepts

8. Identify major data administration tasks, including security control, backup and recovery, and concurrency control.

This course is the sequel to MIS 536, Business Analytics Foundations. It introduces more advanced BA concepts and tools, with the emphasis on mining wider variety of data for business value, for example, text, web, and social media. It is aimed at equipping students with basic statistical/computing skills, analytical thinking, and business acumen. Students will leave the class with a broad set of practical data analytic skills based on building real analytic applications on real data.

LEARNING OUTCOMES

1. Explain the key components in a data analytic thinking process,

2. Access, prepare, and transform data,

3. Build classification and clustering models of reasonable complexity and performance,

4. Analyze and interpret such models and apply them to new data,

5. Evaluate and, if needed, improve the quality/performance of such models.

LEARNING OBJECTIVES

1. Explain the key components in a data analytic thinking process,

2. Access data through NoSQL databases and web APIs,

3. Prepare and transform data with simple Java or Python programs,

4. Given a reasonably sized dataset, and depending on the business needs, build classification and clustering models with tools such as Weka,

5. Analyze and interpret such models and apply them to new data,

6. Evaluate model performance using standard measures such as accuracy, precision, and recall,

7. Formulate business analytics problems and solutions by recruiting multiple modeling tools and data sources

Course Objective

Learn the basic concepts of business models, business processes, workflow, and design thinking. Learn to link business models to business processes, focus on enabling innovation through business processes, and apply design-thinking principles to process design. Learn process performance metrics, design and implement process improvements and change management. Focus on business process automation.

Learning Outcomes

•Understand concepts of business models, work flow, business process, and design thinking

•Develop and apply skills to develop and analyze business models

•Develop and apply skills to design and analyze business processes

•Develop and apply skills of design thinking to business processes

•Develop and apply skills to measure business process performance

•Develop and apply skills to implement new or improved business processes

•Develop business process automation skills

Course Objective

Learn the basic concepts of business models, business processes, workflow, and design thinking. Learn to link business models to business processes, focus on enabling innovation through business processes, and apply design-thinking principles to process design. Learn process performance metrics, design and implement process improvements and change management. Focus on business process automation.

Learning Outcomes

•Understand concepts of business models, work flow, business process, and design thinking

•Develop and apply skills to develop and analyze business models

•Develop and apply skills to design and analyze business processes

•Develop and apply skills of design thinking to business processes

•Develop and apply skills to measure business process performance

•Develop and apply skills to implement new or improved business processes

•Develop business process automation skills

Course Objective

Learn the basic concepts of business models, business processes, workflow, and design thinking. Learn to link business models to business processes, focus on enabling innovation through business processes, and apply design-thinking principles to process design. Learn process performance metrics, design and implement process improvements and change management. Focus on business process automation.

Learning Outcomes

•Understand concepts of business models, work flow, business process, and design thinking

•Develop and apply skills to develop and analyze business models

•Develop and apply skills to design and analyze business processes

•Develop and apply skills of design thinking to business processes

•Develop and apply skills to measure business process performance

•Develop and apply skills to implement new or improved business processes

•Develop business process automation skills

Course Objective

Learn the basic concepts of business models, business processes, workflow, and design thinking. Learn to link business models to business processes, focus on enabling innovation through business processes, and apply design-thinking principles to process design. Learn process performance metrics, design and implement process improvements and change management. Focus on business process automation.

Learning Outcomes

•Understand concepts of business models, work flow, business process, and design thinking

•Develop and apply skills to develop and analyze business models

•Develop and apply skills to design and analyze business processes

•Develop and apply skills of design thinking to business processes

•Develop and apply skills to measure business process performance

•Develop and apply skills to implement new or improved business processes

•Develop business process automation skills

An introduction to basic concepts and the tools in Business Analytics (BA). Hands-on lab exercises and business case studies on data preparation, data representation, data visualization, and most importantly data mining. The focus is on predictive analytics; descriptive and prescriptive Analytics will also be explored.