Type to search LearningTree.com

Do you mean "{{response.correctedQuery}}" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.

 

Business Intelligence Training









Preferred method of contact?

SQL Server Analysis Services for Business Intelligence

COURSE TYPE

Practitioner

Course Number

139

Duration

4 Days

Enroll

About This Course: 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 skills to analyze 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.

You Will Learn How To

  • Leverage SQL Server Analysis Services to produce BI solutions
  • Create OLAP cubes and automate maintenance with XMLA scripts
  • Extend hierarchies and exploit advanced dimension relationships
  • Build custom solutions with MDX
  • Implement key performance indicators to monitor business objectives
  • Make smarter business decisions with data-mining techniques

Course Outline

  • 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
  • Discretizing attribute values with the Clusters and Equal Areas algorithms

Parent-child relationships

  • Defining parent and key attributes
  • Generating level captions with Naming Template
  • 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
  • Utilizing 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
  • Implementing a Tabular Model Database
  • Providing users with analytics via xVelocity and Power Pivot
  • Comparing DAX with MDX
  • Mapping out the role of SharePoint
  • Managing Cubes

Designing storage and aggregations

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

Automating processing and deployment

  • Exploiting XMLA scripts and SSIS
  • Refreshing cubes with Proactive Caching
  • Performing Advanced Analysis with MDX

Retrieving data with MDX

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

Monitoring business performance with KPIs

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

Enhancing cubes with MDX

  • Adding runtime calculations to the cube
  • 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

Performing real-world predictions

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

Course Schedule

Attend this live, instructor-led course In-Class or Online via AnyWare.

Hassle-Free Enrollment: No advance payment required.
Tuition due 30 days after your course.

Nov 15 - 18 Herndon, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Nov 29 - Dec 2 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jan 3 - 6 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jan 31 - Feb 3 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Feb 7 - 10 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Mar 14 - 17 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Apr 11 - 14 New York/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Apr 25 - 28 Rockville, MD/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

May 9 - 12 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jun 20 - 23 Herndon, VA/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Jun 26 - 29 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Aug 1 - 4 Ottawa/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Aug 8 - 11 Toronto/AnyWare Enroll Now

How would you like to attend?

Live, Online via Anyware
In-Class

Guaranteed to Run

Show all dates
Show fewer dates

Bring this Course to Your Organization and Train Your Entire Team
For more information, call 1-888-843-8733 or click here

Tuition

Standard

$2990

Government

$2659

Course Tuition Includes:

After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.

Free Course Exam
You can take your course exam on the last day of your course and receive a Certificate of Achievement with the designation "Awarded with Distinction."

Prev
Next

Questions

Call 1-888-843-8733 or click here »

An experienced training advisor will happily answer any questions you may have and alert you to any tuition savings to
which you or your organization may be entitled.

Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm


FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:

  • Have a record of your growth and learning results.
  • Bring proof of your progress back to your organization
  • Earn credits toward industry certifications (if applicable)
  • Make progress toward one or more Learning Tree Specialist & Expert Certifications (if applicable)

Enhance Your Credentials with Professional Certification

Learning Tree's comprehensive training and exam preparation guarantees that you will gain the knowledge and confidence to achieve professional certification and advance your career.

This course qualifies for 23 CPE credits from the National Association of State Boards of Accountancy CPE program. Read more ...

"The SQL Server Analysis Services course has been tremendously helpful in learning to navigate in a cube environment and building my own. I use the hands-on exercises on a daily basis! When I returned to work, I repeated the steps we learned in the multi-to-multi relationship exercise and was able to make an unusual dimension relationship to a fact table that no one in my company thought was possible."

- I. Buryak, Database Developer
Tradeweb

Prev
Next