Power BI, Power Pivot, Power Query

- data from spreadsheet and files without structures
    Czas trwania
    Godzina rozpoczęcia
    Stopień trudności

      Power Pivot, Power Query - data from spreadsheet and files without structures

      About training

      During the training, participants build a data model for a specific case, the individual aspects of which correspond to situations encountered in reality, and then prepare its analysis. At the same time, they consolidate previously used and learn new data transformation techniques as well as selected DAX formulas and functions. 

      View the training programme

      What will you gain from the training?

      Training objectives 

      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. During the training, participants build a data model for a specific case, the individual aspects of which correspond to situations encountered in reality, and then prepare its analysis. At the same time, they consolidate previously used and learn new data transformation techniques as well as selected DAX formulas and functions. After the training, participants will be able to plan and build a data model based on imported data, add calculated columns, define measures and complete the analysis with a report.

      Skills 

      Thanks to the training, the participant will be able to:

      • Correctly planned the structure of the data model
      • transformed the imported data into a form ready for analysis
      • connected tables with relations, including preparation of columns - keys
      • add calculated columns to the data model and define measures
      • used DAX functions - iterators, conditions, search, filters, CALCULATE function, time analysis function
      • prepared a table of dates
      • defined custom sorting
      • clearly presented data in the report
      Is this training for you?

      Audience profile

      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).

      Requirements 

      Training participants are required to have basic knowledge of Power BI or the Power Pivot and Power Query.

      Duration

      Duration:

      • 2 days, 8 teaching hours each
      Detailed training program

      Detailed training program

      Data model design:

      • Source data logic
      • Definition of output structure
      • Final table layout incl. relationships

      Data adjustments:

      • Transforming data from source to final shape
      • Automated file merging in folders
      • Preparing tables for relationships

      Data Analysis, defining measures and calculated columns. Calculations based on data subsets; RELATED() function, iterators, conditions and data lookup:

      • Focused analysis – filters, CALCULATE() function, context modifiers
      • Analysis over time – comparison and cumulative values, date table

      Data visualization:

      • Choosing right visual component
      • Filters and slicers
      • Slicer formatting

      Download file

      Training delivery method

      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.

      Development path

      Podobne tematy