Checking date: 15/04/2024

Course: 2024/2025

Data analytical techniques for business
(13475)
Dual Bachelor in International Studies and Business Administration (Plan: 505 - Estudio: 319)

Coordinating teacher: VELILLA CERDAN, SANTIAGO

Department assigned to the subject: Statistics Department

Type: Compulsory
ECTS Credits: 6.0 ECTS

Course:
Semester:

Requirements (Subjects that are assumed to be known)
Sequences: Statistics I-II Mathematics for Economics I-II Some familiarity with Microsoft Excel is also advisable.
Objectives
Advanced techniques of MIcrosoft Excel with applications in Business Analytics
Skills and learning outcomes
Description of contents: programme
The purpose of the course is to present an advanced revision of Business Anaytics techniques, based on the intensive use of Microsoft Excel 1. Introduction to BUSINESS ANALYTICS ** 1.1 Examples of Business Data ** 1.2 Numerical and graphical tasks ** 1.3 Business Analytics and Microsoft Excel 2. FUNDAMENTALS of Software ** 2.1 Introduction to Excel ** 2.2 Keyboard shortcuts and screen operators ** 2.3 Ranges in Excel ** 2.4 Excel functions and expressions ** 2.5 Tables and Pivot Tables ** 2.6 Filtering and Sorting ** 2.7 Charts with Excel ** 2.8 Dashboards ** 2.9 Conditional formatting ** 2.10 Importing text data into Excel ** 2.11 Importing data from the Internet ** 2.12 Matrices with Excel ** 2.13 Excel Add-Ins ** 2.14 Printing an Excel Workbook 3. REVIEW of elements of Statistics ** 3.1 Excel functions for exploratory data analysis ** 3.2 Stacked and unstacked data layouts ** 3.3 Histograms and Box-Plots with Excel ** 3.4.Multidimensional data ** 3.5 The data matrix ** 3.6 Different types of data ** 3.7 Mean vector. Covariance and correlation matrices ** 3.8 Centering and standardizing ** 3.9 Data reduction ** 3.10 The normal distribution. Distribution tables. Applications with Excel 4. SIMULATION techniques. ** 4.1 Basic simulation methods with Excel ** 4.2 Generation of univariate and multivariate normal data with Excel ** 4.3 Applications and examples with Excel 5. CASE analysis ** 5.1 Examples of real data applications in Business, Economics, Finance, and Marketing with Excel.
Learning activities and methodology
Competences will be acquired by students from: [I] Theory classes: one per week (14 sessions) [eventually online synchronous] [II] Practical classes: one per week (14 sessions) [face-to-face] Activities [I] and [II] will be devoted to exercises, problems, data examples, and case studies. Teaching will make intensive use of the resources available in Aula Global. In face-to-face sessions, the program is Microsoft Excel 2021 for Windows or Microsoft Excel 365. The University makes the latter available to the students for free. Online sessions will be recorded. The use of AI tools as ChatGPT as well as External Excel AI Tools Plugins such as Excel Formula Bot is welcome. Details are under consideration.
Assessment System
• % end-of-term-examination 50
• % of continuous assessment (assigments, laboratory, practicals...) 50

Calendar of Continuous assessment

Extraordinary call: regulations
Basic Bibliography
• ALBRIGHT, S. C. and WINSTON, W. L.. Business Analytics: Data Analysis and Decision Making, 7th Edition. Cengage Learning. 2019
• WINSTON, W. L.. Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365). Microsoft Press. 2021
Additional Bibliography
• ANDERSON, D. R., SWEENEY, D. J. and WILLIAMS, T. A. . Modern Business Statistics with Microsoft Excel, 7th Edition. Cengage Learning. 2021
• JELEN, B. . Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365). Microsoft Press. 2021

The course syllabus may change due academic events or other reasons.