This video explains Query Editor, how to connect Power BI Desktop to our data sources etc.

• Just to be sure: What is the Query Editor?
• Connecting Power BI Desktop to our data sources
• Editing rows
• Understanding append queries
• Editing columns
• Replacing values
• Formatting data
• Pivoting and unpivoting columns
• Splitting columns
• Creating a new group for our queries
• What we achieved until now and how to continue
• Introducing the star schema
• Duplicating and referencing queries
• Creating the DIM region table
• Entering data manually
• Merging queries
• Finishing the DIM region table
• Introducing the DIM age group table
• Creating an index column
• Duplicating columns and extracting Information
• Creating conditional columns
• Creating the Fact population table
• Performing basic mathematical operations
• Improving performance and loading data into the data model
• Module summary