Visualization of business data on BI platforms

2024/2025

Academic Year

ENG

Instruction in English

3

ECTS credits

Delivered at:

Department of Business Informatics and Operations Management

Course type:

Compulsory course

When:

1 year, 4 module

Instructors

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

Travin, Alexander

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.25 * Class participation and assignment + 0.25 * Final test + 0.5 * Project

Bibliography

Recommended Core Bibliography

• Power BI: моделирование на экспертном уровне : построение оптимальных моделей данных с использованием Power BI, Бахши, С., 2022
• Бахши, С. Power BI: моделирование на экспертном уровне / С. Бахши , перевод с английского А. Ю. Гинько. — Москва : ДМК Пресс, 2022. — 490 с. — ISBN 978-5-97060-906-4. — Текст : электронный // Лань : электронно-библиотечная система. — URL: https://e.lanbook.com/book/314864 (дата обращения: 00.00.0000). — Режим доступа: для авториз. пользователей.
• Говори на языке диаграмм: Пособие по визуальным коммуникациям, Желязны, Д., 2009
• Феррари, А. Подробное руководство по DAX / А. Феррари, М. Руссо , перевод с английского А. Ю. Гинько. — Москва : ДМК Пресс, 2021. — 776 с. — ISBN 978-5-97060-859-3. — Текст : электронный // Лань : электронно-библиотечная система. — URL: https://e.lanbook.com/book/190738 (дата обращения: 00.00.0000). — Режим доступа: для авториз. пользователей.

Recommended Additional Bibliography

• Данные: визуализируй, расскажи, используй. Сторителлинг в аналитике, Нафлик, К.Н., 2020

Authors

• Орлова Екатерина Дмитриевна