Excel "Powers" Workshop
If you regularly work with Excel and have mastered Excel Pivot Tables for data analysis then this course is for you. Learn to create advanced Excel Business Intelligence dashboards using Power Pivot, Power View and Power Query.
Power Pivot gives you the ability to work with millions of rows of data, create relationships between tables and use the new DAX formula language to do powerful calculations.
Power Query gives you the ability to easily import, transform and manipulate your data for reporting and data analysis purposes.
Create interactive dashboards using tables, cards and graphs in an easy-to-use drag-and-drop environment with Power View.
Power Pivot gives you the ability to work with millions of rows of data, create relationships between tables and use the new DAX formula language to do powerful calculations.
Power Query gives you the ability to easily import, transform and manipulate your data for reporting and data analysis purposes.
Create interactive dashboards using tables, cards and graphs in an easy-to-use drag-and-drop environment with Power View.
This two-day course focuses on the foundations and understanding exactly how Power Pivot, Power View and Power Query work.
Workshop Content
Day 1: PowerPivot
Day 2: Power View and Power Query
|
Duration
2 days Requirements
Good knowledge of Excel, preferably having completed Advanced Excel: Pivot Tables and Pivot Charts Your own laptop with Excel 2013, with PowerPivot, Power View and Power Query. (If you do not have your own laptop, we can provide one for you to use for the course) Cost
R3 600 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. |