Industrial Business Inteligence

Garant předmětu:

Lecturer:

Tutor:

Supervisor:

Department of Management and Economics

Synopsis:

The course is mainly focused on solving specific typical analytical and managerial tasks. The way of working in the course and the conditions of its successful completion correspond to this. The course is focused on various uses of SQL and Power BI tools, for the creation of virtual business data models and their possible visualization. It deals with the correct procedure of creating and evaluating different types of data. It emphasizes the work with appropriately designed data models and their managerial use. It focuses on the consistent creation of data models, including item calculations using appropriate methods and procedures. It shows the role of business data in engineering companies in their interaction and their importance for relevant management decisions. It shows how to proceed in the creation of data models of industrially oriented companies. It also includes the creation of the resulting dashboards for decision-making of managers at various levels. The prepared computer models are used to demonstrate important knowledge and connections.

Requirements:

Prerequisites: Basic economic and managerial knowledge. Requirements for students: Processing of all assigned tasks, their presentation and defense of solutions. Elaboration of semester work. Prescribed course attendance.

Syllabus of lectures:

1. Introduction to the course program. Rules of work before and at the seminar. Introduction to databases - database system and database management system. The role of manager and analyst. SQL and Business Intelligence tools and their importance.

2. Relational data model design methodology, E-R diagram.

3. Work on one's own task - data model design.

4. Practical database creation.

5. Design and creation of forms.

6. Basics of using SQL language.

7. Basics of data collection and processing using tools - Power Pivot (Excel / Power BI), including basic creation of BI models.

8. Basics of calculations (DAX) for possible interpretation of information. Different needs of managers at different levels.

9. Calculations (DAX) and their use for business practice.

10. Basics of presentation of managerial information, including data manipulation.

11. Introduction to reports and dashboards. Measuring company / project performance. Determining indicators and their explanatory power - KPI.

12. Analysis of the resulting information of engineering projects / companies, focusing on orders, revenues, costs, productivity, scrap, etc.

13. Final part - project presentation.

Syllabus of tutorials:

1. Introduction to the course program. Rules of work before and at the seminar. Creating teams. Introduction to databases - database system and database management system.

2. Relational data model design methodology, E-R diagram.

3. Work on one's own task - data model design.

4. Practical database creation.

5. Design and creation of forms.

6. Basics of using SQL language.

7. Basics of data collection and processing using tools - Power Pivot (Excel / Power BI), including basic creation of BI models.

8. Basics of calculations (DAX) for possible interpretation of information and business practice.

9. Calculations (DAX) and their use for business practice.

10. Basics of presentation of managerial information, including data manipulation.

11. Creation of reports and dashboards. Measuring business performance. Determining indicators and their explanatory power - creation of KPIs.

12. Analysis of the resulting information of engineering projects / companies, focusing on orders, revenues, costs, productivity, scrap, etc.

13. Final part - project presentation.

Study Objective:

The aim of the course is to acquaint students with common Structured Query Language (SQL) and Business Intelligence (BI) management tools that are practically usable, including the creation of their own data models. It is a set of methods and procedures that are often included in the so-called Business Intelligence tools for decision making. The purpose is to show how it is possible to proceed in normal engineering business practice and especially how to interpret the results obtained, and how to use them in managerial decisions. Students will be briefly instructed on the regularities of these tools in business practice. Understand the principles of applied regularities in corporate management information and their presentation.

Study materials:

(1) FEW, Stephen. Show me the numbers: designing tables and graphs to enlighten. Second edition. Burlingame: Analytics Press, [2012]. ISBN 978-0-9706019-7-1.

(2) FEW, Stephen. Information dashboard design: the effective visual communication of data. Sebastopol: O´Reilly, 2006. ISBN 978-0596100162.

(3) Cokins, G.: Activity-Based Cost Management, John Wiley and Sons

(4) JONES, Daniel. Power BI: a comprehensive beginner´s guide to learn the basics of power BI from A-Z. [místo vydání není známé]: Daniel Jones, [2019]. ISBN 9781705354414.

(5) TAYLOR, Ivana a Bill JELEN. Excel for Marketing Managers. Uniontown: Holy Macro! Books, 2006. ISBN 1-932802-13-4.

(6) Philip Seamark. Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence, 2018. ISBN 1484234766.

(7) Ramesh Sharda, Dursun Delen, Efraim Turban. BUSINESS INTELLIGENCE, ANALYTICS, AND DATA SCIENCE, 2017. ISBN 9781292220543.

(8) Ramakrishnan R'.:Database Management Systems,WCB/McGraw-Hill,1998 (EN).

(9) Korth H.F, Silberschatz,A.:Database System Concepts,McGRAW-HILL. 1996 (EN).

(10) Král, J.: Informační systémy, Science Velenity 1998, 358 str.,ISBN 80-86083-00-4 (CS).

(11) Hernandez, Michael J. Návrh databází. Přeložil Jan Bouda 1. vyd. Praha :GradaPublishing a.s.2006 (CS).

(12) Šimůnek, Milan SQL Kompletní kapesní průvodce Grada Publishing ISBN 80-7169-692-7 (CS).

Note:

Further information:

No time-table has been prepared for this course

The course is a part of the following study plans: