In this course, we will move beyond static tables to master the Power BI workflow. You will learn how to take messy, raw data, clean it up efficiently, and transform it into interactive dashboards that support better economic and business decisions. We will focus on practical, real-world skills: from building robust data models to creating custom formulas that help you analyze trends and key indicators. By the end of this course, you will be able to design professional, visual reports that make complex information easy to understand and share.

P

Splnění doplňujících studijních povinností, jako docházka apod.

Hage, J.- Akkermans, B.: Introduction to Law, Springer, 2017

Honoré, T.: About Law: An Introduction, Oxford University Press, 2000

eur-lex.europa.eu – Portál aktuálních úprav práva EU, věstník nových zákonů

e-justice.europa.eu – Právní systémy a instituty v jednotlivých zemích EU – aktuální informace

The Constitution of the Czech Republic, The Charter of Fundamental Rights and Freedoms

R: Hage, J.- Akkermans, B.: Introduction to Law, Springer, 2017

R: Honoré, T.: About Law: An Introduction, Oxford University Press, 2000

A: eur-lex.europa.eu – Portál aktuálních úprav práva EU, věstník nových zákonů

A: e-justice.europa.eu – Právní systémy a instituty v jednotlivých zemích EU – aktuální informace

The Constitution of the Czech Republic, The Charter of Fundamental Rights and Freedoms

Povinné pole

Exam - written.

Credit based on:

zkouška ústní, písemná nebo kombinovaná, příp. podrobnější popis.

1.

1. Introduction to the Power BI Ecosystem: Course overview, installation of Microsoft Power

BI, and initial data loading into Power BI Desktop.

2. Working with Data Tables: Table styles, formatting, cross-filtering, and implementing basic

visualizations (Cards and Matrix).

3. Temporal Analysis: Techniques for handling date fields, visual calculations, and percentage

formatting.

4. Data Filtering Mechanisms: Utilizing slicers and visual-level filters for dynamic data

exploration.

5. Foundational Graph Visualization: Building clustered, stacked, and 100% column charts;

managing cross-filter visual interactions.

6. Advanced Graph Visualization: Trend analysis, forecasting techniques, and utilizing area

and specialized graph types.

7. Interactive Dashboards & Deployment: Designing interactive reports, incorporating

custom visualizations, and publishing to the Power BI Service.

8. Ecosystem Integration: Strategies for integrating Power BI with Microsoft Excel and

PowerPoint.

9. Introduction to DAX: Understanding calculated columns, date functions, formatting, and

building master date tables.

10. Advanced DAX & Querying: Implementing DAX measures, utilizing the Query View, and

practical application exercises.

11. Data Modeling & Relationships: Creating and managing relational structures to enable

complex analytical calculations.

12. Advanced Data Transformation: Utilizing the Power BI Query Editor for complex data

shaping and summary table creation.

13. Final Project: Synthesis of course skills through a comprehensive data analysis and

reporting project.

Students will be able to....(povinné pole)

Prosím nezapomeňte zeditovat také literaturu.

Pro případnou pozdější akreditaci je lepší do obou jazykových mutací textových polí uvést anglický text. S výjimkou anotace.