This course will provide participants with a fundamental understanding of the functionality available in Microsoft Excel 2007 and complimentary products. This instructor-led course shows participants analysis techniques using Microsoft SQL Server Analysis Services’ cubes and ways of enhancing, customizing and managing information. Attendees will participate in hands-on demos and workshops that illustrate key concepts, whilst learning how to use the product.
In this session we will explore Microsoft’s vision for Business Intelligence and aim to familiarise users with Microsoft Excel 2007, complimentary products and terminology, topics include:
- Microsoft SQL Server Analysis Services.
- Online Analytical Processing (OLAP).
- Key Performance Indicators (KPIs);
- Microsoft SQL Server Reporting Services.
2: Connecting to Microsoft SQL Server Analysis Services’ Databases
In this session we will look at connecting to an Analysis Services’ database to retrieve data for analysis in Microsoft Excel 2007.
3: Analysing Cubes in Microsoft Excel 2007
- In this session we will concentrate on manipulating the data retrieved and describe how to create and work with pivot tables and charts, filter data and view data both on and offline, topics include:
- Creating pivot tables.
- Creating pivot charts.
- Stored Procedures.
- Adding hierarchies.
- Adding calculated sets.
- Viewing KPIs.
- Adding and configuring slicers.
- Browsing data offline.
4: Presenting Information
In this session we will discuss the various ways in which data can be displayed for presentation purposes, topics include:
- Creating graphs.
- Adding and configuring Sparklines.
- Conditional formatting.
- Icon sets.
5: Publishing Microsoft Excel 2007 Workbooks to Microsoft SharePoint 2010
In this session we will look at collaborative working and publishing Microsoft Excel 2007 workbooks to Microsoft SharePoint 2010.
6: Enhancing Basic Reports
In this session we will look at creating, testing, exploring and managing data mining models with data in a spreadsheet, using the SQL Server Data Mining Add-in for Microsoft Excel 2007.
“A wonderful course the trainer was amazing at answering any queries. She was extremely helpful and I would definitely recommend it.”
Student Systems Development Office, University of Sussex
Who should attend?
This course is intended for business and technical users who wish to analyse data using Microsoft Excel 2013.
- Experience of analysing data using Microsoft Excel 2010 or earlier.
Simpson Associates Customer Centre/ Customer Location
*Cost is for a course held at your or our site with a maximum of 6 delegates and includes a set of preconfigured laptops for the duration of the training and manuals for each delegate.