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 youll learn how to use Power Query to create the two types of calculated columns custom and conditional. Next youll use Power BI to import and clean data and create stacked line charts (area charts) to visualize data. Youll filter the unique categorical values of the visualized series using various filtering techniques. Youll then combine data between tables using a foreign key relationship and create a bar chart with line markers using the analytics card. Youll move on to import a large number of files residing in the same folder. Lastly youll use Power BIs UI and Advanced Editor to perform basic data cleaning operations and Power Query to perform various advanced operations.