This two-part course starts with an in-depth look at Pivot Tables, after all, that's where data from Power Pivot ends up when running reports. Then progresses to an introduction to Power Pivot.
The first part looks at creating and managing Pivot Tables, working with its layouts, value formats and running various calculation analysis. You will be creating Pivot Charts and Slicers to create a user-friendly dashboard.
The second part focuses on the essential tools within Power Pivot, loading data into Power Pivot from various sources, querying and extracting data, running Calculated Columns, and includes an introduction to the powerful DAX language (Data Analysis Expressions).
At the end of this course you will have the skills to run reports in Pivot Tables, then analyse data with Power Pivot's Data Model. You will understand the versatility of table relationships, and create a dashboard to confidently produce professional reports.
Attendees are required to be Excel users before joining this Pivot Table and Power Pivot course.