Arena Training Course Length:
3 hours
Course Description
Do you already use Excel PivotTables for data analysis? Did you realize that there is an add-in to extend a PivotTable’s capabilities called Power Pivot? If you have experience working with Excel PivotTables and are versed in functions and formulas in Excel, this workshop may be for you.
If you need to analyze data quickly with drill-down ability, you may want to check out this workshop. Power Pivot can help you organize, manipulate, and report on your data by extending the features of the PivotTable. If you think this will be helpful, but have not worked with PivotTables, sign up for Data Analysis with Pivot Tables Workshop first to make the most of the PowerPivot class.
Course Objectives:
Upon successful completion of this course, you will be able to use the Power Pivot add-in to analyze data from a variety of sources.
You will:
Target Student:
Students taking this course are experienced Excel users who are seeking to advance their data-analysis capabilities by using Power Pivot.
Prerequisites:
You should have experience working with Excel PivotTables.
Course Content
Lesson 1: Getting Started with Power Pivot
Topic A: Enable and Navigate Power Pivot
Topic B: Manage Data Relationships
Lesson 2: Visualizing Power Pivot Data
Topic A: Create a Power Pivot Report
Topic B: Create Calculations in Power Pivot
Lesson 3: Working with Advanced Functionality in Power Pivot
Topic A: Create a Key Performance Indicator
Topic B: Work with Dates and Time in Power Pivot
Appendix A: Commonly Used DAX Functions