Cart (0)
Cart (0)
Course catalog
Last minute
Courses in english
New courses
About courses
Guarantees
Close

Microsoft Power BI Desktop

Microsoft Power BI Desktop is a full featured alternative to the Power BI addins / features that can be integrated into Microsoft Excel. Both alternatives are intended for the creation of corporate decision-making reports in whole range of the [...]
  • PBID
  • Duration 3 days
  • 0 ITK points
  • 14 terms

  • Praha (12 000 Kč)

    Brno (12 000 Kč)

    Bratislava (510 €)

  • Intermediate

Microsoft Power BI Desktop is a full featured alternative to the Power BI addins / features that can be integrated into Microsoft Excel. Both alternatives are intended for the creation of corporate decision-making reports in whole range of the problematics. These tools are able to access data stored in almost any format in the file system or in a variety of server data sources, perform variour data manipulation (like combination of individual datasets based on the interconnecting keys, additional calculations, creation of hierarchical structures, etc.), to data aggregation and presentation of results in the form of graphic reports. With Microsoft Power BI Destop you can get access to modern, sophisticated, flexible, but relatively simple method of creating business reports, regardless of Microsoft Office version used in your company.

»

For all users who need to quickly and efficiently create interactive corporate reports.

Any experiences with databases are great advantage for this training.

Application description

Data connection

  • Live connection
  • Imprts
  • Import from PowerPivot data model
  • Update options

Background queries (PowerQuery)

Data sources

  • Non-relational
  • Relational
  • Active vs. non-active relations
  • Cardinality of relations
  • Direction of cross-filter

Unexpected change of data source

Building of data model

Building & using calendar

Data categorization

Hierarchy

  • Single tabular
  • Multitabular
  • P\C hierarchies

Column DAX functions

Tabular DAX functions

Measures

KPI

Vizualization

  • Built-in
    • Tables + conditional formatting
    • Charts
    • R script visual
  • Custom
  • Customization of visual (demo)
  • Modification of tooltip help

Interaction

Data Drilling

Filers

  • Visual level
  • Page level
  • Report level

Roles

Publication

  • Power BI Services (Office 365)
    • Content packages
    • E-mail
    • Iframe
    • QR codes
  • Pyramid Analytics (paid)
Current offer
Training location
Course language

The prices are without VAT.

GOPAS Praha

Kodaňská 1441/46
101 00 Praha 10

GOPAS Brno

Nové sady 996/25
602 00 Brno

GOPAS Bratislava

Dr. Vladimíra Clementisa 10
Bratislava, 821 02

Business details

IN: 63911035
VATIN: CZ63911035

Datová schránka:
mi5ea5m

FAQ | Cookies Settings
Privacy Policy

Copyright © 2024 GOPAS, a.s., All rights reserved
Powered by nopCommerce

Copyright © 2024 GOPAS SR, a.s., All rights reserved

Designed by diorama