0800 282 353 or +44 1372 364610
Productivity through Education®
 
 

SQL Server® Analysis Services: Hands-On

Analysing Data for Business Intelligence
 
Course: 139   Duration: 4 Days
 
 

You Will Learn How To

  • Leverage SQL Server Analysis Services to produce business intelligence solutions
  • Create and deploy multidimensional data cubes
  • Extend hierarchies and exploit advanced dimension relationships
  • Build custom solutions with MDX
  • Implement key performance indicators (KPIs) to monitor business objectives
  • Make smarter business decisions with data mining techniques

Course Benefits

With the current explosion of data in today's enterprise environment, traditional methods of querying and reporting on information are no longer sufficient. This course provides the knowledge and skills to analyse and discover trends in your data warehouse. You learn to create On-Line Analytical Processing (OLAP) cubes using business intelligence tools and to automate their maintenance using XMLA scripts and SQL Server Integration Services (SSIS) packages.

Who Should Attend

Those designing, creating or developing analysis cubes from a database. A working knowledge of relational databases is assumed.

Hands-On Training

Throughout this course, you gain extensive experience with SQL Server Analysis Services. Practical exercises include:
  • Creating and deploying a cube
  • Building aggregations with the Aggregation Design Wizard
  • Automating cube processing with an XMLA script
  • Configuring many-to-many dimension relationships
  • Implementing an action to open a Reporting Services report
  • Retrieving data using MDX
  • Discovering key influencers with data mining

Related Courses

  • 134 SQL Server Integration Services
  • 1501 SharePoint 2010 Technologies Comprehensive Introduction
  • 532 SQL Server Transact-SQL Programming
  • 140 SQL Server 2008 Reporting Services
  • 535 High-Performance SQL Server Databases
  • 141 SQL Server High Availability
  • 534 SQL Queries for SQL Server
  • 2105 SQL Server 2012: DBA Skills Upgrade

 
SQL Server 2008 is a registered trademark of Microsoft Corporation.
   SQL Server Analysis Services

Upcoming Dates

Live online classroom training.Attend highlighted events in person or live, online via Learning Tree AnyWareTM.

UK Dates

13-16 MarLondon
12-15 JunLondon
18-21 SepLondon
18-21 DecLondon

US East Coast Dates

27-30 MarWashington, DC*
17-20 AprWashington, DC*
15-18 MayNew York*

*New York and Washington, DC Courses – Available online with a run time of 2pm to 9pm BST.

For AnyWare enrolments, please register at least 10 days prior to the start of the course.


For complete schedule, please visit www.learningtree.co.uk
 
http://www.learningtree.co.uk/courses/uk139.htm
 
 
0800 282 353 or +44 1372 364610
Productivity through Education®
 
 

SQL Server® Analysis Services: Hands-On

Analysing Data for Business Intelligence
 
Course: 139   Duration: 4 Days
 
 
Course Content
 

Building and Modifying an OLAP Cube

Designing a Unified Dimension Model (UDM)

  • Identifying measures and their suitable granularities
  • Adding new measure groups and creating custom measures

Creating dimensions

  • Implementing a Star and Snowflake Schema
  • Identifying role-play dimensions
  • Adding dimension attributes and properties
  • Configuring multilanguage support

Extending the Cube with Hierarchies

Creating hierarchies

  • Building natural hierarchies and creating attribute relationships
  • Distinguishing between ragged, balanced and unbalanced hierarchies
  • Discretising attribute values with the Clusters and Equal Areas algorithms

Parent-child relationships

  • Defining parent and key attributes
  • Generating level captions with the Naming Template feature
  • Removing repeated entries with the MembersWithData property

Exploiting Advanced Dimension Relationships

Storing dimension data in fact tables

  • Building a degenerate dimension
  • Configuring fact relationships

Saving space with referenced dimension relationships

  • Identifying candidates for referenced relationships
  • Utilising the Dimension Usage tab to configure referenced relationships

Including dimensions with many-to-many relationships

  • Implementing intermediate measure groups and dimensions
  • Reporting on many-to-many dimensions without double counting

Designing Optimal Cubes

Assembling cube components

  • Selecting the appropriate fact tables
  • Adding cube dimensions
  • Distinguishing between additive, semiadditive and nonadditive measures
  • Simplifying cubes with perspectives

Managing Cubes

Designing storage and aggregations

  • Choosing between ROLAP, MOLAP and HOLAP
  • Partitioning cubes for improved performance
  • Designing aggregations with the Aggregation Design Wizard
  • Leveraging the Usage-Based Optimisation Wizard

Automating processing and deployment

  • Exploiting XMLA scripts and SSIS
  • Refreshing cubes with Proactive Caching
  • Deploying cubes easily through the enterprise

Performing Advanced Analysis with MDX

Retrieving data with MDX

  • Defining tuples, sets and calculated members
  • Querying cubes with MDX
  • Utilising set functions

Monitoring business performance with KPIs

  • Building goal, status and trend expressions
  • Using PARALLELPERIOD to compare with past time periods
  • Simplifying KPI definitions using the KPIValue and KPIGoal functions

Enhancing cubes with MDX

  • Adding runtime calculations to the cube
  • Comparing MDX calculations with DSV calculated columns
  • Adding drill-through and URL actions

Gaining Business Advantage with Data Mining

Determining the correct model

  • Identifying business tasks for data mining
  • Training and testing data mining algorithms
  • Comparing algorithms with the accuracy chart and classification matrix
  • Optimising returns with the Profit Chart

Performing real-world predictions

  • Classifying with the Decision Trees, Neural Network and Naive Bayes algorithms
  • Predicting with the Time Series algorithm

Deploying models

  • Predicting new cases with algorithms
  • Utilising DMX to perform batch and singleton predictions
  • Exploring results with data mining viewers
 
http://www.learningtree.co.uk/courses/uk139.htm
 
 
0800 282 353 or +44 1372 364610
Productivity through Education®
 
 

SQL Server® Analysis Services: Hands-On

Analysing Data for Business Intelligence
 
Course: 139   Duration: 4 Days
 
 
Course Fees
£ 1,925Standard Fee
Fee with a Savings Plan
£ 1,2252-Course Passport
£ 1,0853-Course Passport
£ 1,0004-Course Passport
£ 1,600Voucher 10-Pack

Your Course Fee Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate
  • FREE participation in the Learning Tree Professional Certification Programmes (including related exams)
  
 

Savings Plans

2-Course Passport
  • 2 Courses in 12 months for £2,450
  • As little as £1,225 per course
  • Savings up to 45% per course
3-Course Passport
  • 3 Courses in 24 months for £3,250
  • As little as £1,085 per course
  • Savings up to 50% per course
4-Course Passport
  • 4 Courses in 24 months for £4,000
  • As little as £1,000 per course
  • Savings up to 55% per course
Training Vouchers
  • Save as much as £675 per course
  • Fully transferable
  • As low as £1,600 per course
* Exact savings may vary depending on courses selected.

Your Guarantee of Satisfaction

Unless you feel 100% satisfied that Learning Tree delivered even more than you expected, there is no fee for your course attendance. Our Guarantee of Quality lets you experience the value of the course - and then pay only if you feel the course was well worth the fee.

Enrolling is Easy and Flexible!

Enrol by phone or online. If your plans change, just let us know and, without a fee, you can transfer to another course or cancel your enrolment. Pay after you've taken the course, and then only if you are 100% satisfied.
 
http://www.learningtree.co.uk/courses/uk139.htm