Import data from different sources into the Power Query editor; discovery of the main Power Query transformation tools; create relationships between different tables and optimize the data model; introduction to the key concepts of data modeling (primary keys, cardinalities, dimensions, etc.; discovery of the DAX (Data Analysis Expression) language and essential functions; creating Calculated Columns and Measures in DAX; design techniques and best practices dashboards and reports in Power BI Desktop.
