SQL Server Analysis Services with MDX
Duration: 5 Days
This course starts by building an understanding of the business intelligence platform enabled by SQL Server and the Microsoft Office System, highlighting the role of Analysis Services. It continues by creating a simple multidimensional OLAP cube and progressively adding features to help improve, secure, deploy, and maintain an Analysis Services database. Core Analysis Services 2008 features and capabilities, including dimension, cube, and aggregation design wizards are covered. In depth coverage of using MDX with Analysis Services to deliver high-performance business intelligence solutions is included. The student will learn how to assemble time-based business metrics and then customize an Analysis Services cube through the MDX scripts. Depending on student backgrounds, advanced MDX queries will be covered as time allows.
Topics Covered In This Course
Business Intelligence: A Data Analysis Foundation
Understanding OLAP and Analysis Services
Accessing Source Data
Creating a Cube
Creating Advanced Measures and Calculations
Advanced Dimension Design
Working with Account Intelligence
Currency Conversion and Multiple Languages
Interacting with a Cube
Using the MDX Query Editor
Working with Sets
Working with Expressions
Building Complex Sets
Working with Time
Enhancing the Cube with T-SQL
Implementing Dynamic Security
Managing Partitions and Database Processing
Advanced Monitoring and Management Tools
Advanced MDX Topics (as many as time allows)
What You Can Expect
At the end of this course, students will be able to:
Who Should Take This Course
This course is designed for Developers, Designers, or anyone interested in working with data warehouse data.
Instructor led with 50% lecture and 50% lab.
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]