Visualization of business data on BI platforms

2024/2025

Учебный год

ENG

Обучение ведется на английском языке

3

Кредиты

Лучший по критерию «Полезность курса для Вашей будущей карьеры»

Лучший по критерию «Полезность курса для расширения кругозора и разностороннего развития»

Кто читает:

Департамент бизнес-информатики и операционного менеджмента

Статус:

Курс обязательный

Когда читается:

1-й курс, 4 модуль

Преподаватели

Замяткин Владислав Андреевич

Травин Александр Сергеевич

Course Syllabus

Abstract

The activity of any company implies the formation of a system of indicators of its work and their presentation in a visual and convenient for making managerial decisions. The aim of the course is to master the theoretical foundations and acquire practical skills in developing information and analytical dashboards. On the example of real cases the stages of creating such dashboards of different levels of complexity are considered: from the formation of requirements to their full technical implementation.

Learning Objectives

• The aim of the course is to teach students modern methods and tools of data visualization using BI platforms. Throughout the course, students will learn the key stages of working with data, including data preparation, data modelling, data visualisation and building interactive dashboards. This will help develop the skills necessary for effective data presentation and data-driven management decision-making.

Expected Learning Outcomes

• Knowledge of principles and methodologies of data preparation for analysis (cleansing, transformation, integration)
• Knowledge of the basics of data modeling (Star and Snowflake schemas)
• Ability to apply various techniques of data preparation using Power Query tool
• Ability to create data models, set up links between tables
• Ability to write simple expressions in DAX query language to calculate indicators
• Knowledge of basic principles and stages of dashboard development
• The ability to select and use appropriate types of visualisation in order to draw conclusions for making data-based managerial decisions

Course Contents

• Building dashboards
• Data vizualization
• Data modeling
• Data preparation
• Course outline. Visualization of business data on BI platforms

Assessment Elements

• Class participation and assignment
• Final test
• Project

Interim Assessment

• 2024/2025 4th module
  0.5 * Project + 0.25 * Final test + 0.25 * Class participation and assignment

Bibliography

Recommended Core Bibliography

• The definitive guide to DAX : business intelligence for Microsoft Power BI, SQL server analysis services, and Excel, Russo, M., 2020

Recommended Additional Bibliography

• Management information systems. A managerial and user perspective, O'Brien J, 1993

Authors

• Orlova Ekaterina Dmitrievna