The objective of this course is to learn how to organize and manipulate data for making critical business decisions. “Data Management” in this course includes both the analysis of various sizes and types of data and their synthesis into fact-based, data-driven recommendations with illustrating charts. The course teaches the use of advanced functions in Excel (e.g., Pivot tables, look-up functions, array formulas), the abstraction and representation of business situations as entity relationship diagrams, the transformation of such diagrams into database schemata, and the use of Structured Query Language to manipulate data. We will use MS Access as our database software. The course also includes hands-on experience with cloud-based databases.
By the end of this course students should be able to analyze data of varying sizes with varying tools and synthesize clear business recommendations. Our goal is to impart fundamental analytical skills that allow our students to exploit the data rich business environment of today.
There will be considerable use of “hands-on” exercises throughout the course to familiarize you with these topics. No specific computer skills are required. We will also use a few real life cases to understand the implications of critical data management issues. (4/12)
Lecture: 100min/wk and Recitation: 50min/wk