Description
Learn how Power Pivot and Power Query work together to provide Business Intelligence and reporting functionality.
Power Query and Power Pivot are two essential tools for anyone who needs to import, analyze, and manipulate large datasets in Excel, allowing them to turn raw data into meaningful insights, resulting in better decisionmaking. In this session, we will cover the fundamentals of these powerful data analysis tools that are built into Excel.
Power Query is used to import, transform, and merge data from multiple sources, whilst Power Pivot is used to create relationships (i.e., links) between multiple data sources, allowing you to create pivot tables from connected datasets, removing many of the limitations and frustrations that users find with creating traditional pivot tables in Excel.
In this presentation, you will learn, using practical examples, how Power Pivot and Power Query work together to provide Business Intelligence and reporting functionality within the familiar environment of Excel to provide you with better business insights and enable you to make more informed business decisions.
This training is aimed at users of Excel (2010 and above for Windows) who wish to learn about Power Pivot and Power Query. Attendees should have at least intermediate knowledge of Excel and be familiar with formulas and creating pivot tables.
Power Pivot may not be available for your version of Excel. If you are unsure whether this training is relevant for your version of Excel, please check with your IT department or see this link httpssupport.microsoft.comenusofficewhereispowerpivotaa64e2174b6e410b833720b87e1c2a4b
Users of versions of Excel prior to 2016 will need to download and install the Power Query addin. For 2016 and above, the functionality is built into Excel.
Date: 2023-07-18 Start Time: 1:00 PM ET End Time: 2:05 PM ET
Learning Objectives
* You will be able to discuss the fundamentals of the Power Query and Power Pivot tools.
* You will be able to explain how Power Query and Power Pivot can provide better business insights and enable informed business decisions.
* You will be able to describe how to import data into Excel and create pivot tables from multiple datasets.
* You will be able to review how to automate the datacleaning process.