Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: http://faculty.bus.oregonstate.edu/stylesheet/spacer.gif

Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Oregon State University

Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: http://faculty.bus.oregonstate.edu/stylesheet/spacer.gif

Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: http://faculty.bus.oregonstate.edu/stylesheet/spacer.gif

Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Oregon State University Home Page

Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: http://faculty.bus.oregonstate.edu/stylesheet/spacer.gif

 

Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: College of Business

BA574: Data Management

This is a hybrid course with most work online and 4 scheduled synchronous class sessions.

INSTRUCTOR

Byron Marshall, Ph.D.
Austin Hall 494
(541) 737-6054
byron.marshall@bus.oregonstate.edu
Byron's web site

OFFICE HOURS

  • On Webex: Monday’s 6-7PM 
  • Other weekly times TBD based on student preferences

I would enjoy talking to you!

 

 

Course Description

Familiarize students with the major activities involved in collecting and managing data for a data analytics project, including extracting information from relational databases, mapping organizational requirements into a data design, transforming data into information, exploring data warehouse concepts, and exploring basic concepts underlying noSQL data management and analysis methods. PREREQS: BA 573

Course Credits

This is a three unit graduate course. It is required for both the MBA with an option in Business Analytics and the Graduate Certificate in Business Analytics. The average student should expect to spend no less than 9 hours per week interacting with the course materials to achieve a satisfactory outcome.

Format

This is a hybrid course. Content and individual exercises are done online but regular team meetings are held in synchronous sessions with the instructor. An end-of-term project presentation is also help where teams will have a chance to see how other team’s projects illustrate course concepts.

 

Learning Resources

Much of the material from the class is provided in instructor-created study guides.

 

This is a good textbook – much of it will NOT go out of date. It is not a bad idea for a professional to have this one around. A few chapters from Database Systems: Design, Implementation, & Management (12th Edition) by Coronel & Morris will be required reading. Electronic copies of chapters can be obtained from https://www.cengagebrain.com/shop/ProductDisplay?langId=-1&storeId=10151&catalogId=10057&productId=742359

which also lists ISBN numbers so you can obtain the full text.

 

Optional: The Language of SQL is one of many introductory texts for structured query language. It lists for less than $20. Our coverage of SQL will go fast so you might consider this or some other SQL text to help you get an additional perspective on how to formulate queries.

Measurable Student Learning Outcomes

Students will be able to:

-       Define, differentiate, and apply key data management concepts in the context of organizational goals.

-       List and contrast types and components of data management systems.

-       Explain several strategies for improving the organizational value and performance of database systems.

-       Design and execute simple SQL queries.

-       Contribute to data design processes by composing entity-relationship diagrams.

-       List and explain key data integration issues commonly observed in multi-tiered, heterogeneous, and cloud-service data environments.

-       Compare SQL and NOSQL data structures identifying some strengths and weaknesses.

Evaluation of Student Performance

A key component for evaluation is the term project. Students will submit drafts of various components throughout the term so as to receive constructive criticism to support revision and to increase learning. Projects may be done in teams, expectations will adjust based on team size. Project elements are described in course documents but, in consultation with the instructor, students can adjust their projects to support individualized interests and learning objectives. Other activities including quizzes, walkthroughs, and other exercises will be assigned to explore course concepts and validate learning.

 

Basic concepts are covered assessed quizzes and graded exercises. Database activities and project deliverables develop and assess skills and apply concepts. Participation activities include interaction in class synchronous sessions. If you miss a synchronous session, alternate activities can be assigned to help you think through the material and to recover lost participation points.

 

Grading Scale

Activity

Percent of Total

First Drafts of Term Project Deliverables

15%

Final Term Project Deliverables

20%

Participation

20%

Data Management Exercises

20%

Concepts Quizzes and Exercises

25%

Course Content – Tentative Schedule

This plan is subject to change. In general, work is due on Saturday. Canvas should list all required elements and materials – this is just an overview.                                                                  

 


Week

Topic

Activities (In addition to online materials/assignments Provided in Canvas)

1

Information Concepts

 

2

Data Management – The Big Picture

3

Group Project Kickoff

Excel Exercises

SYNCHRONOUS CLASS  SESSION: Small Group Kickoff

4

Modelling Data Using ERDs

5

Normalization and SQL

SYNCHRONOUS CLASS SESSION: Entities and Relationships

6

More SQL

7

Data Design Perspectives

SYNCHRONOUS CLASS SESSION: A report-driven relational design

8

Non-relational data

Acquiring data from the Internet

SYNCHRONOUS CLASS SESSION: A report-driven relational design

9

MDM and Data Stewardship

10

Federated Data

COMBINED SYNCHRONOUS CLASS SESSIONS: Presenting your Term Projects

 

Statement Regarding Students with Disabilities

Accommodations are collaborative efforts between students, faculty, and Disability Access Services (DAS). Students with accommodations approved through DAS are responsible for contacting the faculty member in charge of the course prior to or during the first week of the term to discuss accommodations. Students who believe they are eligible for accommodations but who have not yet obtained approval through DAS should contact DAS immediately at 541-737-4098.

 

Academic Dishonesty: According to OSU student conduct regulations, academic dishonesty is defined as an intentional act of deception in which a student seeks to claim credit for the work or effort of another person or uses unauthorized materials or fabricated information in any academic work. Refer to the OSU Student Conduct code (576-015-0020) for a comprehensive definition of academic dishonesty. All cases of suspected academic dishonesty will be handled in strict accordance with OSU policy and College of Business policy.


COB
Code of Honor:


A code of honor represents the moral commitments of those abiding to it. While each person lives by his or her personal code, the establishment of collective values creates a universal goal to which we can aspire. It is through the pursuit of these professional attributes that we reduce the possibility of immoral actions ourselves.

In order to uphold our personal character and the organization that we proudly call our own, we take this oath.

Integrity
The quality of being honest and having strong moral principles, integrity stands as the backbone of character and is essential for success.

Respect
Respect for others and yourself is a commitment to the fair treatment of and the fair competition with others. Through respect we embolden the character of others and ourselves.

Responsibility
We are held accountable for our words and actions as professionals to embed a steadfast commitment to honor in our decisions.

 

Disability Accommodation: Accommodations are collaborative efforts between students, faculty and Disability Access Services (DAS). Students with accommodations approved through DAS are responsible for contacting the faculty member in charge of the course prior to or during the first week of the term to discuss accommodations. Students who believe they are eligible for accommodations but who have not yet obtained approval through DAS should contact DAS immediately at 737-4098.