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.
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. |