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

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:

• 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 

• Power BI – data analysis and visualization
• DAX – Creating advanced formulas for Power BI, SQL Server Analysis Services and PowerPivot in Excel