pivot and unpivot table

Combining queries

Append queries

Merge queris

Join

merge with join:

4 join type

left outer join

right outer join

full outer join

inner join

import concept:

join key

Transforming

staging area: pot- bowls-utensils

data profiling: check the view->column quality

->column profile : expamole when you want to check the age range, it will be show the range

reference quires

dataflow

data anomaly

M language

• Data Sources supported by Power BI
• Local datasets vs. shared datasets
• Storage modes in Power BI
• Structured vs. unstructured data
• PowerBI Connectors
• Triggers and Actions
• Data Types in Power BI
• The Applied Steps List
• Common Data Errors
• Pivot and Unpivot Columns
• Combining Tables with append
• Combining tables with merge
• Join Types
• Join Keys
• Loading Data
• The Staging Area in Power BI
• Profiling Data in Power BI
• Using the Data Profiling Tools
• Reference queries and dataflows
• Query Parameters
• Global options for files