MODULE
Pivot tables and external data

In this module we are going to be looking at connecting to external data sources.  In particular we are going to be looking at using a CUBE database as utlimately we'll be connecting to a CUBE data from Accounts.

In this module we are going to be looking at...
Cubes
Cubes

A CUBE database is essentially a large set of data that can be accessed quickly and manipulated to produce reports.  Take a look at the links below to get a better understanding.

A CUBE database is essentially a large set of data...
Excel Tutorial: What is Business Intelligence and an OLAP Cube? | ExcelCentral.com
More information around OLAP cubes
Excel Tutorial: What is Business Intelligence and an OLAP Cube? | ExcelCentral.com
Duration (m)
-+
What are Dimensions and Measures?
Getting to grip with terminology.
What are Dimensions and Measures?
Duration (m)
-+
Excel and external data
We are going to see how we can connect to an external data source.
Excel and external data
Looking further
The following items are optional and have been added if you would like to find out more about this topic.
Looking further
Next: Precognition data