Power BI and Power Query can be used in combination to facilitate both basic and advanced operations. In this course, you'll learn how to use Power Query to create the two types of calculated columns, custom and conditional.

Next, you'll use Power BI to import and clean data and create stacked line charts (area charts) to visualize data. You'll filter the unique categorical values of the visualized series using various filtering techniques. You'll then combine data between tables using a foreign key relationship and create a bar chart with line markers using the analytics card.

You'll move on to import a large number of files residing in the same folder. Lastly, you'll use Power BI's UI and Advanced Editor to perform basic data cleaning operations and Power Query to perform various advanced operations.