Excel Business Intelligence: Power Query

via LinkedIn Learning

Overview

Discover the potential of Power Query with our "Excel Business Intelligence: Power Query" course, brought to you by LinkedIn Learning. Power Query, also recognized as Get & Transform or Get Data, is a standout feature in Microsoft Excel, offering advanced data gathering and cleansing functions. This course marks the beginning of the Excel Business Intelligence series and features expert Excel trainer Chris Dutton. He guides you through the extensive capabilities of Power Query, starting with an introduction to the Power Excel landscape and the appropriate occasions for employing business intelligence tools like Power Query, Power Pivot, and DAX.

Throughout the course, Chris Dutton delves into the essential query editing tools of Power Query, demonstrating how to effectively connect and transform your data. Gain insights into fundamental table transformations, text-specific query editing tools, and methods for merging and appending queries. Moreover, Chris imparts valuable best practices for optimally utilizing Power Query. This course is categorised under Data Analysis Courses and Microsoft Excel Courses, making it a perfect fit for professionals eager to enhance their Excel skills.