Business Reporting: Visualizing & Merging Data in Power BI
“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.”