Power BI, Power Pivot, Power Query
Data from spreadsheet and files without structures
Duration
Start hour
Level
The aim of the training is to prepare participants to perform analyzes based on imported data, with particular
emphasis on data from Excel sheets and text files (csv, txt), using Power BI Desktop or Power Pivot and
Power Query tools.
Thanks to the training, the participant will be able to:
The training is intended for people who, using Power BI or the Power Pivot add-on, prepare interactive reports
based on data imported from unstructured sources (e.g. Excel sheets, text files).
Training participants are required to have basic knowledge of Power BI or the Power Pivot and Power Query
The training is carried out in the form of a case study - based on the data of a fictitious company, the
participants, together with the trainer, plan and implement the next stages of the analysis. Tasks are
performed jointly or individually with subsequent discussion. During the work, the trainer complements the
participants' knowledge with the necessary transformation techniques, introduces new functions, etc.
2 days, 16 training hours
Data model design:
Data adjustments:
Data Analysis, defining measures and calculated columns. Calculations based on data subsets; RELATED()
function, iterators, conditions and data lookup:
Data visualization:
