Learn how to use Microsoft Excel Power Pivot to handle and analyse data from various sources, and create attractive visual models using calculated fields with DAX formula language.
Description
In this recorded webinar, you will learn how to utilise Power Pivot for Excel, a powerful tool that allows for business intelligence in a familiar environment. Learn how to work with big data, combine data from different sources, create visually appealing analytical models, and use DAX formula language to create calculated fields for slicing and dicing data.
Using a practical exercise and segmented into short lessons for ease of learning, this webinar will help you develop and enhance the technology skills that are important for financial professionals.
Key topics:
- Introduction to Power Pivot
- Setting up Power Pivot
- Loading, linking ad updating data
- Power Pivot formulas and Data Analysis Expressions (DAX)
- Power Pivot reports
As part of this webinar you will receive,
- Downloadable worksheets with practical tasks to embed the knowledge
- A learning manual with step-by-step instructions
This recorded webinar is delivered by Excel expert and trainer, Marcus Small. Click here for Marcus' biography.
Course updated: May 2023
Learning objectives
- Demonstrate a Power Pivot report
- Use Power Pivot formulas and Data Analysis Expressions (DAX)
- Connect your enterprise databases, analyse data, create advanced reports and prepare dashboards using Excel Power Pivot.
