This one day intensive workshop will provide you with the knowledge to make best use of Excel’s Business Intelligence tools to mash up, analyse and visualise your data. By the end of this course you will be able to use Excel Power Pivot tools confidently. Many of the topics covered are only available in Office Professional Plus 2013 or higher. If you have an earlier version we do not recommend taking this course.
This one day intensive workshop will provide you with the knowledge to make best use of Excel’s Business Intelligence tools to mash up, analyse and visualise your data. By the end of this course you will be able to use Excel Power Pivot tools confidently and be able to:
Anyone wishing to be able to display large quantities of data in an easy to view format.
You need to be a proficient user of Excel at least to our Intermediate level standard, preferably advanced. We do send out a pre-course assessment to ensure that everyone is at the right level
To be able to get the best from this course you need to have Office Professional Plus 2013 or higher installed on your PC (we do provide the PCs for you to train on here). It is possible on 2010 but there is a big difference and we train on version 2013 so you may not be able to take back all of what you have learned and use it quite so easily.
We start this session with an overview of the Excel BI tools and ensure that you know how to enable them. We look at the data we will be using to create the Power Pivot reports throughout the day and answer the following:
In order to use Power Pivot effectively, data needs to be in the correct format. In this part of the workshop we share tips on how to:
It is important that you can use the Power Pivot tool effectively and know how to how to:
During this part of the workshop you learn how to:
This session is an overview of Data Analysis eXpressions (DAX) formula language and covers:
The workshop finishes with a brief overview of Power View and Power Map (known as 3D maps in Excel 2016); topics include: