www.jbinternational.co.uk sales@jbinternational.co.uk Call Free 0800 028 6400

JB International 1345 High Road London, N20 9HR +44 (0) 20 8446 7555

 

Advanced Business Intelligence Training Course UK

Dates and full course list

 

Advanced Business Intelligence with SSAS and Performance Point Server 2007 Training Course Overview

Course Code:	SQL0140
Price:	£1995
Duration:	5 Days - custom / on-site options available - please call.
DATE:
Who should attend:	Experienced SQL Server 2005 / 2008 Business Intelligence analysts and developers
Prerequisite Skills:	Attendance of our SQL Server 2005 / 2008 Business Intelligence course, or equivalent experience.

This course has been written to give delegates with existing skills in Data Warehousing with SQL Server a framework of best practises. Delegates will gain a deep understanding of Cubes, Star Schemas, and Data Mining, using SQL Server Analysis Services (SSAS), and SQL Server Integration Services (SSIS).

Course Content

Our hands-on Advanced Business Intelligence with SSAS and SSIS training course has been developed with real-world, commercial scenarios in mind by our expert instructors. See below for detailed syllabus. If you have a technical question, please email

Available as a public or closed course at our London training centre, delivered on-site as a bespoke, customised training course.

What you will learn

•  Cube design best practises and security
• A deep understanding of MOLAP / ROLAP / HOLAP
• MDX Queries and Scripts
• Learn how to use XMLA to create, process and back-up Cubes
• Effective Data Mining
• Creating Business Rules
• Developing Dashboards
• Configuring Dimensions and Models
• Building Add-In Forms and Reports for Excel

 

Advanced Business Intelligence with SSAS and SSIS Training Course Outline

Using SSIS with SSAS

Star schema stored procedures in an SSIS package
SSAS cube processing in SSIS
Deploying and scheduling an SSIS package

Using SSRS with SSAS

Introduction to SSRS report wizard
Generating MDX queries to report on a cube
Generating DMX queries to report on a data mining model

Cube design

Creating a data source
Creating a data source view
Creating simple dimensions and measures

Dimension design

Building standard dimensions
Time dimensions
Role-playing dimensions
Parent-child dimensions

Measure group design

Adding measures
Configuring dimension usage (for multiple fact table cubes)
Aggregation functions
Calculated measures
Measure formatting

Aggregation design - MOLAP/ROLAP/HOLAP

MOLAP/ROLAP/HOLAP
Degree of aggregation
Optimising aggregations
Query log

Hierarchies design

Attribute hierarchies
Natural hierarchies
Report hierarchies
Multiple hierarchy dimensions

MDX language

Creating calculated members and measures
MDX queries introduction
MDX scripts
KPIs (key performance indicators)
SSAS stored procedures overview

Localising cubes

Currency conversion
Local language cube captions
Local language cube dimension members

Folders and perspectives

Organising large cubes into folders
Segmenting large cubes with perspectives

Cube actions

Drill through (as opposed to drill down)
Displaying reports directly from cube in a pivot table
Writing values back into the cube

Cube security

Dimension security
Cell-level security
Administration and user roles

Cube storage and processing

More on MOLAP/ROLAP/HOLAP
Creating partitions
Incrementally updating partitions
Pro-active caching (real-time cubes!)
Slowly changing dimensions

Cube deployment and administration

Backing up and restoring cubes
Deployment and processing options

XMLA and AMO languages

Introduction to XMLA
XMLA to create cubes
XMLA to back up cubes
XMLA to process cubes
AMO to control cubes

Data Mining

Overview of data mining
Building mining models
Processing mining models

Building Microsoft Office Excel Add-In Forms and Reports

Build an Excel Add-In report.
Configure an Excel Add-In report as a form.
Configure report filters.
Format an Excel Add-In report.

Developing Dashboards

Create a report by using the Dashboard Designer.
Add a data source connection.
Add a new Web page report.
Configure a Key Performance Indicator (KPI) by using the Dashboard Designer.
Create a scorecard.
Build a dashboard.