This course focuses entirely on Power Pivot, looking at the essential tools to turn your data into polished reports. It's designed to give you a solid understanding of the fundamentals of Power Pivot usage.
It looks at loading data into Power Pivot from various sources, creating table relationships to run powerful real-world reports from multiple tables.
You will perform data analysis by generating totals through Calculated Columns, then pulling those calculations into an Excel Pivot Table, incorporating a user-friendly dashboard.
It also concentrates on the DAX language (Data Analysis Expressions), the core capability of Power Pivot. This might sound complicated but if you are already familiar with some of Excel's formulas, it's a seamless progression.
Course attendees are required to be regular users of Excel and familiar with Pivot Tables before attending this Power Pivot Introduction course.