EXBI2013L4-008 Excel Business Intelligence Level 4
£360
EXBI2013L4-008 Excel Business Intelligence Level 4

EXBI2013L4-008 Excel Business Intelligence Level 4

Event Information

Share this event

Date and Time

Location

Location

Imagine Training Ltd

Marches Growth Hub

University of Wolverhampton, Priorslee Campus

Telford

TF2 9FT

United Kingdom

View Map

Friends Who Are Going
Event description

Description

This course is designed for an Advanced Excel user to Understand the capability of the new Business Intelligence tools in Excel and use them to create great data visualisations and dashboards.

Our Excel Business Intelligence course has been developed to fill the gap with this innovative new collection of add-on features in Microsoft Excel 2013 or above. Intended for Advanced Excel users this course runs through getting the BI modules installed, then how to use the 4 new tools – Power Query, Power Pivot, Power View and Power Maps.

How to Get BI Installed

First Steps


Power Query


Identify Data Sources Internally
Search for data publicly available
Previewing data
Security
Combining data from different sources
Sharing to collaborate with others
Power Pivot
Manipulating large amounts of data
Joining data from several tables
Creating & Editing Relationships between files and Tables
Power PivotTables and PivotCharts


Power View


Creating a new Dashboard
Using data from multiple sources
Types of Charts
Types of Tables
Using Filters
Deleting & Editing Dashboard elements
Refreshing Data


Power Maps


Launching Power Map
Creating New Maps
Layers
Geography and Map Level
Types of Map Themes
Adding Map Labels


Creating Video


Adding Scenes
Playing a Tour
Adding Music
Playing within PowerPoint

Pre-requisites

This course requires completion of Level 3 (Advanced) Excel training or equivalent experience. For example, you should already be competent at creating Pivot Tables and Advanced Charts to take full advantage of this Advanced Features class.

Please note - Excel BI features are only available within Microsoft Excel 2013 or above.

Share with friends

Date and Time

Location

Imagine Training Ltd

Marches Growth Hub

University of Wolverhampton, Priorslee Campus

Telford

TF2 9FT

United Kingdom

View Map

Save This Event

Event Saved