JBI training

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 SQL Server 2005 Analysis Services (SSAS) Training Course UK

Dates and full course list


Advanced SQL Server 2005 Analysis Services (SSAS) Training Course Overview

Course Code: SQL100
Price: £1250
Duration: 3 days
Who should attend: Existing Database specialists who need to get more out of SQL Server 2005 Analysis Services for Data Warehousing and Data Mining.
Prerequisite Skills:

You should be able to understand table, column, data type design, and write SQL Select statements within any relational database; also to write SQL Server stored procedures. You should have experience of populating a Star Schema; and of designing, building and deploying simple SSAS cubes with the Cube Wizard.


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 2005 Analysis Services (SSAS).

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

Course Content

Our hands-on Advanced SSAS training course has been developed for real-world, commercial scenarios by our expert instructors.

See below for our detailed Advanced SQL Server 2005 Analysis Services training course syllabus. The course contains many SSAS tutorials based on real-world scenarios. If you have a technical question, please email .

Course Objectives

By the end of this course you will gain:

1. Cube design best practises and security
2. A deep understanding of MOLAP / ROLAP / HOLAP
3. MDX Queries and Scripts
4. Learn how to use XMLA to create, process and back-up Cubes
5. Effective Data Mining


Advanced SQL Server 2005 Analysis Services 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

UK training course Listing

.net 2.0 training course uk | asp.net 2.0 training course uk | SOA & ESB training course uk - Service Oriented Architecture Training Course | SOA for architects and managers training course | SOA for developers and designers training course | Spring training course uk | Hibernate training course uk | .net security training course uk | AJAX training course uk | ASP.NET AJAX training course uk (ATLAS training course uk) | .NET 2.0 Compact Framework training course uk | .NET training course uk | ASP.NET training course uk | advanced ASP.NET training course uk | .NET programming with C# training course uk | .NET programming with VB.NET training course uk | .NET Technologies and architecture Overview Seminar | .NET Web Services training course uk | SharePoint 2007 Training Course | BizTalk Server 2004 Training Course | BizTalk Server 2006 Training Course | Internet Technologies Overview Seminar | Java training course uk | J2EE training course uk | Java Advanced Programming Techniques Workshop | Java for C++ Programmers training course uk | Java Web Applications (JSP) training course uk | Java 2 Micro Edition (JavaME / J2ME) training course uk | Java Web Services training course uk | Java with WebSphere - WSAD training course uk | J2EE with WebSphere - WSAD training course uk | Weblogic / J2EE for Java training course uk | XML training course uk | XSLT training course uk | OO Analysis & Design with UML training course uk | SQL Server 2000 Applications Development training course uk | SQL Server 2000 DBA (Database Administration) training course uk | SQL Server Performance tuning training course uk | SQL Server 2005 programming training course | SQL Server 2005 DBA Administration Training Course | SQL Server 2005 Upgrade Training Course |javascript training course uk | dynamic html (DHTML) & javascript training course uk | oracle 9i intro to SQL training course uk | Oracle 9i DBA training course uk | Oracle Forms training course uk | Oracle Reports training course uk | asp training course uk | asp visual interdev training course uk | html training course uk | web design training course uk | unix basics training course uk | unix fundamentals training course uk | unix systems administration training course uk

Advanced SQL Server 2005 Analysis Services (SSAS) Training Course UK

::