PowerPivot

Are you ready to take the next step in your Excel Business Intelligence journey?  Did you know that Microsoft PowerPivot is a free add-in for Excel 2010 and a component of Excel 2013 that will revolutionise the ability of business users to access, process and handle large amounts of data using Excel?  One of the major benefits of using PowerPivot is it's ability to analyse millions of rows of data - almost limitless amounts - removing the million row constraint of traditional Excel.

PowerPivot also brings powerful new capabilities such as easily creating relationships between tables, creating PivotTables from multiple tables of data using the new DAX formula language and creating interactive dashboards with slicers.
On this one-day course you'll discover that Power Pivot provides the next level of reporting and analysis tools for the Excel user, with the ability to process millions of rows of data quickly and easily.
Workshop Content
Benefits of PowerPivot
Loading a data file
Browse, filter and sort PowerPivot data
Creating PivotTables from PowerPivot
Filtering with Slicers
Creating Hierarchies
Creating relationships with PowerPivot
DAX Formulas
Date functions in PowerPivot
Creating a date table
Examples of text and logical functions
Using the related function
DAX Measures
Date measure calculations
The calculate formula
Creating named sets
Using named sets for measures
Creating KPI's
Duration
1 day  
Requirements
Completion of Advanced Excel

Your own laptop with Excel 2010 or 2013, with PowerPivot loaded.
(If you do not have your own laptop, we can provide one for you to use for the course)  
Cost
R1 800 per person excluding VAT
Price is for training in Gauteng.
Price is for in-house training for 6 people or more.
Valid until 31 December 2017.

​We are happy to discuss all your training needs and work with you to meet your requirements.