In this course you will learn basic analytic methods and analyze case studies on organizations that successfully deployed these techniques. The mian part of the course will focus on mastering Excels skills and application of BA techniques
Upon successful completion of this course you will be able to: - name challenges to decision making and understand how business analytics help to overcome them - identify, evaluate, and capture business analytic opportunities that create value - use MS Excel to analyse and present the data in an EFFICIENT way.
Prerequisiti
Basic computer skills.
Bringing your own laptop is required for the practical part of the course.
Metodi didattici
Flipped class Lectures In-class practical exercises Case study discussion
Verifica Apprendimento
Written exam
Testi
Required software: [details and instructions will be provided in class] - MS Excel (latest version, student license is enough) - Slack (used for communication and course anouncements)
Complementary readings: - Marr, B., (2017) Data Strategy, Kogan Page. - Rudder, C., (2014) Dataclysm. Who We Are When We Think No One’s Looking, Fourth Estate Ltd. - C. Nussbaumer Knaflic, C., (2015) Storytelling with Data, Wiley.
Contenuti
During the course, we will cover several topics: - Introduction to Business Analytics - Decision-making biases - Types of Business Analytics - Sources of data - Problem-solving with Business Analytics
The main focus will be put on Excel skills: - Formatting - Functions - Worksheet and Workbook Management - Visualization, Sorting, and Filtering Data - Summarizing Data with Pivot Tables - Comprehensive analysis
