Home > Microsoft BI > OLAP Analysis using Microsoft Excel

OLAP Analysis using Microsoft Excel

Course Code:	BIMEOL
Currency:	Excel 2007/2010
Duration:	1 day
Audience:	Excel Power Users, Data Analysts and BI Consultants/BI Developers.
Prerequisites:	Completion of our course MS Excel Level 3: Advanced or equivalent knowledge.
Summary:	This hands-on course demonstrates demonstrates how to use Microsoft Excel PivotTables to analyse SQL Server Analysis Services cubes. Topics include: Connecting to SQL Server Analysis Services databases Online vs. offline OLAP Excel OLAP functions Best practices with OLAP PivotTables
Objectives:	Upon completion of this course, the delegate should be proficient with connecting to SQL Server Analysis Services cubes and perform data analysis using real-world scenarios.
Format:	Hands-on 65%, lecture 35%
Detailed Outline

Course Schedule