Power BI

Teachers

Included in study programs

Teaching results

By completing the course, students will acquire knowledge, skills and competencies that they will be able to use effectively when working with data, creating reports and analyzing them. The learning outcomes contribute to fulfilling the goals of the study program.
After completing the course students:

A. To orientate themselves in the terminology of Business Intelligence and understand its importance for modern business. Know the basic components of the Power BI service and use the Power BI Desktop program.
B. Import data from various sources and use Power Query to clean and transform data.
C. Create and manage data models, including defining relationships between tables.
D. Use DAX (Data Analysis Expressions) functions for complex calculations and analyses.
E. Create and adapt different types of visuals, such as graphs, tables, and maps, to effectively present data. Add interactive elements and filters to reports to make them user-friendly and enable dynamic data analysis.
F. Read data from reports and analyze them, through interpretation of visuals, analysis of key metrics, comparison of data and identification of possible correlations and causes.

Indicative content

Introduction and basics:
Introducing the Power BI tool and its capabilities.
Overview of the main components: PowerBI Desktop, Power Query, and Power Pivot.
Working with data:
Import methods and data sources.
Data transformation for analysis.
Creating data models and defining relationships.
Data analysis and visualization:
Basics of the DAX language and its functions for statistical analysis.
Data visualization techniques in Power BI.
Reporting and information sharing:
Creating and publishing reports.
Report sharing and collaboration.
Analysis of output data and interactive work with report

Support literature

1. maggiesMSFT. (n.d.). Dokumentácia K službe power bi - power Bi. Power BI
Microsoft Learn. https://learn.microsoft.com/sk-sk/power-bi/
2. DaveBeasley. (n.d.). Použitie jazyka Dax v APLIKÁCII power bi desktop - training. Training
Microsoft Learn. https://learn.microsoft.com/sk-sk/training/paths/dax-power-bi/
3. Davidiseminger. (n.d.). Rýchly začiatok: Pripojenie údajov v APLIKÁCII Power Bi Desktop - Power Bi. Power BI
Microsoft Learn. https://learn.microsoft.com/sk-sk/power-bi/connect-data/desktop-quickstart-connect-to-data
4. Chmelár M.( 2022). Reporting v Power BI, PowerPivot a jazyk DAX. Spoločnosť Smart People
5. Aspin, A. (2020). Pro Power BI Desktop: Self-service analytics and data visualization for the power user. Apress.

Syllabus

1. Introduction to Power BI 2. PowerBI Desktop 3. Data Import and sources of data 4. Data transformation 5. Power Query 6. Data model and relationships between tables 7. Power Pivot 8. Data visualization 9. Introduction to the DAX language (Data Analysis Expression) 10. Statistical functions of the DAX language 11. Creation of reports 12. Publishing and sharing reports 13. Analysis of output data and work with the report

Requirements to complete the course

Continuous solution of tasks during exercises 50%, 51% of this obligation is required for the exam.
The final task verifies the achieved level of practical competences.
Final exam - written form, 50% (passing the exam means obtaining at least 51% of the exam evaluation) The theoretical part verifies the achieved level of theoretical competence results.

Student workload

3 credits x 26 hours= 78 hours
Study load distribution:
Seminar participation: 26 hours
Preparation for seminars: 13 hours
Project preparation: 13 hours
Preparation for the final exam: 26 hours

Language whose command is required to complete the course

Slovak

Date of approval: 04.03.2025

Date of the latest change: 05.10.2024