Microsoft Power Query and Power Pivot
With Power Query and Power Pivot in Excel, you'll spend less time manipulating data, and more time driving impact. Whether it's small data sets or large ones with up to millions of rows, in this course you will learn how you can connect, clean, analyse, and share your data faster using Power Query and Power Pivot. Note: This course is regularly updated to include the latest relevant AI releases and best practice.
Description
- Gain an overview of Pivot Tables
- Understand where you can find Power Query and Power Pivot
- Learn about basic business analytics features.
- Learn about advanced business analytics features.
- Discover fast, easy data gathering and shaping capabilities.
- Learn how to connect, transform, combine, and refine data sources.
- Understand the Data Model and how to create relationships stored as part of the workbook.
- Mash up large volumes of data from various sources.
- Use PivotTables, slicers, charts, and basic import capabilities.
- Perform powerful data analysis and create sophisticated data models.
- Perform information analysis rapidly, and share insights easily.