Contactar esade

Analysis for Decision-Making in a Global Context (18CG20001)

General information

Type:

OB

Curs:

1

Period:

S semester

ECTS Credits:

4.5 ECTS

Teaching Staff:

Group Teacher Department Language

Prerequisites

Enrollment in the MS in Global Strategic Management/MS in Global Commerce Program

Previous Knowledge

Students are assumed to have a basic proficiency in the use of English language versions of Microsoft Windows and Microsoft Excel.

Workload distribution

On average, the class will meet for three 75-minute sessions per week, with more intensive class meetings schedule during the first month of class and in the final week of class. Student project teams will be expected to work collaboratively on their project and presentations outside of class. Individual assignments will also require additional computer lab work.

COURSE CONTRIBUTION TO PROGRAM

This course will provide students with experience using analytical skills to enhance decision making in a wide range of managerial scenarios. Through case studies and the use of current analytical tools and techniques, students will gain experience in identifying solutions to business problems, organizing evidence in support of organizational decision-making and strategy, and communicating analytical results. The class will explore how global firms use analysis to inform operational and strategic decisions.

Course Learning Objectives

Through this course, students will develop their abilities to:
- Complete a range of quantitative analysis techniques in Excel
- Organize and analyze data in Tableau
- Work individually and in teams to identify, plan, and execute appropriate quantitative analysis techniques to develop and visually document insights generated from data
- Articulate cultural differences in the use of quantitative evidence in organizational decision-making

Competencies developed:
- Quantitative analysis in Excel
- Data analysis with Tableau

CONTENT

1. Describing data using Excel PivotTables

2. Inference with statistics

3. Sensitivity analysis

4. Contingency analysis

5. Presentation of statistical analysis results with graphics in PowerPoints

6. Organizing data for analysis

7. Summarizing, filtering and grouping data

8. Visualization types for data representation

9. Creating interactive dashboards to combine and share visualizations

Methodology

Course material will be delivered via a combination of lectures, computer demonstrations, and in-class use of computer technology with instructor guidance. Students will also be required to develop and deliver team presentations.

Assessment criteria

Class Participation - 20%
Homework Assignments - 30%
Mid-Term Exams - 30%
Team Projects and Presentations (Group) - 20%

Bibliography

Basic Bibliography:
Fraser, Cynthia. Business Statistics for Competitive Advantage with Excel 2016: Basics, Model Building, Simulation and Cases. Springer Science & Business Media, 2016.

Additional Bibliography or Materials:
Additional short readings, technology tutorials, and videos to view online will be assigned.

Timetable and sections

Group Teacher Department

Timetable

Friday 2018/12/7 from 8:00 to 8:1.