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.
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
  • Analyse more than 1 million rows of data;
  • Load data into PowerPivot; 
  • Filter data with Slicers; 
  • Easily create Relationships between tables of data; 
  • Create easy to use Dashboard view from PowerPivot; 
  • Learn the principles of the DAX formula language to create powerful new calculations; 
  • Create powerful new DAX measures in PivotTables such as year-to-date, month-to-date, previous month etc; 
  • Create dashboards with PowerPivot data.

Day 2:  Power View and Power Query
  • Introduction to Power View; 
  • Creating Tables and Matrix’s; 
  • Creating Column, Bar and Charts; 
  • Creating Line, Bubble and Scatterplots; 
  • Creating maps and geographic visualisations; 
  • Using Pop outs and advanced filters; 
  • Creating data relationships between tables; 
  • Filtering with Slicers; 
  • Creating interactive dashboards; 
  • Introduction to Power Query; 
  • Benefits of Power Query; 
  • Loading data into Power Query (Microsoft Access Tables, CSV Files, Online Data Sources, Modifying Tables); 
  • Merging Data; 
  • Appending Data; 
  • Unpivoting Data; 
  • Using the Group function; 
  • Creating Custom Calculations.
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.