Data modelling in Power BI

Základní info

Popis kurzu

The course will include a mix of theory and practice, with an emphasis on best practices for financial and business reporting.


The course will include a mix of theory and practice, with an emphasis on best practices for financial and business reporting.

Určeno pro

Developers, analysts, marketers and data scientists.

Obsah kurzu


  • Data modeling concepts:  tables (fact tables, dimension tables), data types, relationships, filtering and cross-filtering.

  • Single-table models: Introduction of the data model, star schemas, naming conventions.

  • Header/detail tables: Importance of choosing the correct data model for improving performance and ensuring correctness of aggregate calculations.

  • Multiple fact tables: Handling different scenarios with multiple fact tables that are related to each other. Setting up bridge tables to handle complex models (for instance, orders and invoices).

  • Dashboards. Design principles and best practices.

Předpoklady


  • Power BI installed.

  • Basic familiarity with spreadsheet software (e.g. Microsoft Excel).

Studijní materiály

V angličtině

Data modelling in Power BI

Vybraný termín:

 Praha

Cena

Kontaktovat dodavatele


Kontrola proti spamu. Kolik je dvě a pět ? Součet zapište číslicemi.