Learn how to use the Excel add-ins Power Pivot and Power Query to manipulate, query, distribute and visualize your data.
Power Pivot, Power Query, Power View, 3D maps are free add-ins that expand and combine the features and capabilities of Excel. It includes the ability to import, manipulate and work with large amounts of data from a variety of data sources both inside and outside Excel.
This course will cover techniques for manipulating and querying data, the structure of DAX functions, ways to distribute and visualize data using Pivot Charts, Slicers, Sparklines, Timelines, Power View and 3D maps.
By the end of this course, users should be comfortable with navigating the Power Pivot and Power Query applications, manipulating data, creating queries and reports, using DAX functions, and distributing and visualizing data.
Prerequisites
Students should be comfortable using the Excel interface and have a firm understanding of how Excel works and what it is used for. Understanding and experience with formulas, functions, and PivotTables is strongly recommended.