Archive Post Page
Using parameters – Prepare the data
Using parameters Let’s follow an example of how to use parameters in practice: Create a…
Creating functions – Prepare the data
Creating functions Power Query allows you to create your own functions, which can be useful…
Clean, transform, and load the data – Prepare the data
Skill 1.2: Clean, transform, and load the data Unless you are connecting to a dataset…
Identify data anomalies – Prepare the data
Identify data anomalies Power Query provides different functionality for identifying data anomalies depending on what…
Examine data structures and interrogate column properties – Prepare the data
Examine data structures and interrogate column properties In addition to column quality, you can look…
Interrogate data statistics – Prepare the data
Interrogate data statistics You can also profile columns to get some statistics and better understand…
Resolve inconsistencies, unexpected or null values, and data quality issues – Prepare the data
Resolve inconsistencies, unexpected or null values, and data quality issues If you followed the Wide…
Remove rows – Prepare the data
Remove rows If there are errors in a column, you may wish to remove the…
Identify and create appropriate keys for joins – Prepare the data
Identify and create appropriate keys for joins Power BI allows you to combine data from…
Keys for joins in Power Query – Prepare the data
Keys for joins in Power Query Power Query allows you to perform joins based on…
